August 29, 2008 07:05pm pdt

Member Login

Hall of Fame

Yearly

1chrismc 150,964
2mlmcc 131,305
3PFrog 111,752
4jgv 103,501
5rickchild 48,445
6RWrigley 39,404
7tshel 38,349
8Yurich 26,248
9mark_wills 21,650
10peter57r 21,585
11bdreed35 18,900
12chapmandew 17,060
13James0... 11,920
14gdupadhyay 11,850
15angelIII 11,520
16EugeneZ 10,925
17CRXIuser... 10,700
18frodoman 10,060
19nmcdermaid 9,500
20wykabryan 8,850
21ValentinoV 8,500
22analliah 8,450
23zx10r 7,890
24WilyGuy 7,500
25PedroCGD 7,200

	[x] Attachment Details

Hiding certain parameters in the report after the first execution.

Zones: SQL Reporting, SQR

Tags: Microsoft, SSRS, 2005

The Report is having 2 parameters. I want to hide one parameters (parameter1) in the report after the first execution.
From that point forward, I want the user to play around with the data by controlling the parameter that is not hidden (parameter2). Note: Though the parameter (parameter1) is hidden, its value will have to be used in the report..

This is a kind of "Search Within The Results" feature that Google provides. The initial data is retrieved based on the parameters that we provide. once the results are fetched, the new parameter (or one of the existing parameter) is used to further filter the data. Like this, the user should be able to rerun the report on the data retrieved by the first set of reports.

i think this is clear.. if not please do ask me, i';ll try to explain in more details.

Please some one let me know if such thing is possible in SSRS.

Start your free trial to view this solution

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

7.9

Question Stats

Zone: Database

Question Asked By: vasureddym

Solution Provided By: tshel

Participating Experts: 2

Solution Grade: B

Translate:

Loading Advertisement...

20080723-EE-VQP-34 / EE_QW_2_20070628