Telerik Forums
Reporting Forum
3 answers
165 views
Hello, I am trying out Telerik reporting and am attempting to learn how to bind to a line Graph. Here is my situation:

-I have a table of transactions, each of which has a "category"
-I have a parameter which is a date
-I want my line graph to show the count of each "category" for each of the last 7 days. So I want a series (line) for each "Category", where my x-axis is the day (7 days ago to now)  and the y-axis is the count of transactions for that category.

My problem is that I do not know "what" categories these may be before-hand. I tried using a "pivot" in my sql query: this gives me a result set with each day as columns and counts for each category. I cannot create my line series in the design view because I don't know the categories (could be 2, 15 ect.)

Is there a way, after the chart is bound to this result set, to get that set, iterate through it, construct a "custom" result set with the "categories" as columns,  and programatically add the series to construct the chart?  Thanks so much
Elian
Telerik team
 answered on 24 Nov 2011
1 answer
51 views
Hello,

We  have application where we generate line chart. The dataset which is binded to the chart has 15 rows and 31 columns. When the columns are less chart gets rendered quickly but with more number of columns it takes almost 3-4 mins. Please let me know what can be done to resolve this issue.

Thanks.

Elian
Telerik team
 answered on 24 Nov 2011
1 answer
150 views
During installation of Telerik Reporting Q3 2011 I got the error "Setup Wizard ended prematurely" without any hints to the problem causing that error.

I've found that there was an error in XML-syntax in file:
C:\Windows\Microsoft.NET\Framework\v2.0.50727\CONFIG\machine.config
(Opening that file in the internet-explorer gives an indication of the faulty line.)

In my case there was a question mark (?) instead of the closing quotation marks (") in the line:
<add name="Npgsql Data Provider" invariant="Npgsql"  support="FF" 
description=".Net Framework Data Provider for Postgresql Server" 
type="Npgsql.NpgsqlFactory, Npgsql, Version=2.0.11.0, Culture=neutral
PublicKeyToken=5d8b90d52f46fda7"/>

Steve
Telerik team
 answered on 24 Nov 2011
3 answers
1.0K+ views
is there any way to customize the papper size in the reports? i mean no predefined papper size on windows, i have my custom size of papper since im using a matrix dots printer
Steve
Telerik team
 answered on 24 Nov 2011
3 answers
240 views
Hi,
 I have a report that has two parameters the second is cascaded from the first, what I would like to do is to have the second parameter pick up the first value from it's available values after the collection has been populated.

For example parameter one is a list of user names and parameter two is a list of dates based on the username. I would like parameter two to have a value equal to the fist available date in it's available values collection each time that the user name is changed.

The reason for this is to allow the report to show the newest data when opened up so that the end user does not have to select a date unless they wish to view a different one.

Thanks

Chris
Peter
Telerik team
 answered on 24 Nov 2011
5 answers
223 views
I have VS2010 and SL4. I installed reporting Q2 2010. Tried to drag a report viewer on a page of a 'Silverlight Business App' and I got that error... any idea?

Furthmore. I am using WCF RIA services so will the report see the domain services as a data source? Or how would I bind the data?
Steve
Telerik team
 answered on 24 Nov 2011
1 answer
160 views

I cant seem to find an example on this site that shows changing an item (ie. TextBox) in a subreport.

I'm trying to update the textbox in the subreport, but it will not show the updated value.

I tried the following code as an example and when I debug and I can see the subreport text box. This example changes the value of all textbox items in the main report but not in the subreport.

ReportItemBase[] allTextBoxes = report.Items.Find(typeof(Telerik.Reporting.TextBox), true);
int i  = 0;
foreach (Telerik.Reporting.TextBox textBox in allTextBoxes)
{
   textBox.Value = (i++).ToString();
}


Steve
Telerik team
 answered on 24 Nov 2011
2 answers
193 views
Hello

I have a report connecting to mysql using a sqldataadapter.
When the report is generated it creates 8 pages all of the same report.
Any suggestions?

Thanks
JedF
Top achievements
Rank 1
 answered on 24 Nov 2011
7 answers
684 views
Hi,

I have a SQL view where one row of data is for Header section of the report and the remaining rows of data are for Details section of a report. 

I have a field "RowType" in the view with values: 
  - "HeaderData" for row of data that goes to Header section (the view has only one such row).
  - "DetailsData" for all other rows of data, which goes to Details section.

I tried adding filter to Details Group, but observed that this filters the whole report.
Also, I did not find any way to add filter to the Header Group.

My queries are:
1. On the Header section, how do I display only the data from the row containing "HeaderData" on "RowType" field? 
2. On the Details section, how do I display remaining data (with "DetailsData" on "RowType" field)  ?

Thanks in advance.
Sumit
Sumit
Top achievements
Rank 1
 answered on 24 Nov 2011
2 answers
116 views
Over the past weeks I have updated my Telerik controls in Visual Studio 2010 ASP.NET.  My project contains both ASP.NET AJAX and Telerik Reporting.  The ASP.NET AJAX is version 2011.3.1115.40 and the Telerik reporting is version 5.3.11.1116. 

Since starting the telerik control updates, the ReportViewer control -- in design view and when it displays the report -- is strectched to the right, and the ReportViewer controls are moved around in the ReportViewer. 

I've attached an image of the ReportViewer in the Visual Studio design view, and another image of the ReportViewer when it diplays a report.

Thanks for any help.
Robert Adkison
Top achievements
Rank 1
 answered on 23 Nov 2011
Top users last month
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
Sergii
Top achievements
Rank 1
Iron
Iron
Dedalus
Top achievements
Rank 1
Iron
Iron
Lan
Top achievements
Rank 1
Iron
Doug
Top achievements
Rank 1
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?