Telerik Forums
Reporting Forum
1 answer
181 views
Is it possible to pass a DevForce business object to a Telerik report?  If so, how?  The syntax that I am trying to arrive at is something like this:

MyTelerikReport.Datasource = MyBindingSource.Datasource;

I am getting too simple here?
Ling
Rossen Hristov
Telerik team
 answered on 16 Aug 2007
3 answers
333 views
I have created a report with a group in it:
  group1.Grouping.Add(new GroupExpression("id1"));

When I run the report the data comes out in the groups I would expect, eg
Group1
  data
Group2
  data
Group3
  data

I then add a sort expression:
  group1.Sorting.Add(new SortExpression("id2"));

and now when I run the report I get fragmented groups:
Group1
  data
Group2
  data
Group1
  somemore data
Group3
  data
Group2
  somemore data

How do I correctly sort data within a group?
Svetoslav
Telerik team
 answered on 16 Aug 2007
2 answers
328 views
Hi,

I'm using this tool to generate ad-hoc reports based on selection criteria provided by the user.  I have a series of report templates and each of those are connected to the same SQL adapter - the only thing that changes is the WHERE clause of the select statement.  How can I change the SQL statement on a report via the ReportViewer at run-time?  My code-behind is VB.

Thanks,

Manon
Manon
Top achievements
Rank 1
 answered on 14 Aug 2007
1 answer
288 views
Hi,

I downloaded the reporting tool a few days ago and have been playing with it.  It looks slick and some of the features coming in Q2 look great.  I am, however, having some trouble binding data...

I have a DataSet that queries a SQL db (connection string stored in web.config as normal).  It works fine via the DataSet editor and is identical to all the DataSets I've setup in the past.  When I create a new Telerik Report and set that DataSet as the DataSource, it recognizes it and shows me all the fields in the Telerik Data Explorer window.  I drag them on to report and it all looks fine.  I then create a new aspx page and drop a Telerik Report Viewer on and tie it to the report I just created and run it and it's empty.  If I put text in the header or footer, they show up, but there's no data for the details section.

If I drop a datagrid on the page and tie it to the same DataSet, it works fine.

I then created a Crystal report using the same DataSet and when I went to run it, I got a page that asked for server, db, user, pwd info (said "The report you requested requires further information").

I then created an XML file with the data in it (just locally so there wouldn't be any permissions issues) and then in the report1.cs created a dataset and read the XML into the dataset and manually created fields on the report tied to the fieldnames from the XML and it worked perfectly.

It seems that there is some permissions issue.  Have you had this issue before and is there an easy way to remedy it?  Your report writer is intuitive and everything was working the way I expected, till suddenly there was no data!  Obviously I can't use XML for everything, so I need to figure out a better way to get around this issue.

There are lots of results for the issue I found with the Crystal reports, and likely it's the same underlying problem as I'm seeing with the Telerik reports (I'm guessing)
http://www.google.com/search?q=%22The+report+you+requested+requires+further+information%22+ASP%2eNET+Crystal+Reports

Thanks for any help

Ben
Chavdar
Telerik team
 answered on 13 Aug 2007
1 answer
160 views
Newbe here,

Able to run Telerik reports on my local machine using VS2005.  All reports work great.

What am I supposed to do on my web server.  I copied the BIN and the APP_Code directories to the web server, and now the site won't come up.  I know the problem is in the web.config where Telerik makes references to some assemblies and other stuff.  Is there any documentaion for deploying to a web server?
Thanks in advance, JD
Chavdar
Telerik team
 answered on 13 Aug 2007
1 answer
259 views
Pleasant Greetings!

I need to build ad hoc reports. Our current database solution allows the creation of reports via MS SQL Reporting Services. This is a fine solution, which works fine. However, SSRS provides a high degree of overhead we would prefer to avoid. Telerik seems a fine alternative. The goal is to keep all the existing infrastructure, only replacing the presentation layer with Telerik Reporting.
________________
Currently, we support the following:
________________
The user will specify a "data set" from a predefined list of data sets the system provides. Based on the selected dataset, the user can pick associated fields for display. Also, Sorting and Grouping criteria can be added to each field.

All of these specifications are stored to a database, so the report can be repeatedly viewed.
_______________
What needs to happen is that I need to be able to create telerik textbox objects on the fly to correspond to the selected fields. Once the report layout is complete, I simply need to attach the datasource and view the report.

For performance reasons, it would be great if the generated report could be stored somewhere, somehow.

Thanks for any guidance, code samples, etc. that you can provide.

Tom
Rossen Hristov
Telerik team
 answered on 13 Aug 2007
1 answer
128 views
Hi,

Here is some sample code that ought to work (IMHO). Can you explain why it does not?

Thanks!!

Tom

        DataSet ds = new DataSet();  
        ds.Tables.Add();  
        ds.Tables[0].Columns.Add("a");  
        ds.Tables[0].Columns.Add("b");  
 
        ds.Tables[0].Rows.Add("a1", "b1");  
        ds.Tables[0].Rows.Add("a2", "b2");  
        ds.Tables[0].Rows.Add("a3", "b3");  
 
        Telerik.Reporting.TextBox tb = new Telerik.Reporting.TextBox();  
        Report1 r = new Report1();  
 
          
        r.DataSource = ds.Tables[0];  
 
        tb.CanGrow = true;  
        tb.Value = "=a";  
        tb.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(1.625, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.5, Telerik.Reporting.Drawing.UnitType.Inch));  
        tb.Name = "a";  
        tb.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.625, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.25, Telerik.Reporting.Drawing.UnitType.Inch));  
        tb.Style.BackgroundColor = System.Drawing.Color.White;  
        r.Items.Add(tb);  
          
 
        tb = new Telerik.Reporting.TextBox();  
        tb.CanGrow = true;  
        tb.Value = "=b";  
        tb.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(3.625, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.5, Telerik.Reporting.Drawing.UnitType.Inch));  
        tb.Name = "b";  
        tb.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.625, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.25, Telerik.Reporting.Drawing.UnitType.Inch));  
        tb.Style.BackgroundColor = System.Drawing.Color.White;  
        r.Items.Add(tb);  
 
        telerik.Report = r; 
Rossen Hristov
Telerik team
 answered on 13 Aug 2007
1 answer
150 views
Hello,

Telerik Reporting doesn't support .NET 1.1.
But I really need it in .NET 1.1 web app.

Is there any way include it into the application?
Maybe wrap it someway in .NET 1.1 library...

Thanks,
Dmitriy.
Svetoslav
Telerik team
 answered on 13 Aug 2007
3 answers
709 views
Hi,

How do I change the size and location of a TextBox at runtime?

I tried using the ItemDataBound event to set the size and location of the Processing.TextBox but these properties are ReadOnly.

I have to set the position and size (width) of the the TextBox based on it's value.

Thanks,
Bo
Svetoslav
Telerik team
 answered on 10 Aug 2007
1 answer
181 views
Hello,

Im creating reports using charts and ive several questions. First of all im using a bar chart. The data im using creates lots series. For each item on the x axis, there is one or more bars. So for example, 6 items on the x axis with 3 bars each.

One of the problems i encounter is that the labels for the x axis overlap each other and they become unreadable. Ive noticed that the chart is rendered quite small for all the data i need to display. I was looking for a solution and i thought maybe a good idea, at least for printing purposes, is that the chart could be rendered vertically. That way no matter how huge it is it will display all the series in a more viewable manner. Or maybe there is a better aproach for this problem.

So,
-How do i prevent labels from overlaping each other?
-How can i make the chart biger so the series are more viable?

Thanks in advanced,
Dan A. Rodriguez
Chavdar
Telerik team
 answered on 03 Aug 2007
Top users last month
Simon
Top achievements
Rank 2
Iron
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Marco
Top achievements
Rank 4
Iron
Iron
Iron
Grant
Top achievements
Rank 3
Iron
Iron
Iron
Kao Hung
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?