I know I'm missing something simple. But we are demoing Telerik Reporting and coming from using SSRS on ASP.NET projects.
For our existing locally processed reports, we put together an rdlc, the reportviewer and a datasource such as SQLDataSource.
This datasource connects to a stored proc that has multiple parameters passed in QueryString. We simply add QuerystringParameters to the datasource and we are done - the report host aspx page runs, datasource executes and the rdlc displays results in the ReportViewer.

What I can't figure out is how this works in Telerik Reporting. Its seems Telerik's SQLDataSource is defined in the report and not the 'host page' aspx and doesn't seem to accept QueryStringParameter as a parameter. So guess I need to know, how to pass the querystrings (up to 20) to the SQLDataSource the easiest way possible. We do not need report parameters, just the datasource parameters.

Sample aspx from SSRS local report:

<asp:SqlDataSource ID="SqlDataSourceX" runat="server"

ConnectionString="<%$ ConnectionStrings:ConnDB %>"

SelectCommand="SELECT * FROM [Jobs] WHERE ([DeptID] = @d)">

<SelectParameters>
<asp:QueryStringParameter DefaultValue="2" Name="d" QueryStringField="d" />
</SelectParameters>
</asp:SqlDataSource>
Or, how to just use the asp:SQLDataSource on the aspx page to 'feed' the trdx and the ReportViewer control?
Any help is GREATLY appreciated.

How can you rotate the Data Lable Column.  I have it displaying a description but they run together,  I can see I can rotate differnt lables but can not seem to find the place to rotate the labels on the x axis.  I would like to rotate them about 30% so they will fit.  Also how do you show the value of the y axis in on the bars of a bar grid.  Alos I am show percentage and the y axis is only going to the largest value, how can I set it to go to 100?

I see how to stack the StackBar or StackBar100 chart you make each stack a new series.  Is there a way to dynamically add a series.
I have a data set theat has date, category, and percentage of Sale.  What I would like would be the x be the date, then the y be the Percentage and the series be the calegory.  Depeneding on the date tsome categories may or maynot be in the data set.  Is ther a way to dynamically at run time to create the series and populate the stacked bar reports?

When setting the apperance for the Series is there a way to format the lable.  Such as I am showing Percentage and it is out to 6 decimal points but in tfor the label I want only 2 decimal points.   Also is there a way to conditionally format so when the value is null nothing is shown?

Ok I have looked through alot of the documentation and I just don't get it.  This should be easy.

I have a sql query that is used in as the datasource for the report.  It displays the data in a a cross tab table.  I then want to take the percentages, some are in the query others are determined at run time of the report.  I want to create a bar chart that has the Categories across the bottom and the percentages as the y.

I would also like to use the same data set to build a pie chart.  I can set the datasource to the chart but I can not see any way to set the x and y axis to the fields I want displayed

VS 2010, Q2 2012 reports. I have a chart in my report when it is printed the X-axis label (as well as the item labels on both axes) has a black background. The Y axis label which seems to be formatted identically, does not have a black background. This ONLY happens when printing directly to a printer. On the screen and when generating a PDF this black background does not appear. 

I have been setting the fills to all use the transparent color to see if that would do anything but no no avail. 

Any suggestions?

Thanks, 

Matthew

Hello 

I want to build reports based on ObjectDataSource. As an easy sample, I tried to start with an sample report, based on your video.

In my project, there is a BI-Layer based on EF4/POCO. But when I try to add a Entity Context Object (to populate the List in GetAllProducts()), I get an Error on Report Preview (see Attachment).

In the same Project, I made a report, directly based on an EntityDataSource, which works, even in Preview. But I need to do some processing in my own Classes before.
What's wrong and how to resolve it?

Thanks, Simon

I have my report's default font set to Times New Roman, 9pt, When I create new conditional formatting on a field, the font is Arial 10.

How can I configure my environment to have a default font for all actions?

Peter

I'm a newbie to reporting, so forgive me for this elementary question.

When designing report, I noticed that sometimes the textBoxes were shifted to the right during preview and debugging. Attached are my report in Designer and its Preview.

In Designer, the Grand Total Textbox (and the textbox next to it) should be only one inch from left margin, but in Preview mode, the textboxes were shifted to far right.

So can anyone tell me what happened and how to fix this? I've tried moving the textboxes around but they are still shifted to far right side of the document.

Thank you.

Hi,

I am using Telerik  Reporting Q2 2011 with Silverlight 4 and I would like to specify the report name in the Save File Dialog. I have already explored other post regarding this issue and found that Report.DocumentName property is used for this purpose but Silverlight 4 Save File Dialog does not have DefaultFileName property therefore it is not possible to specify report name due to the limitation which comes from Silverlight 4.

But now silvleright 5 have this property for Save File Dialog. So, does the latest release (Q 3 2011) of Telerik reporting have this functionality? If not when it will be available?

Adil