I have created a report and added a table to the detail section.
I have set the sql datasource of this table at design time. The sql data source is dynamic and can return a different number of columns at run time.
I would like to be able to get (or convert) the sqldatasource into a datatable at run time so I can identify the number of columns and column names returned by the datasource and build the table dynamically.
I have managed to build a dynamic table but I cannot figure out how to convert or access the sql datasources dataset/datatable/rawdata. How do I do this? is it even possible?

Thanks in advance.

I am using the Reporting Learning Guide pdf.  I am trying to create a new report inside VS2012 and keep running into a problem.  

When I get to the Choose Data Source page, there are no data sources present (no problem there), so I click on the "Add New Data Source..." button and the "Create New Data Source" dialog opens -- with no selections to choose from.

A screen capture is attached.

What do I do?  This is happening repeatedly.

Thanks in advance for any assistance!

Lynn

Hi,
I'm using a reportviewer inside a silverlight custom control.
This custom control is embedded into a lightswitch project.

In the LS screen the first column on the left contains a grid with the records I'd like to print, the second column (right) contains the custom control where the reportviewer is shown.

Everything works fine, except that when I change the record on the left column's grid, I have to manually refresh the reportviewer, using its refresh button.
I can't find a way to programmatically add a refresh method triggered to the grid_SelectionChanged event.
 
What I'm looking for is an easy way to refresh the reportviewer as I do with its button.

Any help?

Thx

How does the telerik resource service determine the url to use in the call to getrenderstream? Images are not appearing in my report because the getrenderstream url is including a port number, which is causing the connection to be refused. If I manually execute the same url without the port number, the image resource is loaded correctly. There is no mention of a port number anywhere in any of my web.configs, and none of the other service calls include a port number (including telerik report service calls). Is there a way I can force the resource service to not include the port?

Good morning,

I'm trying to use the report viewer to display a web based report. I've already placed it on my server and was just running a couple of test inquiries with date parameters that designate what date range to display the reports, and any report > 2000 records begins to time out. I tried increasing the time out server side, and it's still giving me a problem.

My question is, is there way to prevent this issue? I am not doing a lot of sorting, filtering, or grouping. Essentially, my query is a basic Select with maybe one join in a stored procedure in SQL Server. I have used that as my data source and when I am pulling up the report the only two parameters that I give the report are a start date and end date.

The error that I am getting is always the following

[HttpException (0x80004005): Request timed out.]

Is there a way to resolve or prevent this short of just increasing the timeout to 3000 like I saw other people doing? I do not want to put too much overhead or load on the server. Another question, just to verify, Telerik does not "lock out" the records when I'm running the report viewer, correct? Since most of the reports that I have tried to run seem to take about 6 - 8 minutes to respond, I just want to ensure that I am not preventing other processes from accessing the same records.

Also, could it possibly be because of the multiple pages that the report viewer is rendering? I have it currently set to display only 22 records per page, but I forgot how to adjust that. So another question is how do I inform the report viewer that I want it to display more than 22 records per page?

Thank you in advance for your assistance.

I have a chart that is very near what I need. But the legend area on the right is displaying empty entries. How can I get rid of them? I have a filter setup at the chart level already. I have attached an image.

I have a chart that is displaying data I want to filter out. This is depicted in the attached file unfiltered.png. So I applied a filter to the chart(the same filter is applied at the report level) and get what you see in filtered.png. How can I apply the filter to the legend area?
  
 

I am combining multiple identical reports in a report book and then saving the rendered report in an Excel 97-2003 Worksheet file. I'm getting the following error when Excel tries to open the generated report:


Trusting in myself, I click yes and Excel repairs the file claiming it renamed an invalid worksheet name for each report (I'm naming each report with a unique name using report.Name). The excel file then has one perfectly rendered worksheet with the name I gave it and an identical one beside it with a name like 'Recovered_Sheet1'.

What am I doing that would cause this. Is there a special way to set each name in a report book that's different from naming each report?

BTW, I'm not using the viewer for any of this, just rendering the file directly.

I have a report which i am using recursively as a subreport.
At runtime, i modify the report based on user inputs (I add some columns, sorting,  groupings, etc.).
I would like to clone the already customized report instance so that I can provide it as the subreport reportsource without having to redo the customization for every single instance. 

Is there an easy way to do that? Are report instances Clonable?

I am using an aspx page in which i have included this page directive.
<%@ Register assembly="Telerik.ReportViewer.WebForms, Version=4.0.10.317, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" namespace="Telerik.ReportViewer.WebForms" tagprefix="telerik" %>

but still there is an error on design page saying failed to create Telerik.reportview.webforms.reportviewer.
more over there is a logo in the current abc available in the following path 
Telerik.reportviewer.axd/instance...

i am unable to find that logo in my images folder also.
Kindly help how to track the image path. i need to remove that image and put another image.