I was facing a weird issue on SSRS (SQL Server Reporting Services) wherein each page of my report was setup to show Header Row, but was actually not.
I had an SSRS table (Tablix) which was setup to repeat header rows on each page of my SSRS report. This option must be setup as shown below:
Despite setting up as shown above, it was not repeating the header row on all pages, except the first one.
Upon digging more on this, I got to visit a blog named Business Intelligence Chronicles by Christo Olivier. The post which saved (taught) me on how to overcome this issue is: Header Row Does Not Repeat On Subsequent Pages.
It’s very informative and crystal clear in terms of how it explained the steps to follow.
I had earlier posted about this ongoing series; not long back. To know what it is exactly, read it here: Report Writer Series.
The new post on this series discusses about how to create custom report writer reports.
In March 2012 (precisely 6th March 2012), Microsoft made available SQL Server 2012 Performance Dashboard Reports which can be used to identify whether there is a current bottleneck on the system, and if so, capture additional diagnostic data that may be required to resolve it.
More information on this can be read from the download page: Microsoft SQL Server 2012 Performance Dashboard Reports.
One point worth to be highlighted is that this doesn’t require Reporting Services to be installed.
It’s a very crucial and important tool for any database administrator.
Report Writer has been considered by most of the clients as static and bland reporting tool, due to it’s look & feel and it’s rigidity in terms of modifying the reports.
But, Report Writer is an amazing reporting tool, if only people know how it’s structured technically and how to bend it for our requirements. I am not certainly talking about customers. It’s the consultants’ responsibility to convince customers by demonstrating the power of Report Writer.
Over at Kuntz Consulting blog, series of posts are to be read to understand Report Writer as a tool and how to use it for our betterment. Following are the posts that are already been posted:
- Report Writer Demystified – Part 1 – Dictionaries & Launch Files
- Report Writer Demystified – Part 2 – Other Considerations
- Report Writer Series – Formatting Text
- Report Writer Series – Don’t Settle for Ugly Reports – Part 1
- Report Writer Series – Don’t Settle for Ugly Reports – Part 2
- Report Writer Series – Toolbox Tips
- Report Writer Series – Drawing Options Tips
- Report Writer Series – Sections
And it’s only going to get more on this series.
Worth reading for all those who would want to know about this silent performer, that is Report Writer.
There are several methods to achieve limiting number of records per page on a crystal report.
But this method, from a blogger named Pankaj Lalwani, seems to be very simple and effective. Check his post here: Limiting Number of Records to be Displayed on Crystal Report.
Version won’t matter in this case, since the solution what he proposes uses most common functions/operators, unless the latest version of crystal reports have an in-built settings for DETAILS section in Section Expert (which I doubt it would be).
Those who want to know how to add/use Extender Fields on a Report Writer report, Mark’s Weekly Dynamic post, Extender and Report Writer walks us thru’ simple steps with a real time scenario.
There are also links to relevant KB articles which will form the base for your task.
Boy, I never thought this “3rd Party” series would have such an impact (be it simple or silly or critical).
Patrick explains us one such very important but simple issue: Using 3rd Party Series Reports in the Report Template Maintenance Lookup Window
I have to now check all my customizations’ resources which are created under this 3rd Party series.
And when I reassign the series for those resources, I am not certainly going to place it in PROJECT series. As Patrick quips in his post in one place, if you read it completely.