December 9, 2009 at 8:57 pm
Apologies if this question has come up before; it's not the easiest topic to search for and I haven't found any answers yet.
I'm considering alternatives to Hyperion and SSRS has come up. I've built some reports with SSRS but they're kinda limited in their scope and functionality. I want to be able to do more complex things, like have a "multi-section" report (probably using sub-reports, with each "section" appearing on a new page with obvious links back to the front page) and, importantly, have a parameter selection page at the front of my report which pushes parameters through to the sub-reports. For want of a better description, I'll relate it to Excel. I want parameter selection on Book1, Data Set A (let's call it Organisations) on Book2 and Data Set B (a Map, for instance) on Book3.
The reports I've created in past seem to limit parameters to the top of a single-section report. These can take up a lot of real estate and the one-section layout is not flexible enough for me.
I realise my question might be a bit vague. Any recommendations as to how I might find out more about building such a beast?
Sam
December 10, 2009 at 8:49 am
Sure you can do what you mention in your example. You don't even need subreport, unless you are basing the subreport on data in the main report dataset.
You would use multiple data areas, like 3 tables for example, and in the properties of the second and third tables you set the Page Break Before property to True which would put each area on a new page. Each table can either reference the same dataset or you can have a separate dataset for each table. Each dataset can use the report parameters to provide values to the query parameters. Then you can also use the bookmark property in the first table to set a bookmark id and reference that in the navigation properites of a textbox in the later reports.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply