February 7, 2008 at 10:52 pm
I have just finished building a report in SSRS that links to secondary reports.
I was asked a question today as to whether we are able to split the report page down the middle and hyperlink between initial and secondary reports within the one screen.
I have a feeling this needs to be done in Sharepoint, though Id appreciate some advice if anyone has any.
Thanks in advance.
Samantha
February 8, 2008 at 9:21 am
if you want to split a report into 2 pages, please put a rectangle control after that section. go into property of rectangle and set up a page break after. you want to make this rectangle very, very small, so it won't mess up your space. i hope this helps.
February 10, 2008 at 3:04 pm
Thanks, Ill give it a go 🙂
February 11, 2008 at 8:16 am
The other suggestion will not give you a vertical split. It will give you a horizontal split. There is no way, that I am aware of, of doing this verticially unless you put a rectangle in the body of your report, then load your table / matrix on one side of the rectangle and then the subreport on the other side of the rectangle. BTW, my suggestion is completely untested.
And you'll have to size your objects very carefully and turn off growing / shrinking to get it to look pretty.
February 11, 2008 at 8:55 am
it's hard to give advises without seeing it :-), all and the amount of data you want to display.
i would also try to use a sub-report control even though it'll be a performance penalty -- each rdl file will be rendering. but again, it depends how large the amount of data is. if not, it won't be too bad :-). then, you can layout controls within one report the way it fits and just insert it into a sub-report control. if you change the color of sub-report border, you'll give this sleek look :-).
i use rectangle quite a bit when i need 2 pages like a letter for example and i want to break at a certain spot. it does work, no problem, but perhabs, it's not quite what you need.
thanks & regards,
Maya
February 11, 2008 at 2:35 pm
Thanks for your responses, much appreciated.
What Im trying to achieve is have a summary report on the left and then depending on which "Project_Number" I click on it displays the list of details associated with that project on the right (ie - people on the project, start/end date, project description etc).
I have so far put a sub report on the right, Ive then created a parameter using the surrogate key to link to the sub report, Ive set the parameter to internal and written the hide expression on the subreport as
=Iif(Parameters!Project_skey.Value <> " ", True, False)
Im not sure what other steps I need to take, as I was told by a guy internally that it can be done.
Thanks again for your help.
February 11, 2008 at 4:52 pm
since reports are not the web forms :-), you would be much better off navigate to another page with details. easy to program, easy to maintain :-), less hair pulling.
or, you can write a web form (aspx), it has the whole bunch of controls for it.
the other option you may consider is create a data set of all your projects, like a drop-down one.
when user selects let's say 'Project 1' from it and clicks 'View Report' button, it'll filter only details for that project :-).
i always try to keep it simple since people change things a lot and i want to make sure it is not hard for me to make these changes :-).
February 11, 2008 at 5:05 pm
Yes you are right and originally I had the sumary report hyperlinking to a secondary report which was working fine. The requirements have now changed and they want it on 1 page. Developing it in sharepoint is an option, however I was seeing whether it could be done in SSRS.
Looks like its more headaches than its worth.
Thanks again
February 12, 2008 at 4:02 am
Sounds like you need to incorporate your reports in a Dashboard tool.
I know Crystal Excelsius does something similar to what you're talking about, but it usually uses Crystal reports instead of SSRS.
In fact, you could use an Analysis Services cube to hold your report data and create either a web form or get a third party dashboard tool to work off that. It would make your life easier.
Regardless, I don't think you can do what you are planning with straight SSRS. Sorry.
February 12, 2008 at 3:32 pm
Thanks for all your replies.
I have managed to get it working. The way to do it is:
I created a main report and then a sub report query. On the main report I placed the sub report next to it.
I created a report parameter to pass from the main report to the sub report. Then on the main report I right clicked on the textbox I wanted to use to link to the sub report and in the navigation tab I linked the main report to itself and identified the parameter to pass across.
Then on the sub report on the visibility tab I used the following expression.
=iif(Parameters!Project_Skey.Value is nothing,true,false)
So basically the subreport renders when you click on the relevant text box in the main query, so long as the surrogate key is not blank. The 2 reports then render side by side on the one page.
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply