Rajendra Kulkarni
Top achievements
Rank 1
Rank 1
Rajendra Kulkarni
asked on 16 Apr 2010, 03:06 PM
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,
Using our ProductSales demo report (the one from the screenshot), you could get those values directly in the expression. Since you want this to be part of hyperlink, you can place an HtmlTextBox for that cell and use similar expression inside it:
<a href="'~/Default.aspx?MyKey='{Fields.ProductSubCategory} - {'Q' + Qtr(Fields.OrderDate)}">{Sum(Fields.LineTotal)/1000.0}</a>
All the best,
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.
Using our ProductSales demo report (the one from the screenshot), you could get those values directly in the expression. Since you want this to be part of hyperlink, you can place an HtmlTextBox for that cell and use similar expression inside it:
<a href="'~/Default.aspx?MyKey='{Fields.ProductSubCategory} - {'Q' + Qtr(Fields.OrderDate)}">{Sum(Fields.LineTotal)/1000.0}</a>
All the best,
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.