Rajendra Kulkarni
Top achievements
Rank 1
Rank 1
Rajendra Kulkarni
asked on 19 Apr 2010, 06:24 AM
Hi,
I need help with the following scenario in reporting.
Scenario
1. Call a stored procedure to get granular data
2. Use a crosstab report to apply the row and column groups and display aggregate counts in the report
3. Each count value should be a hyperlink with the row and column headers as querystring of the hyperlink. To do this, I need to know the values of the row and column groups to which the cell belongs to.
For example.
In the attached screen shot, the value 4.5 is encircled and it is associated with Helmets(row) of Q1 2002(column). How do I fetch the values 'Helmets' and 'Q1 2002'. I Want to make 4.5 a hyperlink with the query string as 'Helmets' and 'Q1 2002' so that on click of the hyperlink, it will call another page which will use the query string parameters to query the database and get the rows that made the number 4.5.
I know about the workaround to make the cell a hyperlink, but i do not know how to fetch the row and column headers to use it for querystring parameters.
please assist me in this.
I need help with the following scenario in reporting.
Scenario
1. Call a stored procedure to get granular data
2. Use a crosstab report to apply the row and column groups and display aggregate counts in the report
3. Each count value should be a hyperlink with the row and column headers as querystring of the hyperlink. To do this, I need to know the values of the row and column groups to which the cell belongs to.
For example.
In the attached screen shot, the value 4.5 is encircled and it is associated with Helmets(row) of Q1 2002(column). How do I fetch the values 'Helmets' and 'Q1 2002'. I Want to make 4.5 a hyperlink with the query string as 'Helmets' and 'Q1 2002' so that on click of the hyperlink, it will call another page which will use the query string parameters to query the database and get the rows that made the number 4.5.
I know about the workaround to make the cell a hyperlink, but i do not know how to fetch the row and column headers to use it for querystring parameters.
please assist me in this.
1 Answer, 1 is accepted
0
Hi Rajendra,
Your question has already been answered in the other thread you've opened. Please, see our answer there for more information.
We kindly ask you to use just one support channel to contact us. Posting the same questions numerous times slows down our response time because we will need to review and address two tickets instead of one. Moreover threads are handled according to license and time of posting, so if it is an urgent problem, we suggest you use a support ticket, which would be handled before a forum thread.
Thank you for your understanding.
Sincerely yours,
Steve
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
Your question has already been answered in the other thread you've opened. Please, see our answer there for more information.
We kindly ask you to use just one support channel to contact us. Posting the same questions numerous times slows down our response time because we will need to review and address two tickets instead of one. Moreover threads are handled according to license and time of posting, so if it is an urgent problem, we suggest you use a support ticket, which would be handled before a forum thread.
Thank you for your understanding.
Sincerely yours,
Steve
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.