Telerik Forums
Reporting Forum
12 answers
867 views
Recently we upgraded our version of Telerik Reporting.  In a few of our reports, the way we were accessing the report param selected values in the code behind broke, but we made the necessary corrections to access the parameter values.

However, we still have a scenario where I can't seem to access the values of the report parameters...

We have a aspx page that contains a telerik ReportViewer.  Also on the page, we have a save button - that allows them to save the parameters they have selected in the report that is displayed in the ReportViewer.   So in the code we get the ReportSource of the ReportViewer, and then pull the values of the parameters, and save them to the database.  When we upgraded (to Q1 2013), this stopped working. (the values for the parameters are always null (or the default))

We were accessing the parameter like this:
Telerik.Reporting.IReportDocument document =
   ((Telerik.Reporting.InstanceReportSource)this.ReportViewer1.ReportSource).ReportDocument;
 
foreach (Telerik.Reporting.ReportParameter p in document.ReportParameters)
{
  object value = p.Value;
}   

 

Is there a way of getting the parameter values?


Nasko
Telerik team
 answered on 20 Feb 2014
6 answers
184 views
I have tried reading the documentation provided and searching online, but  i have no idea where to start when it comes to a chart.  I have a sql query generating a report in VS 2010 connecting to a sqldatasource.  I want to create a chart but cannot seem to get it to work properly.  Does anyone know of a good guide or place to get an overview or a video to watch on how this works from start to finish, even on a simple example.  I think once i get the idea i can extrapolate from there. thanks for the help.
Nasko
Telerik team
 answered on 20 Feb 2014
3 answers
111 views
Before using session state in IIS reports worked fine, but then we implement session status reports stopped working. He shows me the following error.

" Unable to serialize the session state. In 'StateServer' and 'SQLServer' mode, ASP.NET will serialize the session state objects, and consequently, non-serializable objects or MarshalByRef are allowed. The same restriction applies if the store custom session state performs a similar serialization in 'Custom' mode. "

I appreciate a prompt response. Thank you.
Stef
Telerik team
 answered on 20 Feb 2014
1 answer
137 views
Hello,

I'm load testing my application right now. It consists of a web app which is calling a WCF Rest service to render the a report in PDF.

When we are sending 5 requets from 5 differents tabs of the browser, we realized that every report are rendered one after the other. As they are large reports about 4 minutes to render. I'm wondering if there is a way to configure the ReportProcessor in order to parallelize the rendering?

Thanks in advance for your help,

See in attachment, a graph of CPU, memory and IO. large IO spikes is basically when the app is writing a report to the disk.

Pierrick
Stef
Telerik team
 answered on 20 Feb 2014
1 answer
130 views
In our main report we have 3 subreports. We need to show the record number for each subreport at the main report footer. How to access the subreport result from the main report? Thank you.
KS
Top achievements
Rank 1
 answered on 19 Feb 2014
1 answer
169 views
       
strSql = @"”;

        DataTable dt = new
DbService().getDT(strSql);

 

        if (dt.Rows.Count > 0)

        {           

            PrintInvoiceRpt Rpt1 = new
PrintInvoiceRpt();

           

 

           

            #region Sub Report BreakDown Query           

 

                        strSql = @"";

 

 

           
Telerik.Reporting.SubReport subRpt =
(Telerik.Reporting.SubReport)Rpt1.Items.Find("subReport1", true)[0];
// Sub Report

can any one suggest me,
 how to add sub report in report book

            DataTable dt_SubReport = new
DbService().getDT(strSql);

            if (dt_SubReport.Rows.Count > 0)

            {

               
subRpt.ReportSource.DataSource = dt_SubReport;

            }

 

 

            #endregion Sub Report BreakDown Query

           

            reportBook.Reports.Add(new PrintInvoiceRpt());

           
reportBook.Reports[0].DataSource = dt;

           
RptViewer.Report = reportBook;           


 

        }

 

 

Main report showing in report book but sub report
not showing ,

How to add subreport of  PrintInvoiceRpt
in report book

I am using Version=5.3.12.119, OR
Q3 2011

 can any one suggest me,how to add subreport in report book


Stef
Telerik team
 answered on 19 Feb 2014
8 answers
822 views
I have been working around telerik reports for many days. This time I needed to put up a chart on my report as well. I have XML data (coming from database) to been shown in report, plus to make chart from very same data. I did same as described in http://blogs.telerik.com/kevinbabcock/posts/09-02-06/bind_your_telerik_reports_to_xml_data.aspx to deal with xml. I have only two columns to be shown as text values (what I have done exactly as described in link), Then I those two columns on left side and placed a chart on right hand side. And populated it in NeedDatasource event. But chart is repeating for every data on left hand side. Please tell me what am I missing over here?
Edmund Covington
Top achievements
Rank 1
 answered on 19 Feb 2014
1 answer
61 views
Hello,

I made a report with 4 crosstabs in detail section (I want to avoid doing subreports)
The report doesn't have datasource but each crosstab has its own datasource.
In the ReportFooter section i want to show a general total (The sum of crosstabs's total cells).

Example :
Crosstab1 total cell  = Sum(Fields.AcResult) = 1000
Crosstab2 total cell = Sum(Fields.VeResult) = 500
Crosstab2 total cell = Sum(Fields.PaResult) = 0
Crosstab2 total cell = Sum(Fields.CcResult) = -100
ReportFooter total should be 1400

How can i define the reportfooter total  textbox value ?

Thank you for your help
Stephane
KS
Top achievements
Rank 1
 answered on 18 Feb 2014
2 answers
264 views
Hello,

We are developing a web service that loads TRDX files that users created into XmlReportSource and renders PDF files and send back to web clients using RenderReport of a ReportProcessor object. In TRDX files, our users want to set two parameters in SQL to create a SQL statement that contains BETWEEN with a begin date and a end date and use just one parameter to pass in, separated by commas.

The SQL statement is something like:

SELECT * FROM APPLICANT
WHERE DATE_CREATED BETWEEN @BeginDate AND @EndDate

Since our users have accustomed to pass just one parameter to accomplish this, they are unwilling to create two report parameters: one for begin date and one for end date. They want to create just ONE report parameter to basically parse the report parameter value into two SQL parameter values.

I have created a report parameter type string that receives the begin date and the end date separated by a comma ex. 1/1/2013,12/31/2013.

In the data source side, I would like to do something like:
Parameters:
Name: @BeginDate
Type: DateTime
Value:=CDate(Split(",",  Parameters.ReportDate.Value[0]))

Name: @EndDate
Type: DateTime
Value:=CDate(Split(",",  Parameters.ReportDate.Value[1]))

Of course this give me errors at [ characters.

Is there anyway to define the parameter?

Thanks
Shoji Kaburagi
Top achievements
Rank 1
 answered on 18 Feb 2014
1 answer
329 views
Hello Telerik,

I am creating the Telerik report we need to create a report dynamically
and attaching that

 report in Asp.net web
application, i have tried to doing this using Telerik Reporting Demo, but it is
shown by wizard steps. i need to create a Report using database Programmatically.

 we use compulsory  class library or we can use direct report in web
application ? 

so please give me some demo example using report in web
application with programmatically

 for this type of
Report.

Thanks,

Hitesh
Nasko
Telerik team
 answered on 18 Feb 2014
Top users last month
Boardy
Top achievements
Rank 2
Veteran
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
ivory
Top achievements
Rank 1
Iron
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
ClausDC
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?