Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
s15199d
Starting Member
15 Posts |
 Posted - 2006-03-24 : 10:33:46
|
| I've built a report (not using the wizard). I've got everything the way I want it. But, I've got 2 things I don't know how to do:1) How do I apply a parameter as a filter to every field? When I use the wizard I have the option of selecting an object in layout view that has a filter property for the entire report. I haven't found the equivalent in the report builder.2) I want this report to be accessed from another report. When the user clicks on a field in ReportA I want this report (ReportB) to load up. I want the parameter/filter for ReportB to be the ID of the object the user clicked on ReportA. What's the best way to do this? All suggestions/answers are greatly appreciated! Thanks in advance! |
|
|
s15199d
Starting Member
15 Posts |
Posted - 2006-03-24 : 13:23:20
|
| I'll settle for help adding a filter to my report. I gotta get this today! I'm desparate for suggestions! |
 |
|
|
snktheone
Starting Member
20 Posts |
Posted - 2006-04-06 : 08:13:05
|
| 1.In order to apply filter to every field i guess you need to go the filters tab in the table control 2.You need to your Jump to Reports in the navigation tab of a single table cell. |
|
|
|
s15199d
Starting Member
15 Posts |
Posted - 2006-04-06 : 10:02:17
|
| Thank you snktheone!You're the only reply i've gotten and I've posted in 6 forums. I'm very greatful!1) I didn't build my report using the table option. Is there a way to put all of the text boxes et. al. into the detail line of a table control? Or is there a way to apply filters to a text box or a group of text boxes that aren't in a table?2) That's precisely what I've been looking for! Thank you! |
|
|
|
s15199d
Starting Member
15 Posts |
Posted - 2006-04-11 : 15:17:52
|
| Is there a way to filter at the report level without using the table object/control? |
|
|
|
|
|
|
Filters/parameters