May 20, 2016 at 11:15 am
Hi,
I have had to make the jump from Crystal Reports to SSRS so I'm still learning.... I am developing the reports in Visual Studio 2013.
My issue is that I can't seem to figure out how to properly align a sub report value on my main report. :crazy:
On the main report I have several lines of project data and I use the sub report to pass in each corresponding total revenue amount for
each project. The total revenue contained in the sub report will not line up with the corresponding project even though it's on the same line...
I tried adding a rectangle and placing the sub report in there to bypass the snap to grid feature but that won't work. If I move the sub report too high in the report,
I end up getting an error that to me, seems as though SSRS does not know which dataset to get the field I use to link to the sub report with. (I link the main to sub report using a start and end date parameter and a project Id parameter. The project id parameter is in 2 datasets).
Does anyone have any ideas how I can fix this? I have added an attachment showing screenshots of the report display, main and sub reports.
Thanks!!
May 20, 2016 at 11:46 am
Why aren't you just calculating your revenue in your main report?
An alternative would be to include your project information in your sub-report.
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
May 20, 2016 at 1:50 pm
I tried calculating the total revenue by adding a sub-query to the main query but couldn't get the sub-query to properly sum when there are a series of tables that require joining in order to pull the correct amounts...
The report is practically done already except for this alignment issue... I can't believe SSRS won't let me align it. It's like the tablix border or whatever you call it - is getting in the way....
May 20, 2016 at 2:11 pm
Did you try a CROSS APPLY instead of a subquery?
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
May 20, 2016 at 2:32 pm
Have not worked with "CROSS APPLY" before. I will google that.. at first glance.. I'm looking for an equivalent for Oracle 11g
May 20, 2016 at 4:36 pm
Update: I was able to get the total revenue value from a sub-query after all!!
Thank you!
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy