Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

show report header above the report parameters in report view using SSRS? Expand / Collapse
Author
Message
Posted Tuesday, August 19, 2014 3:58 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: 2 days ago @ 5:12 AM
Points: 13, Visits: 26
show report header above the report parameters in report view using SSRS?
is It possible to show report header above parameter?
Pls suggest.
Post #1605217
Posted Wednesday, August 20, 2014 6:52 AM This worked for the OP Answer marked as solution


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 6:26 AM
Points: 10,381, Visits: 13,435
If I understand your question correctly, the answer is no. You cannot make the report header appear above the parameters. The parameter selection area is not really part of the report, it is part of report manager. What I have seen typically is that the report itself will contain a parameters section that displays the selected parameters in the report itself and this section is below the report header.



Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #1605399
Posted Thursday, August 21, 2014 1:13 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: 2 days ago @ 5:12 AM
Points: 13, Visits: 26
Yes,
Its not possible.
I have one more question.
I have report which is parameterized..
Can I provide 2 level filter in report.
1st level- When I pass parameter then click on view button then result shown on report ., After that
2nd level-
I want to make a drop down list from the report view table result set .

I want to column name as value of drop down list .

After that I want to filter result set on selected value filed + operator

like,=,>, + text box value.

expression like --

ddl value + operator = 100;

salary(ddl value) >= 2000(text box value) .

pls suggest.
Post #1605683
Posted Thursday, August 21, 2014 6:40 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 6:26 AM
Points: 10,381, Visits: 13,435
mkbhagat4u (8/21/2014)
Yes,
Its not possible.
I have one more question.
I have report which is parameterized..
Can I provide 2 level filter in report.
1st level- When I pass parameter then click on view button then result shown on report ., After that
2nd level-
I want to make a drop down list from the report view table result set .

I want to column name as value of drop down list .

After that I want to filter result set on selected value filed + operator

like,=,>, + text box value.

expression like --

ddl value + operator = 100;

salary(ddl value) >= 2000(text box value) .

pls suggest.


The short answer is no, there isn't dynamic filtering in SSRS. Any parameters for a report are applied when the report is run. Any changes made to parameter selections require the report to be re-run to be applied.




Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #1605780
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse