Telerik Forums
Reporting Forum
4 answers
951 views
In trying to work with stored procedures to generate data for a Telerik report, I followed the tutorial located at this link:

http://www.telerik.com/support/kb/reporting/general/using-data-source-with-parameters-in-telerik-reporting.aspx


I have no data source set for the report, and am setting the data source to null during the constructor of the report object.

The issue is that the NeedDataSource Event does not seem to be firing....Is there anything else that needs to be done for the report to make this event fire when there is no data source?

I have tried using NeedDataSource and Need_DataSource...but still cannot get the event to fire....? Any further information that the tutorial might not include would be very helpful....Thanks!


     public MyReport()
        {
            InitializeComponent();
            this.DataSource = null;
        }

 private void MyReport_NeedDataSource(object sender, System.EventArgs e)
        {
            this.sqlDataAdapter1.SelectCommand.Parameters[@"ID"].Value = this.ReportParameters["VolID"].Value;

            Telerik.Reporting.Processing.Report rptTestReport = (Telerik.Reporting.Processing.Report)sender;

            rptTestReport.DataSource = this.sqlDataAdapter1;
        }
Steve
Telerik team
 answered on 18 Dec 2009
1 answer
139 views
Hello,

I've got two parameters that are defined in a report. I want to be able to pass these parameters through to the dataset that provides data for the report. I was able to do this in the autogenerated New() sub by just adding things like Me.ReportParameters("LastFind").Value to the line that fills the datatable.

The problem is that when somebody changes a parameter in the parameters editor when the report is displayed, those changes do not get passed through to the dataset.

Anybody know how I can pass those through? am I missing something obvious?

Thanks,

Mike
Steve
Telerik team
 answered on 18 Dec 2009
1 answer
162 views
I am building a report based on the reportbook. Is there a simple way to build a table of content with all the reports in the report book with page number  at the beginning?

Such as:


Contents
Intellectual Property Rights ............................................................................................................................... 2
Foreword ............................................................................................................................................................ 2
Foreword .......................................................................................................................................................... 66
1 Scope ..................................................................................................................................................... 67
2 References ............................................................................................................................................. 67
3 Definitions, conventions and applicability ............................................................................................. 76
3.1 Mobile station definition and configurations .................................................................................................... 76
3.2 Applicability .................................................................................................................................................... 76
3.2.1 Applicability of this specification ............................................................................................................... 76
3.2.1.1 MS equipped with a connector .............................................................................................................. 76
3.2.1.2 GPRS .................................................................................................................................................... 76
3.2.2 Applicability of the individual tests ............................................................................................................ 77
3.2.3 Applicability to terminal equipment ........................................................................................................... 77
3.3 Definitions ....................................................................................................................................................... 77
3.4 Conventions for mathematical notations .......................................................................................................... 77
3.4.1 Mathematical signs .................................................................................................................................... 77
3.4.2 Powers


thanks,

James
Steve
Telerik team
 answered on 18 Dec 2009
1 answer
158 views
Hi,

     I had a report and i set the Localizable = TRUE and Create both resources (for 2 languages) with the language propertie. At the main silverlight app at the current thread the language change by a combobox, i made the report but is still at the default language. Did i miss something? i have to pass it like a parameter and set the language at binding time? (i was trying this but it odesnt work :S)


Thanks for your help.
Best Regards.
Moises.
Chavdar
Telerik team
 answered on 17 Dec 2009
2 answers
360 views
I'm working on developing a best practices for reporting in our application.

Currently we're looking at SSRS (SQL Server Reporting Services) and Telerik (we use the client controls).

After looking at the documentation and installing the reporting tools I've come up against a wall at getting some basic data to display in a report.

Generally our app deals exclusively with entity objects.  On many pages we have a RadGrid in which we use the NeedDatasource event to call a static method on the type of the entity that the grid will display.  In this method we create a LINQ query and get back an IQueryable of entity objects which is then passed back to the datasource of the grid.  The dataset is set to the enumeration of the IQueryable.  We would like to continue doing this flow with reporting.

Our app currently moves the user through several wizard like screens of gathering information regarding what the report data will entail.  Once this data is collected a stored procedure is called that then gathers these "parameters" and does the calculations to produce a result set.  This result set basically contains some aggregate data that is brought together from various places in the database and worked into a meaningful order via the business logic in the stored procedure in regards to the user's inputs.

Even once this "report data" is created another query may be necessary to bring in some meaningful data from the inputed parameters.  This is really necessary when displaying in SSRS from the Reporting Server as each row in this query would be a displayable item in the report (the grouping of the report may change the query slightly but that is more a consideration once I have a complete understanding of how the report is to be designed).

So, the point is that this stored procedure generates the data for a single report and stores it in a table that contains this data for previously run reports.  My ideal situation would be to have the web page (or in our next version Silverlight control) call a method on the static type of the entity that represents this table of results that would return back the cached results for the report and pass this along to the telerik report.

This seams simple in theory.  I would just set the datasource for the report to be the results of this method call.  Am I correct in this assumption?

It should be noted that this is all fine and dandy if I can get to the point of actually "running" the report (I say running because the stored procedure actually creates the data and stores it in a table; in my simplest idea of how this would work the actually telerik report would "run" when it got the results of this query from a table - this report may be "run" multiple times but the stored procedure would only be run when the user wanted get the most up-to-date info).  Right now I cannot get the report designer to allow me to design a report with an object.

How do I do this???  I have created a report project and added it to my solution.  In this project I have included a reference to the assembly that deals exclusively with creating these entity objects and handing them off to consumers.  In the wizard I have followed the steps to use an object as a data source yet there are no auto-generated columns shown for the report nor are they appearing under the "Data Explorer".  The "Data Explorer" shows "No Data Source".

This leaves me wondering how to design a report when I cannot see the datasource in the designer.  I assume it would be possible for me to hand code each expression.  This seems tedious and time consuming.

The biggest advantages for us using Telerik's reporting is that we can embed the report in Silverlight and that we supposivly use Entity Framework business objects (or POCO - plain old class object) as a data source.  It just seems to me that it is possible, but just difficult or not a "best practice".

Please provide some ideas where I might be making bad assumptions, have incorrect ideas of what is possible, or some solutions to make our desired workflow possible.

Thanks,

Michael Gardner
Steve
Telerik team
 answered on 17 Dec 2009
1 answer
119 views
I installed Telerik reporting tool Q3 2009, when I open VS 2008 and select add new item, the telerik reporting template is not among the icon list. I followed the directory C:\Program Files\Microsoft Visual Studio 9.0\Common7\IDE\VCSExpress\ItemTemplates but couldn't find the Telerik template directory. I repaired the installation a number of times but didn't bring change. I uninstalled and re-installed the tool yet didn't help. How do I start using the tool? I have a 32bit, Windows XP SP2 on Virtual Box. Please assist.
Hrisi
Telerik team
 answered on 17 Dec 2009
6 answers
217 views
I have installed telerik reports

When I open up VS2010 b2 there is no telerik reports in the toolbox

there is no right click add telerik report option

have I missed something?
Karl Magnor Lilleland
Top achievements
Rank 1
 answered on 17 Dec 2009
8 answers
708 views
Hello,

currently I'm evaluating the Telerik Reporting. During my test I observed many emty pages in a report. It seems that the text is not displayed if it contains more than 32490 characters even though the space for the text is reserved (empty pages).

During my evaluation it turned out, that the Telerik Reporting is a great reporting tool and I would like to use it to replace the current reporting solution in a cusomer project. However, since long text is heavily used in the customers application I would like to know whether this bug is known and if there are any plans to fix it in the next time. Is there any workaround?

Best Regards
Olaf

Olaf Meyer
Top achievements
Rank 1
 answered on 17 Dec 2009
4 answers
108 views
I have a website created in one project then I created another project to test out the telerik report.  Each one is in their own directory and each works by themselves.  So now I want to add the report into a reportviewer on the webpage so here is what I do.

Open the website.
Add a reference
Browse to the bin/release (rpt_name.dll)
Press ok.
On the webapge I add a report viewer
Select the report I want it to show (It does show up in the drop down listing)
Build/publish the website (No compile errors)

Goto the webpage to view it and I get this.
Configuration Error   
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.   
 
Parser Error Message: Could not load file or assembly 'Telerik.Reporting, Version=3.2.9.1211, Culture=neutralPublicKeyToken=a9d7983dfcc261be' or one of its dependencies. The system cannot find the file specified.  
 
Source Error:   
 
 
Line 61:                <add assembly="System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>  
Line 62:                <add assembly="System.Design, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>  
Line 63:                <add assembly="Telerik.Reporting, Version=3.2.9.1211, Culture=neutral, PublicKeyToken=a9d7983dfcc261be"/>  
Line 64:                <add assembly="Telerik.ReportViewer.WebForms, Version=3.2.9.1211, Culture=neutral, PublicKeyToken=A9D7983DFCC261BE"/></assemblies> 
Line 65:        </compilation> 
   
 
bradley baker
Top achievements
Rank 1
 answered on 16 Dec 2009
3 answers
300 views
This error pops up in the Silverlight Report Viewer after I deploy to prod - XAML rendering format is not available

This is another of those "works fine on my dev machine, but not in prod." issues.  I've followed the deployment process to the letter.  Anyone else running into this?

I'm using version 3.2.9.1211 of Telerik Reporting and Silverlight Report Viewer.   
Steve
Telerik team
 answered on 16 Dec 2009
Top users last month
Edmond
Top achievements
Rank 1
Iron
fabrizio
Top achievements
Rank 2
Iron
Veteran
RobMarz
Top achievements
Rank 2
Iron
Fakhrul
Top achievements
Rank 1
Iron
Tejas
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?