I have inherited a database where all data is retrieved using Select stored procedures. These have been mapped to functions in a linq to sql model, but when linking up to a Report I don't get any data back. 

I tried to follow the example given in this thread, using an objectdatasource but it still will not work: 
http://www.telerik.com/community/forums/reporting/telerik-reporting/linq-in-an-object-data-source.aspx

The code in my business logic class is:

 

In my Report.Designer.cs class I have the following:

I know the function is working fine as I can retrieve data through a GridView. I think I read a comment somewhere that this method might not work with stored procedures? Where am I going wrong?

I would like to create a pie chart just like the one here: http://demos.telerik.com/reporting/product-line-sales/demo.aspx
However, disappointingly, the video tutorial decided to skip the pie chart.

I want to display a pie chart with ProductName listed on the series, while Quantity is displayed on the chart. I am using a sqldatasource.

This is a sample of my data:

===============================
ProductName                      Quantity
===============================
Crips                                     12
Coke                                      7
Candy Bar                              57

I've got so far as displaying the chart and listing ProductName on legend. However, instead of having the Quantity displayed on the chart like in the demo sample above, the ProductName was displayed instead.

This is the code for my chart:



Can anyone tell me how to produce the pie chart like the one in the demo sample?

I refuse to believe that I'll have to data bind the chart to generic object list as mentioned by the last reply in this thread (http://www.telerik.com/community/forums/reporting/telerik-reporting/pie-chart-with-value-displayed.aspx) just to achieve this simple functionality.

Thanks.

Hello,

I need to create a graph similar to the picture attached. I have tried for several hours to do so with no luck. I need to create this in a Visual Studio. I can lay the data out any way necessary.

This seems like it should be simple so I am hoping I am just missing something obvious.

This is a somewhat urgent need so any elp is really appreciated.

Thanks,
John S.

Hi,
I am using Report Viewer and Export option to PDF only.

what size i should set for Report Viewer to make a single page from Report into single page in PDF.

I want to have a page from Report in a page in PDF.

Help me to resolve this.

Thanks in advance.


Regards,
AGMRAJA

Whats wrong with this expression, logically i can print any default variable if a field comes as Null. 
= IsNull(Fields.ROE_wo_Reserves, Fields.Flat_Line_Rent) 

I am getting blank value as output everytime. 

Hi,

When we tried to create a grouped bar chart against two different region (WEST, EAST) across defined months (01-Jan to 01-Jun), Grouped Bar chart is rendered correctly including X axis labels center aligned - Please refer the attached image - All_Data_Bar.png.

But we encountered the X axis label alignment problem (it's not in center against the bar) only if some of the months data is not available for one particular region (EAST) - Please refer the attached image - Grouped_Bar_Label_Center_Issue.png . Our customer is expecting that X axis label against the bar should be center aligned always.

Sometimes based on the data, we are getting the empty space between the bars against the group.- Please refer the attached image- Grouped_Bar_Space_Issue.png

Please advise how to resolve this issue? If you can provide code sample to acheive the desired result would be grateful.

Thanks
Sankar

I've been searching around for a way to change the 'Value' of a textbox during the ItemDataBound event, but I'm not seeing any examples.  I am binding to a SQLDataAdapter which calls a stored procedure to load the textboxes, so much of the data is stored in 'bit' column types.  What I need to do is simply change things like bit values '1' or '0' to 'Enabled' and 'Disabled' when the report is generated.

My first approach was to access the needed Textboxes in the ItemDataBound event and change their 'Text' or 'Value' field based on the appropriate row value.  But, these properties don't exist. 

Thanks.

Hi,

We am using Telerik Reporting Q3 2011 on .Net Framework 4.0.

We found that the reportviewer cannot be released from memory even the form have been closed. 
By using the .Net Memory Profiler, we know that there is a event handler for "ToolStripTextBox" in reportviewer control which does not been removed after the form closed. So, "Disposed instances with direct EventHandler roots" problem occurred.

After testing, we found that only if we set the "ToolBarVisible" property to "False" in ReportViewer control, the memory can be released successfully.

So, any advise?

Thanks!

Emily

Hi

I group records in my report. In group's footer section, i display a single value(which is actually same for the same group) onto my textbox from each and every single group in group footer section of the group. Then i need  to get all values of the textboxes in the groups footer section . How can i get them programmatically? I know how to get an item however, when an item(here textbox) being diplayed accoring to the number of the groups resides in final report, i don't know how i can get all the values?

Such as:

Telerik.Reporting.

TextBox txt = (ReportViewer.Report as MyRaport).Items.Find("textBox13", true)[0] as Telerik.Reporting.TextBox;

 

 

txt.Visible = false;

Could someone pls help me?

Thanks in advance...