June 28, 2005 at 9:31 am
I have just decided to investigate replacing our current reporting tool with RS and am looking for information about how to use it. All the information I am finding appears to be how to build fairly simple reports.
I need to build a report that has several fields in free form at the top tied to a table at the bottom. I can't seem to find a way to filter the table so that it only shows the records related to the currently displayed free form fields. Is there a way to do this?
It might also be that my thinking is stuck in the way I have always done reports in the past. I might need a reset for the new paradigm.
Also, if anyone knows of a good resource to help learn how to use the more robust features of this tool I would be very interested in that also.
Thanks,
Eva
June 30, 2005 at 12:25 pm
I figured this out. Turns out I just needed to merge cells and use only a table.
I would still like to be able to have tables within tables like this but it appears it is not possible at least with this version.
Thanks for looking at it for me.
Eva
July 2, 2005 at 8:10 pm
Try this link for a tutorial that includes links to most of the MSDN Reporting Services tutorials. Hope this helps.
http://www.15seconds.com/issue/041013.htm
Kind regards,
Gift Peddie
Kind regards,
Gift Peddie
July 3, 2005 at 9:26 pm
Hey Eva,
You may also want to look up (uning the index) 'repeating data regions' as it covers off how to nest data regions within each other, and also when to use subreports rather than nesting.
HTH,
Steve.
July 4, 2005 at 12:27 pm
Thanks for all the suggestions.
I actually looked at a lot of that very documentation in my search. The thing I was trying to do of getting the subreport to filter based on a parameter of the host report just doesn't seem to exist. I even found a MS Chat where someone asked about dynamic subreport filters and the response was that was not a feature now and not in the new release either.
That was why I tried with the nested tables. Turns out I run into the same problem. No dynamic filters.
Oh well... What I did works.
Eva
July 4, 2005 at 5:26 pm
Paraphrasing what you've said above, does this mean that you can pass parameters to subreports but these can't then be used in/as Filters within the subreport? If so, that's a bit poor.
Steve.
July 5, 2005 at 1:41 pm
In a word, yes. I attempted that very thing but there is no way to then refer to the parameter value in your filter. At least none I could come up with.
If you figure something out, let me know.
July 5, 2005 at 7:24 pm
Hi Eva,
The quick sample I did up worked for me. I created 2 reports, one was a subreport of the first.
Report 1:
Had a parm to collect an employeeId, not used in this report.
Has a subreport region containing report 2
Report 2:
Had a parm to receive an emplyeeId, type is integer. Parm not used in report dataset/s.
Has a dataset with no limitations (ie no paramters)
Has a list with a filter on it -> Filter set to:
Expression -> =Fields!EmployeeID.Value
Operator -> =
Value -> =Parameters!EmpIDIn.Value
HTH,
Steve.
July 6, 2005 at 6:47 am
Did the subreport repeat? As long as I only have one instance of the entire thing this does work, yes. However, what I need is the whole thing several times over in one report. This is where the problem occurs.
In other words:
Report1 Details for Member1: Subreport1 Member1; Subreport2 Member1
Report1 Details for Member2: Subreport1 Member2; Subreport2 Member2
and so on. I can filter the subreport as you suggest when the entire thing is only being generate for one member but not when I want to do multiple filterings as I have outlined above.
Hope that made sense.
Eva
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply