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.

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'm not sure this is a personal problem on my laptop, or a generic one.  If I design my SL reports with the Control Panel Personalize Font sizing at 100% and then change to 125%, the SL reportViewer displays fonts that are all distorted; however if I look at the same reports in the VS Preview, they are fine.  I suppose this could either be SL or the ReportViewer.  Has anyone else experienced similar problems?

Thanks,
Steve

The progress window shows up with the bar running, but no text. I've looked at the template and the TextBox.Foreground property is set to Black, and I've even assigned the ReportViewModel.ProgressMessage, but no luck.  If I run the CSharp sample, the text displays correctly, and I know when I first used the viewer, it displayed in my app as well.  It doesn't display no matter which theme I use.

Any ideas????

Thanks,
Steve

I want to remove the page numbers from the report viewer, want to display all the values on 1 page itself.
Attached is the file.

Hi all.
I have for some time been worikng on a solution that needs to produce labels for chemicals.
The labels need to contain :

H: Header with name and some related info (DS1)(Works ok)
S1: Chemical information 1 (DS2) (Works ok)
S2: Chemical information 2 (DS3) (Works ok)
S3: Chemical Symbols (DS4) (fails)
F: Footer with logo and some other info (DS1)(works-but spills unto page 2)

DS1-4 is four different datasources. They have a common key; id and language.
S1-3 is created with sub-reports
The datasources for the report and the subreport are defined in a LabelsDA class as functions returning a Dataset.

I have several problems :
- The symbols subreport S3, worked, but suddenly stopped working after a Telerik Report upgrade, and im not able to fugure out why.
- Need to have S1-S3 to not overspill and force a page2. How do I keeptogheter averything inside the label-format?
- The designer fails preview and will not let me preview neither the subreports nor the complete report.

Could someone please tell me how this should be done using Telerik reporting?
A woking example would be great.

Size of labels are A5, A6, A7, A8, and Avery would be ok if templates are used.

regards
Alexander

When i create a report with multivalue parameters and preview it, there is a <select all> created that allows me to select all items. I have created a silverlight solution using the Silverlight reportviewer and when i view the report there is no option to "Select All" records. I can individually click each record to select all but since my list contains 25+ items, that is alot of clicking. If this is not available in Silverlight out of the box, is there a way to create the <Select All> and loop through and select all records when choosing preview?

Thanks in advance. 

i made a business object with properties to be shown on the report.
it had all well formated strings, and collections to fill subreports.
this collections are properties.
each collection is made with the same technique, string well formated properties.

the main business object is a collection too, and has just 1 object(with collection for the subreport).

subreports datasource is provided on main report detail_ItemDataBinding like:
        private void detail_ItemDataBinding(object sender, System.EventArgs e)
        {
            Processing.DetailSection section = sender as Processing.DetailSection;
            DataRowView dRow = section.DataItem as DataRowView;
            if (dRow != null)
            {
                StaffelSubReport.ReportSource.DataSource = (StaffelRptCollection)dRow["StaffelData"];
                MateriaalSubReport.ReportSource.DataSource = (MateriaalRptCollection)dRow["Artikel_Materialen"];
                BewerkingSubReport.ReportSource.DataSource = (BewerkingRptCollection)dRow["ArtikelBewerkings"];
            }
        }


all data is correctly provided( was the first thing i have checked)
the problem is in 2 places

1st ReportViewer
report viewer is showing error when rendering subreports, each field says something like
"#ERROR# The expression contains object 'OpstelUren' that is not defined in the current context." but there is a property called like this.

Then , i tryed with ReportViewer export to pdf(this is my main specification) and the report was 100% correctly, subreport was filled perfectly. So, i look in forums and found how to export directly to pdf from code behind.
i did this with Telerik.Reporting.Processing.ReportProcessor.Render method, and HAPPENED the same with the reporViewer, showing the pdf with errors on the subreport fields.

i think there is a bug when rendering because ReporViewer shows bad on first bur exporting from this control is good, and exporting directly from the codeBehind works bad like the web rendering of the reporViewer control.

i have two filers that are working, great.  Now I just need to figure out how to load the report with all the data Inot filtered) on the reports initial load.

Most examples for the reporting i have seen are reports that run in silverlight but retrieve their data from a database maybe based on parameters passed to the report svc from the silverlight application. I am working on a application that has a local database in the form of an XML files and images embedded in the silverlight application.
I am trying to use telerik reporting to create a report based on this local data and images. How can I get this data from the silverlight application to the report without using a sql database reference.