November 20, 2014 at 11:16 am
Hello there,
This should be a simple question with a simple answer, I believe. I'd like to know if there's a way to split the search parameters on a report (the top section of the report where you type your criteria) to more than two columns. It seems that every report with several parameters splits the parameters into two columns, I'd like to split them into more so I can decrease the space it uses and increase the space of the results. I searched the internet and I haven't found anything that can point me into the right direction. I'm hoping that someone here had gone through the same problem.
Thanks.
December 2, 2014 at 9:30 am
If I understand your question, I believe I've done this before.
I created one parameter that searches several columns.
All you have to do is use a lot of OR in your WHERE clause of the dataset query.
For example:
Select *
FROM table
WHERE Column1 = @Parameter1 OR Column2 = @Parameter1 OR Column3 = @Parameter1
With this, all you do is enter a search value once and it will search in all three different columns for that value.
December 2, 2014 at 11:02 am
Sounds like you want to customize the display of the report in Report Manager. Unfortunately SSRS doesn't give us control over how the report manager looks. You could look into a third-party component like Mobilizer from Forerunner[/url]. It gives SSRS a more modern look and feel, and allows for some customization.
Jack Corbett
Consultant - Straight Path Solutions
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply