Avatar of JeffStone
JeffStone
Flag for United States of America asked on

SSRS Subreports and grouping

I am a newbie here.
I have created three reports and have made each of them a subreport of a wrapper report.  

right now they display info for 1 entity, lets say a store.  instead of calling this report individually for each store I would like to create a report for all stores but maintain the format of the report.

Current Report format
 -- subreport 1
 -- subreport 2
 -- subreport 3

I would like to have this format repeated for each "store"

any thoughts or perhaps pointing me in the right direction?
.NET ProgrammingMicrosoft SQL Server 2005DB Reporting Tools

Avatar of undefined
Last Comment
JeffStone

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
PFrog

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
JeffStone

ASKER
awesome, I will try it later today ... knee deep into something today.
JeffStone

ASKER
ok, this is what I did
1. created a dataset that returns the storeids
2. I added a list and put the subreports into the list containier
3. In each of the subreports on in the list I changed the parameter value from parameters! to fields! for each of the three subreports

When I preview the report, I get an error about the 'storeid' ...
Error 1 [rsFieldReference] The Value expression for the subreport xxx refers to the field StoreId.  Report item expressions can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope

any thoughts?
JeffStone

ASKER
I deleted and reinserted my subreports and am now getting the error storeid parameter is missing a value ... any thoughts?

and yes, I did setup the parameter.
Your help has saved me hundreds of hours of internet surfing.
fblack61
PFrog

SSRS is case sensitive - make sure they all spellings have exactly the same upper/lower case letters
JeffStone

ASKER
I had started with a wrapper and copied it (i was being lazy).  once I started from scratch and set everything up ... all worked well.  on  side note, any ideas on how to get paging on the subreports so for each new instance the paging restarts?
PFrog

Chris Hays has god a good blog post on how to customise page numbers

http://blogs.msdn.com/chrishays/archive/2006/01/05/ResetPageNumberOnGroup.aspx
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
JeffStone

ASKER
I am doing something similar (above) and the above seems to work in a preview state within VS2005 but when I export to PDF or pull from the reportserver website in PDF format, the first report starts off at page 2 ... any thoughts?
PFrog

Hmm, if it works in html and BIDS preview, then it sounds like a bug in the PDF rendering engine.

However I've not tried it myself so I can't confirm this.
When you don't use this function, do the normal page numbers (Globals!PageNumber) return starting at 1?
JeffStone

ASKER
yes, it seems like on PDF generation the page is visited a couple of times prior to writing ... I also have the problem of blank last pages ... all that is there is a blank page w/ a footer at the end of each group.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes