Hi Guys !!!
               Report Viewer is not showing in my toolbox items.I tried manually reference add and tried also reset toolbox items but still not showing. I am using Telerik Reporting for windows Forms...


Thanks.
Regards
Muhammad Umair

I am new to the Telerik suite and am just learning the ropes on creating Telerik reports.

I have a SQL Server stored procedure that outputs number of minutes (using datediff() function in SQL).  That is to be a signed integer.   My result set would look like this:
Date            Name        TotalMinutes
1/1/2011     Jim            20
1/2/2011     Jim            15
1/3/2011     Jim            30
1/4/2011     Jim            5 

I have a report setup to display the data just as it appears above. In a grouping footer I have it SUM the minutes to get a total (e.g. 70).  I created a user function that takes that value and adds 10 to it.  So, the expression for my textbox field in the footer is as follows:  = AddMinutes(Sum(Fields.TotalMinutes)), which given my example should return 80 for Jim

My user function is defined in a class file (DateFunctions.vb):

Public Shared Function AddMinutes(byval TotMinutes as Integer) as Integer
    return TotMinutes+10
End Function

I am not using any code-behind on the report itself.  I am just putting an Expression in through the GUI.  When I try to run this I get a Undefined Function error in the report.  I tried calling it as =DateFunction.AddMinutes(Sum(Fields.TotalMinutes)) and just as =AddMinutes(Sum(Fields.TotalMinutes)), but I keep getting the same error.

Please Help as I am stuck!

Hi

i have a Telerik Report Service project that has a dfew telerik reports. i can browse to the service and all works fine.
i've added this service as a service reference to my web application.

 

i can run the above code and have a list of report in "reports ". the problem is that the list is meanless to me because i cannot create an instance of any of the reports.
unlike in the silverlight report service (http://blogs.telerik.com/evanhutnick/posts/10-02-11/understanding_the_telerik_reporting_wcf_service.aspx)
that has an event.

 

Basically i need to know how to get the actual telerik reports or an instance of them that are in my reportservice project.
any help will be greatly appreciated.

Thanks
Avesh

Hi,

I have installed Reporting Q3 2009 on Windows 7 and using it in VS 2008, SQL 2005 and .Net 3.5 environment. I have created Reports class library and created a report which runs fine when I previewed it. However, when I added it to the web project, I keep getting "an item with the same key has already been added" on the line below
            RenderingResult result = reportProcessor.RenderReport("PDF", reportToExport, null);
I have used ReportViewer and also tried exporting programmatically to PDF format.

Any help is greatly appreciated.

Thanks,
Bhargavi.

I'm building custom modules on DNN and would like to use Telerik Reporting for reports. I'm trying to figure out how to set up and configure my development environment. I'm using VS 2008 and created a solution with two projects, as per the best practices documentation, one with my DNN website (this is a Website not a Web Application) and one for telerik reports. The custom code in the DNN website has two sepeperate namespaces (for the various custom modules) and a couple of different Linq datacontext's each under a unique namespace. I'm trying to figure out how to reference the linq datasources from the telerik reports project. If I'm going about this the wrong way please point me the right direction.

It'd be great if Telerik had some detailed documentation on using the Reporting prodcut with DNN since they've included telerik controls with the standard DNN install.

Thanks, all help is appreciated.

My report has as DataSource a stored procedure that needs some parameters in order to be executed.
The parameters should be applied by the user.

Both the disscussed parameters has store procedures as their datasource and are multiselectable.

The selected values of the first parameter should be combined to a string with ',' between the values,
That will be used as input to another sqlDataSource store procedure which is used in the DataSource
of a second report parameter.

I need to combine the values of the first parameter to 1 string, and to refresh the seconed datasource when the first was updated.

// First parameter: 

this.StorageSystemDataSource.ConnectionString = "...";  

this.StorageSystemDataSource.Name = "SystemDataSource";  

this.StorageSystemDataSource.SelectCommand = "dbo.GetSystemType";  

this.StorageSystemDataSource.SelectCommandType = Telerik.Reporting.SqlDataSourceCommandType.StoredProcedure; 

    

// Second parameter: 

this.SystemNameDataSource.ConnectionString = "..."; 

this.SystemNameDataSource.Name = "SystemNameDataSource"; 

this.SystemNameDataSource.Parameters.AddRange(new Telerik.Reporting.SqlDataSourceParameter[] { 

new Telerik.Reporting.SqlDataSourceParameter("@SystemTypes", System.Data.DbType.AnsiString, "=IIF(Parameters.SystemTypeParameter.Value(0) = -1, Nothing, Join(Parameters.SystemTypeParameter.Value, \",\"))")}); 

// is that the way to combine the values????

    

this.SystemNameDataSource.ProviderName = "System.Data.SqlClient"; 

this.SystemNameDataSource.SelectCommand = "dbo.GetSystemByTypes"; 

// I need to reactivate this stored procedure on each selection changes of the first parameter values.

this.SystemNameDataSource.SelectCommandType=Telerik.Reporting.SqlDataSourceCommandType.StoredProcedure;

I am currently exporting reports programmatically to pdf and recently have come up with a requirement where we need to export only a single or defined range of pages and not the entire report to the output pdf file. Is there anyway programmatically to only export 1 page or a range of pages ?

Hy, I'm making Payment slip report, I have MultiValue Parameter that starts from let's say A to C and every value have it's Id. Now I'm doing some MOD calculations with this Id's and it gives me different integer values based on selection, but the problem is when it come to C it uses it's value as final one and populates all data in the report with this value witch is no OK. I need to pass changing parameter based on Id and it's calculated value. Example: name A has Id 1 and has value 4, name B has Id 2 and value 2 etc. It should use parameter 4 for name A, Id 1, parameter 2 for name B, Id 2 and so on. Basically every name should have it's own unique calculated value on the report. Is this possible Thank you Aljosa

Hi,

Just wondering if distinct count function has been implemented?   I need a way to do a distinct count on a group level, is there any alternative I can try?

Thanks,

Scott

 

Hello Telerik Team,

I have a requirement to bind two data sources to a single report.I was trying some of your blogs to do that.

The method i used to display a subreport in a main report is as follows:

1>Created a report called "X" and put some fields in it and binded the datasource to that report and build it..its  working fine....As of now,I am not using any parameters.

2>I created another report called "Y" and from the tool box i dropped subreport item and
in the properties section I have selected the report source property as "x".

When i build the report "y" i get the error "Type name x-subreport does not exist in the type "Projectname"

I  tried using Need datasource event and it says the same error.dO i need to add anything to the project file.?

Please let me know.

Can you list the way step by step.
I am unable to achieve it.

Can you send me a sample to do that.

Thank you,
Smith