Telerik Forums
Reporting Forum
6 answers
170 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
97 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
118 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
117 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
160 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
766 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
53 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
245 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
312 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
8 answers
1.1K+ views

I  use dynamic table for Telerik Report porpose.I already created Telerik Report but when I use Dataset I can not show the fields of table How can I show the values of Dataset in report. 
Note : I did not define any field in design section because I do not know it and also Dataset is not empty

Since my T-SQL is dynamic, i can not assign fields to tables at the report design. I wonder how i can assign fields ?  


my code is as follow;

private void rpt_MPDlist_NeedDataSource(object sender, EventArgs e)
        {
            SqlConnection connSomsys = new SqlConnection(ConfigurationManager.AppSettings["conStr"]);
            SqlCommand selectCurrentYearTot;
            selectCurrentYearTot = new SqlCommand("CNF_MPDRelatedModList_search",connSomsys); 
            selectCurrentYearTot.CommandType = CommandType.StoredProcedure;
             selectCurrentYearTot.Parameters.AddWithValue("@table", this.ReportParameters["table"].Value);
            SqlDataAdapter adapter2 = new SqlDataAdapter(selectCurrentYearTot);
            DataSet ds = new DataSet();
            adapter2.Fill(ds); 
            table1.DataSource = ds;

        }

T-SQL code;

CREATE procedure CNF_MPDRelatedModList_search 
(     
 @table as nvarchar (200)   
)     
AS          
BEGIN      
 declare   @filename as nvarchar (400)     
 declare @sql as nvarchar (4000)     
 set @filename=@table     
      declare @deneme as nvarchar (4000)     
      set @deneme='2'   
set @SQL = replace(replace('select ATA_SB_NO,TITLE,MOD_NO,MP_NO,COMPLIANCE,EO_NO,NOTES from (SELECT ATA_SB_NO,TITLE,MOD_NO,cast (len (MOD_NO)as int) MD,MP_NO,cast (len (MP_NO) as int) MP,COMPLIANCE,EO_NO,NOTES FROM @filename  )mst where MP >@deneme  and M
D >@deneme' ,'@filename', @filename ),'@deneme',@deneme )                                    
            exec sp_executesql @SQL          
                     
END 


Jesse Flint
Top achievements
Rank 1
 answered on 17 Feb 2014
Top users last month
Rob
Top achievements
Rank 3
Bronze
Iron
Iron
Sergii
Top achievements
Rank 1
Iron
Iron
Dedalus
Top achievements
Rank 1
Iron
Iron
Lan
Top achievements
Rank 1
Iron
Doug
Top achievements
Rank 1
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?