Issues with aligning subreport with corresponding row in main report

  • 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!!

  • 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

  • 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....

  • Did you try a CROSS APPLY instead of a subquery?

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

  • Have not worked with "CROSS APPLY" before. I will google that.. at first glance.. I'm looking for an equivalent for Oracle 11g

  • 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