This is a migrated thread and some comments may be shown as answers.

Crosstab reports - how to get the row header and column header

1 Answer 95 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Rajendra Kulkarni
Top achievements
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.

1 Answer, 1 is accepted

Sort by
0
Steve
Telerik team
answered on 22 Apr 2010, 09:28 AM
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.
Tags
General Discussions
Asked by
Rajendra Kulkarni
Top achievements
Rank 1
Answers by
Steve
Telerik team
Share this question
or