Problem showing/splitting data on a single report page 1

[HuskerAv]

I'm unsure at this point how to present the problem I'm having developing a requested report with SSRS. The db View that I've been given to work with, along with the requested formatting of the report itself, are static so I'm restricted as far as what I can do (although I may be able to get the View changed or a SP added, if needed). The View data is as shown below.

'Short'-ish version of my problem - the View has Sales information for two types of sales
(normal and discounted, apparently?). The requested format of the report is to have each Rep's sales on separate pages of the report, and have separate displays of each type of sale, i.e. RepName at top of page, with two different tables showing Sale and DiscountedSale information separately. I have a report created for both types, but when I try to add the DiscSale report as a SubReport to the Sale report, I get the expected problems. I have no known way to ensure that the data being used for both on a page are for the same SalesRep and don't know how to determine the unique datapoint (RepFullName) for each page. Even if I did I don't know how to create that relationship in SSRS. I haven't even brought up what I know will be a 'future issue' for this - all SalesReps do NOT have available records
for both types of Sales, so I don't know how to account for a linked report (Main or Sub) that returns no records without that in turn impacting the User records after that.

I apologize if the description of my problem sounds cryptic or muddled, but that's how my brain is currently functioning and dealing with this, to be honest! If anyone can understand what my problems are and be able to point me in the right direction for resolving this I'd be greatly appreciative!

Available View Fields
DayOfCharge, RepFullName, ManagerFullName, ChargeNumber, ProductID, SaleStart, SaleEnd, SaleTime, DiscStart, DiscEnd, DiscTime, ProductName, Description

Thank You!!
Patrick

 

[drtree]

Hi Patrick,

I think that you have a few options on how you do this (I've had to do similar things in the past).

You could set up a list and have it group by the Sales Rep's Name, and then put two table objects into the list and filter them based on the list's current sales rep. The list would loop through the sales reps in your dataset and then filter each table based on the same rep (since the tables would be contained in the list). Check out this google search: Link

The other option would be to set up a single table - group it by the Sales Rep Name (with page breaks in between each instance of the group) and then have the data filtered by setting up some blank rows in between the Sale and Discount Sale reports. This approach only really works if you have the same number of columns in each report though.

Hope that helps,

doc tree

 

[HuskerAv]

You rock, doc! From first glance at the recommended Google links it does look like there may be an answer out there for me after all (and of course I don't have equal column counts for both Sales types, but thanks for the suggestion!).

Patrick