Hi! I'm using Report Studio 8.3 and am pretty sure that there's a simple solution to what I've been fighting with today. I've done some research and tried several things, but haven't had any luck yet.
i have a fairly simple report of two blocks: one with a table (query1) and one with a crosstab (query2). the data represents supply and workorder information for a specific part number so all the information fits nicely on one page. but since they will need to have this for more than one part, I'd like them to be able to choose multiple parts numbers and create one page per part number. so I've figured out to use a repeater and have my search/select prompt working fine so that they get one page per part number selected, but...
... my crosstab(using query2) wants to total all the data for all the items selected in every instance of the crosstab, not just for the item that is specific to repeater cell. the top portion of the report (query1) works just fine.
If i run the report for only one part, the values of the crosstab are accurate, so I've tried multiple combinations of the Aggregate Function/RollupAggregate Function properties thinking that might be the problem with no luck. I've also set the Auto Group & Summarize to "no" on the query itself with no help as well.
the repeater table itself has query1 in it's query property, but since it allowed me to add the crosstab using query2 i didn't think that was a problem. if i try to change it to query2, i get errors in the 1st block containint query1 data.
This is my first time using a crosstab in a repeater so I'm sure there's a very obvious solution, I'm just not seeing it.
I'd greatly appreciate any help with this, so thanks in advance!
Set up a master detail relationship between the crosstab and repeater. To do this select the crosstab and choose Master Detail relationships in the properties window. Add a new link between part number in query1 and part number in query2. Hopefully it will work correctly now.
worked like a charm!
(haven't done much with Master/Detail Relationships either!)
thanks so much
Rebekah