Telerik Forums
Reporting Forum
2 answers
275 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
243 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
135 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
220 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
97 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
115 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
637 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
152 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
1 answer
122 views
Hi, ALL
i am using Reportviewer as ReportMaking Tool.i tried a lot with Matrix and used ceiling function but i can't achieve it.I want to display Data in Report following manner

My Crieteria:

I Used to Develop An attendence Register for employees.Each Employees have Multiple Login and Logout.

Nw My Issue is I want to Group Each Employees with having his own IN and Out on a particular day he Present.And at the same time since each employees having several login and logout for a particular day.I want to Wrap a matrix after certain columns and display the rest in next line for that day of that employee

ie,

i Want in this format

Employee Name: E1

Present Day 1

IN1 OUT1 IN2 OUT2 IN3 OUT3..........after a particular column it should be wrapped and displayed in next line

IN4 Out4 IN5 OUT5...............this process is continued until all the login and Logouts of tht employees is displayed...

Then

Present Day2

INs and Outs

Present Day3

INs and Outs

After The first Employees

Similar Format is For all the other employees

Can Any one Help in this?
Hrisi
Telerik team
 answered on 02 Aug 2007
2 answers
303 views
I created two groups like
group1 and then a group2 inside now when i created a group 3 it gets added inside of group2 which is fine. but in this case i want to move that group upwards at the very top. The designer does let me drag the group upwards before the group1. How do i go about making it the first group

Thanks
Zeeshan HIrani
miacoviello
Top achievements
Rank 1
 answered on 02 Aug 2007
Top users last month
Will
Top achievements
Rank 2
Iron
Motti
Top achievements
Rank 1
Iron
Hester
Top achievements
Rank 1
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Thomas
Top achievements
Rank 2
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?