Telerik Forums
Reporting Forum
1 answer
111 views
Hello,
i tried to set the report's datasource,going on ReportSource property,a dialog appeared where i choosed the type
and chose from "Select a report Type" and a blank window in dialog mode appear,and i couldn't do anything from that point on.i had to close Visual Studio.
I attached a screenshot.Is this an error,or some wrong operation on reports?!

P.S:i used the Reporting Q3 2012
Stef
Telerik team
 answered on 01 Feb 2013
4 answers
395 views
Hi all,
I have a hierarchical data structure and I am using a sub report with object data source to recursively iterate over it. 
In all the leaf nodes I have a value that I would like to aggregate in a bottom up manner and display the running aggregate at each level.  Aggregating the values outside of the report is not an option at the moment.

Basically, it boils down to passing values from all the subreports up to the parent report.
I am still new to Telerik so some pointers / techniques/patterns would be highly appreciated 

Report should look like this in the end

(root) 12
    (A1) 3
      (B1) 1      // leaf
      (B2) 2      // leaf
   (A2)  9 
     (C1) 6
        (D1) 4
           (E1) 1 // leaf
           (E2) 3 // leaf
         (D2) 2   // leaf
    (C2) 3        // leaf
etc...

Greetings.
Stef
Telerik team
 answered on 01 Feb 2013
1 answer
230 views
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.
Hadib Ahmabi
Top achievements
Rank 1
 answered on 01 Feb 2013
1 answer
125 views
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
IvanY
Telerik team
 answered on 01 Feb 2013
1 answer
102 views
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
Hadib Ahmabi
Top achievements
Rank 1
 answered on 01 Feb 2013
3 answers
158 views
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?
Chavdar
Telerik team
 answered on 01 Feb 2013
1 answer
423 views
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.
IvanY
Telerik team
 answered on 01 Feb 2013
1 answer
77 views
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.
Hadib Ahmabi
Top achievements
Rank 1
 answered on 01 Feb 2013
4 answers
197 views
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?
  
 
Stef
Telerik team
 answered on 31 Jan 2013
2 answers
248 views
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:

"Excel found unreadable content in 'PulledOrders.xls' Do you want to recover the content of this workbook? If you trust the source of this workbook, click Yes."

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.
Manar
Top achievements
Rank 1
 answered on 31 Jan 2013
Top users last month
Boardy
Top achievements
Rank 2
Veteran
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
ivory
Top achievements
Rank 1
Iron
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
ClausDC
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?