Hello community,

I have a question about creating a crosstab report and wanted to get the community's thoughts before submitting a request ticket.  First off, the data is structured in the following format:

Category    Subcategory    Item        Value
January        1                       Apple       100
January        1                       Orange    50
January        2                       Apple       300
January        2                       Orange    75
February      1                       Apple       95
February      1                       Orange    60
...

The report needs to look like this:
January    Sub 1    Sub 2
Apple         100        300
Orange      50          75
February  Sub 1    Sub 2
Apple         95          ...
Orange      60          ...
...

The biggest restriction to this report is that the data is retrieved from a web service in this format, all at once.  Each category to me looks like a crosstab of Subcategory, Item, and Value, such as:
[=Category?]            [="Sub " + Fields.Subcategory]
[=Fields.Item]           [=Avg(Fields.Value)]

Though, I'm unsure how to repeat this cross tab for each category using the same data.  Assigning the corner [=Fields.Category] doesn't work (which makes sense but I'm not sure how to make it work.  Any help would be greatly appreciated.

Hi All,

Hello,

Hi,
I have created 3 reports.
For e.g names of the report are A,B,C
 Report A -  is Main
SubReport B is subreport of A
Subreport C is the subreport of B

My problem is that, if I put subreport C in the detail section of Subreport B, it displays the data- for all records except first.
But  I want to display it in the Footer of B. When I put the Subreport C in the footer section of Subreport B, it does not display any data - just displays the labelheaders.

I would appreciate help with this.

Thanks,
Manisha

I recently went to add a new report into an existing project. I added the parameters to the report and went to add my filter. When I click the ellipse to add the filter, the entire report locks up and I have to close the file using ctrl-alt-delete.

I have created a new report, openened other existing reports, upgraded to the latest build of terlerik reporting and have the same issue no matter what I do. Any ideas as to what is going on here? I have created an extremely simple new report, and have this issue regardless of what I do.

I have been observing your site looking for the 10.1 release of your tools, as you have mention that you can install the reports locally with Silverlight and render them.  GREAT!!!  I downloaded and installed your trial tools....

I've been digging for about an hour now in your documentation, etc. and cannot find a way of creating a Silverlight *.dll, add a report to it, and then subsequently render that report.  The only examples I seem to see all need a web service to render properly.

Am I missing something here?

(link to mentioning of Out of Browser here.)

If all you are saying is that the SL Report Viewer can be installed locally, then your marcomm is rather misleading.

I have a question about what happens "behind the scenes" with a report filter.

Scenario:  I have a web app with a report that uses a SQLServer view as its data source.  The view contains data for all clients.  For sake of an example, let's say there are 10,000 clients.  The report has 1 ReportParameter, the ClientID, and that parameter is used to Filter the results shown on the report.

What happens behind the scenes to pull data onto the report?  I can imagine two possibilities:

1) The report viewer opens the view, and 10,000 rows of data are passed from the SQLServer to the WebServer.  The report viewer filters the data down to 1 row by ClientID and displays the report to the end user.
OR
2) The report viewer reads the ReportParameter and passes a query string to the SQLServer like "Select * from View WHERE ClientID = 'XYZ'".  Then, the SQLServer passes just 1 row of data to the Webserver, and the report viewer displays the report.

I expect the answer is #1, but I hope for #2.  Clearly, #2 results in a LOT less network traffic.

Testing a field for null value does not work with Q2 2009 and SQL Server.
I tried
and I always get "N/A" even when Field.myField is not null.

Any idea?
Thanks!

In addition to the post "RadComboBox.SelectionBoxItemTemplate is read only" error in Silverlight viewer", I have this Issue on the dev build for Silverlight 4 (RadControls_for_Silverlight_4_2010_1_0422_DEV)  too.

Hi,

I am using telerik report for my project, the reports generated are very big and thus time consuming.That is teh reason what we are doing is :

Generating summary report on the button click and sending the another asynchorous request for the detailed report. As that request might take upto 15mins to generate taht report and we can't ask our website user's to wait for the report generation for such a long period.The user can view report in PDF format as and when it ready though async request.

The problem we are facing is that the summary report is not rendered until the PDF that is being generated through asyn request. This is due to the reason that only 1  instance of the report  is avaliable for both the requests. Dont know what is the intance for it.

Please reply.

Thanks and Regards,
Yuvika