Sunday, February 19, 2012

HELP: Alternates from a Subreport?

Hello, I'm sorta new to SSRS and had a question hopefully someone can answer. Right now I'm using a stored procedure in oracle to pass the first set of data to my report. My report is fairly simple in that it is a header a detail row and a footer for totals. There isnt any grouping or sorting of data, it just displays basically exactly what the stored procedure passes it. It's a list of customers and their information. Here is the tricky part where I am having trouble.

One of the columns is for Social Security Numbers(SSNs) and the stored procedure doesnt send the SSN. The SSN is passed from another query that is dependent on the customers ID number. So, as of right now in the details section under the SSN column I put a subreport for the SSNs. Also, some customers have more than one SSN so the subreport creates more rows according to the how many it needs to display all the SSNs. I like this because it doesnt repeat all the customers information for every SSN they have.

But where I work they dont want to have multiple files for every report and just want to keep 1 report with 1 report file. So, how can I accomplish this exact same report without using a subreport?

Hope someone can help me and thanks ahead of time.

-Evan

I put the same post on MSDN forums and this is what the solution was:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2466993&SiteID=1

No comments:

Post a Comment