I’ve used Cognos Series 7, Cognos Series 8, Crystal Reports, Business Objects XI R2 WebIntelligence, Reporting Services 2000, Reporting Services 2005, and Reporting Services 2008. Here’s my feedback on what I’ve learned: Reporting Services 2008/2005/2000 PROS Cost: Cheapest enterprise business intelligence solution if you are using MS SQL Server as a back-end. You also have … Read more
You should move the constraints on prescriptions.filldate into the ON condition of the join, and remove it from the where clause: LEFT OUTER JOIN prescriptions ON prescriber.dea_no = prescriptions.dea_no AND prescriptions.filldate >= ’09-01-12′ AND prescriptions.filldate <= ’09-17-12′ Otherwise, entries for which there are no prescriptions end up with nulls in prescriptions.filldate, and the WHERE clause … Read more
I’ve worked with all the major reporting tools and each has their plusses and minuses. About the only “plus” on SQL Report Services side is that there’s no additional $$ expenditure above the SQL Server license. The downside is that the report designer is probably the most child-like of all. Crystal has been around forever, … Read more
If you are using a report server, then perform the following steps: Be sure you’re on a version of IE this will not work correctly in Chrome Go to your report server Click on … , on top-right of your report name Click on ‘Manage’ Click on ‘Data Sources’ Make sure that Connect to: settings … Read more
Randall, here are the VB expressions I found to work in SSRS to obtain the first and last days of any month, using the current month as a reference: First day of last month: =dateadd(“m”,-1,dateserial(year(Today),month(Today),1)) First day of this month: =dateadd(“m”,0,dateserial(year(Today),month(Today),1)) First day of next month: =dateadd(“m”,1,dateserial(year(Today),month(Today),1)) Last day of last month: =dateadd(“m”,0,dateserial(year(Today),month(Today),0)) Last day … Read more
I actually ran into a similar problem where a change I needed to make resulted in an “Undocumented Error/Invalid RDL Structure” error in 2016, so I edited the RDL file so I could open it in an earlier version and make my changes. Not too hard, but you need to make a couple of tag … Read more
Something like this should do it: Assembly assembly = Assembly.LoadFrom(“Reports.dll”); Stream stream = assembly.GetManifestResourceStream(“Reports.MyReport.rdlc”); reportViewer.LocalReport.LoadReportDefinition(stream);
To repeat rows with column headings for a table with row groups In Design view, select the table. The Grouping pane displays the row groups. On right side of the Grouping pane, click the down arrow, and then click Advanced. The Grouping pane displays static and dynamic tablix members for each group. You can only … Read more
SSRS is a server-based reporting system whereas Telerik Reporting is purely an embedded reporting tool. You should compare Telerik Reporting to SSRS ReportViewer control in local processing mode, not the whole SSRS system, unless you intend to use the SSRS server too. I think this is the first question to answer: you should evaluate the … Read more
Correct, the Report Definition Language is just XML. And, as with any other file, you can just open it (File/Open/File…) in Visual Studio, just like in a text editor. In order to see a designer you need to give Visual Studio a bit of context about what sort of file it is by making it … Read more