Telerik Forums
Reporting Forum
1 answer
107 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
149 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
736 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
43 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
234 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
302 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
5 answers
147 views
Perhaps I simply missed something more obvious, but I ran into this issue upon updating to the newest Reporting release. In a nutshell, reports that used to load correctly would fail to load, and all I could see in the viewer itself was "Error loading report".

Looking in the JavaScript console, I was able to trace it back to a 410 response being generated by the Reporting API controller, which was telling me that my report did not exist in the file cache. After trying a bunch of fixes, I eventually noticed that the actual URL being requested was not correct; instead of serializing the client ID properly, the helper was injecting [object Object] instead. On a hunch, I went ahead and made sure all of my Telerik/Kendo UI libraries were up-to-date; sure enough, with the SP2 update, the existing reports now render properly.

My complaint is that **nowhere** in the release notes for the Reporting updates does it specify that I **have** to use the latest Kendo UI scripts with the Report Viewer.
Stef
Telerik team
 answered on 17 Feb 2014
1 answer
64 views
We seem to have encountered an issue in the WPF Report Viewer (Q3 2013) where many of the text fields in the report are inexplicably missing their last character. In the attached image, the following problems are evident:

- The vertical axis should have the value "PU001", instead its "PU00" (the 1 is missing off the end)
- The horizontal axis first value after "0" should be "500", instead its "50" (the 0 is missing off the end)
- In the legend, the blue box should be labeled "Mitigated", instead its "Mitigate" (the 'd' is missing off the end)

When the report is exported to PDF however, everything appears as expected, so I'm assuming this is a bug in the WPF Report Viewer only.
Stef
Telerik team
 answered on 17 Feb 2014
1 answer
95 views
Once you use the wizard to create a report in the VS designer, can you re-run the wizard to make changes or do you have to start over each time?
Stef
Telerik team
 answered on 17 Feb 2014
Top users last month
Rob
Top achievements
Rank 3
Iron
Iron
Iron
Atul
Top achievements
Rank 1
Iron
Iron
Iron
Alexander
Top achievements
Rank 1
Veteran
Iron
Serkan
Top achievements
Rank 1
Iron
Shawn
Top achievements
Rank 1
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?