Listing results based on the starting alphabet

Hi,

I have a report which lists out the employees' details. I need A-Z links above the report, On clicking on an alphabet, say "C", should display all the employee details whose name starts with the selected alphabet. In the stored procedure we can accept the character and return back those results. But it is not a drill report and we need the result in the same report. Is there any way so that on clicking each link, the output will be shown in the same report. Any help is appreciated.

Thanks in advance,

Sonu

There are 2 ways to do this:

1. Create 26 datasets with the same SQL query but different filter criteria. For example, the first dataset will have the filter criteria as Fields!Name.Value LIKE 'A%', second will have Fields!Name.Value LIKE 'B%' and so on... This has to be set in the Filters tab of each dataset. Then have 26 tables in your report, each linked to the corresponding datasets. So, now when you click on A at the top of the report, have the Action set to Jump to bookmark and the value of bookmark will be the name of the corresponding table.

2. Create just 1 report with all the alphabets link at the top. Then create a report which will accept an alphabet as input parameter and display the results based on it. Set the action of the alphabets to Jump to report and set the parameters to be sent, which will the textbox value itself.

Shyam

|||

Hi Shyam,

Thanks a lot for your quick reponse. I followed the 2nd approach you have mentioned. Created only one report with alphabets link at the top. On clicking on to the link, the action of 'Jump to Report' is set as the same report along with the parameter.

Thanks again,

Sonu.

|||

Can you please mark my post as answer?

Shyam