Telerik Forums
Reporting Forum
2 answers
117 views
Hey guys, I wanted to ask a quick question after reading the documentation on groupings I don't think it will accomplish what I am looking for: Heres an example

Different customers have set data and on that data they assign a grouping to that data. Groupings can be whatever the customer specify s.  So on the report it should look like 
Data Data Data
Data Data Data
Grouping1      Sub-Total   Sub-Total  Subtotal
Data  Data  Data
Data  Data  Data
Grouping2    Sub-Total   Sub-Total  Subtotal

All the groupings are stored in a database along with the data. What would you reccommend to do something like this, From what I could tell the grouping part of rad reporting wouldn't solve this.

Thanks in advance.
Yonggu Kang
Top achievements
Rank 1
Iron
 answered on 20 Jun 2013
13 answers
476 views
I know Telerik plan to have an export to Word option in the future and it's not in Q3 2007 but I have a project coming up that requires this functionality and would like to consider it for possible use.

Something like Crystal Reports has an export to Word capability but the resulting document is formatted using frames and is very difficult to edit. There is a product built onto SQL Reporting Services (OfficeWriter by SoftArtisans) that creates a 'proper' Word document that you can edit as if you had created it in Word yourself.

What I'm interested in finding out is whether the plans for export to Word in Telerik Reporting would produce a document fomatted using frames or one that would be a 'proper' Word document?

Are your plans this far advanced to be able to provide an answer?

Thanks for your help.
Peter
Telerik team
 answered on 19 Jun 2013
1 answer
179 views
A sorry error is generated when trying to export some of our new reports. 
It appears to be tied to there being a large amount of data in the export.
We are able to reproduce this when there was a search criteria on 439 
records. We were able to export this report to pdf when doing so directly 
from the web server. 

Has anyone else run across this error and if so how did you resolve it?

We are using VS2010 Pro and Q3 2012  Telerik reporting.
Stef
Telerik team
 answered on 19 Jun 2013
1 answer
51 views
ActiveReports has a format method for each section.  This is where the code activity occurs to populate boxes within these sections.  I do not see that telerik reporting has that option so where does the code reside that would populate the txtboxes on the sections.  I have no code to attach because i can not find where to put it.
Stef
Telerik team
 answered on 19 Jun 2013
20 answers
986 views

How do I export to WORD? I am using winform.
I can do to PDF and XLS DOC for not more!!

reportViewer1.ExportReport("DOC", new Hashtable());   // BAD
reportViewer1.ExportReport("XLS", new Hashtable());   // OK
reportViewer1.ExportReport(
"PDF", new Hashtable());   // OK


Could someone help me?

Calvin
Top achievements
Rank 1
 answered on 18 Jun 2013
3 answers
495 views
Hi,

Iam using "cross tab" to view the data in matrix, this report shows the data product wise sales as column group and row group as month. Every month has some of amount and sales and number of sales which iam displaying in different columns. How can i get the cumulative sales totals amount and number of sales. Please see the example below

Products          X                                 Y                      Z
July                 200                              300                   400
August            400*(200+200)             700(300+400)    650(400+250)
                    

For example for product X (I need 400 as total in the month of August which include 200 which is july sales)

Please help.  
Stef
Telerik team
 answered on 18 Jun 2013
1 answer
118 views
i am using the following code: which returns error invalid uri unknown format.  What i want to do is when my print button is selected on my winform i want the report to show and be editable maintaining format that is passed to it.  Also need to know how to pass data to various textboxes on the reports.
<FONT size="2" face="Consolas"><FONT size="2" face="Consolas"><FONT size="2"
face="Consolas"><FONT size="2" face="Consolas">
<P>Telerik.Reporting.</P>
<P></FONT> </P>
<P></P>
<P></FONT> </P>
<P><FONT color="#2b91af" size="2" face="Consolas"><FONT color="#2b91af" size="2"
face="Consolas"><FONT color="#2b91af" size="2"
face="Consolas">UriReportSource</FONT></FONT></FONT><FONT size="2" face="Consolas"><FONT
size="2" face="Consolas"> Telrpt = </FONT></FONT><FONT color="#0000ff" size="2"
face="Consolas"><FONT color="#0000ff" size="2" face="Consolas"><FONT color="#0000ff"
size="2" face="Consolas">new</FONT></FONT></FONT><FONT size="2"
face="Consolas"><FONT size="2" face="Consolas">
Telerik.Reporting.</FONT></FONT><FONT color="#2b91af" size="2"
face="Consolas"><FONT color="#2b91af" size="2" face="Consolas"><FONT color="#2b91af"
size="2" face="Consolas">UriReportSource</FONT></FONT></FONT><FONT size="2"
face="Consolas"><FONT size="2" face="Consolas">();</FONT></FONT></P>
<P><FONT size="2" face="Consolas"><FONT size="2" face="Consolas"> </P>
<P> Telerik.Reporting.</P>
<P></FONT> </P>
<P></P>
<P></FONT> </P>
<P><FONT color="#2b91af" size="2" face="Consolas"><FONT color="#2b91af" size="2"
face="Consolas"><FONT color="#2b91af" size="2"
face="Consolas">UriReportSource</FONT></FONT></FONT><FONT size="2" face="Consolas"><FONT
size="2" face="Consolas"> Telrpt2 = </FONT></FONT><FONT color="#0000ff" size="2"
face="Consolas"><FONT color="#0000ff" size="2" face="Consolas"><FONT color="#0000ff"
size="2" face="Consolas">new</FONT></FONT></FONT><FONT size="2"
face="Consolas"><FONT size="2" face="Consolas">
Telerik.Reporting.</FONT></FONT><FONT color="#2b91af" size="2"
face="Consolas"><FONT color="#2b91af" size="2" face="Consolas"><FONT color="#2b91af"
size="2" face="Consolas">UriReportSource</FONT></FONT></FONT><FONT size="2"
face="Consolas"><FONT size="2" face="Consolas">();</FONT></FONT></P>
<P><FONT size="2" face="Consolas"><FONT size="2" face="Consolas"> </P>
<P> Telrpt.Uri = </P>
<P></FONT> </P>
<P></P>
<P></FONT> </P>
<P><FONT color="#a31515" size="2" face="Consolas"><FONT color="#a31515" size="2"
face="Consolas"><FONT color="#a31515" size="2"
face="Consolas">"TelRptContractTest.trdx"</FONT></FONT></FONT><FONT size="2"
face="Consolas"><FONT size="2" face="Consolas">;<BR><FONT size="2" face="Consolas"><FONT
size="2" face="Consolas"></P>
<P>System.Drawing.Printing.</P>
<P></FONT></P>
<P></P>
<P></FONT></P>
<P><FONT color="#2b91af" size="2" face="Consolas"><FONT color="#2b91af" size="2"
face="Consolas"><FONT color="#2b91af" size="2"
face="Consolas">PrinterSettings</FONT></FONT></FONT><FONT size="2" face="Consolas"><FONT
size="2" face="Consolas"> printerSettings = </FONT></FONT><FONT color="#0000ff"
size="2" face="Consolas"><FONT color="#0000ff" size="2" face="Consolas"><FONT
color="#0000ff" size="2" face="Consolas">new</FONT></FONT></FONT><FONT size="2"
face="Consolas"><FONT size="2" face="Consolas">
System.Drawing.Printing.</FONT></FONT><FONT color="#2b91af" size="2" face="Consolas"><FONT
color="#2b91af" size="2" face="Consolas"><FONT color="#2b91af" size="2" face="Consolas">PrinterSettings</FONT></FONT></FONT><FONT
size="2" face="Consolas"><FONT size="2" face="Consolas">();</FONT></FONT></P>
<P><FONT size="2" face="Consolas"><FONT size="2" face="Consolas"> </P>
<P> System.Drawing.Printing.</P>
<P></FONT></P>
<P></P>
<P></FONT></P>
<P><FONT color="#2b91af" size="2" face="Consolas"><FONT color="#2b91af" size="2"
face="Consolas"><FONT color="#2b91af" size="2"
face="Consolas">PrintController</FONT></FONT></FONT><FONT size="2" face="Consolas"><FONT
size="2" face="Consolas"> standardPrintController = </FONT></FONT><FONT color="#0000ff"
size="2" face="Consolas"><FONT color="#0000ff" size="2" face="Consolas"><FONT
color="#0000ff" size="2" face="Consolas">new</FONT></FONT></FONT><FONT size="2"
face="Consolas"><FONT size="2" face="Consolas">
System.Drawing.Printing.</FONT></FONT><FONT color="#2b91af" size="2" face="Consolas"><FONT
color="#2b91af" size="2" face="Consolas"><FONT color="#2b91af" size="2" face="Consolas">StandardPrintController</FONT></FONT></FONT><FONT
size="2" face="Consolas"><FONT size="2" face="Consolas">();</FONT></FONT></P>
<P><FONT size="2" face="Consolas"><FONT size="2" face="Consolas"> </P>
<P> Telerik.Reporting.Processing.</P>
<P></FONT></P>
<P></P>
<P></FONT></P>
<P><FONT color="#2b91af" size="2" face="Consolas"><FONT color="#2b91af" size="2"
face="Consolas"><FONT color="#2b91af" size="2"
face="Consolas">ReportProcessor</FONT></FONT></FONT><FONT size="2" face="Consolas"><FONT
size="2" face="Consolas"> reportProcessor = </FONT></FONT><FONT color="#0000ff"
size="2" face="Consolas"><FONT color="#0000ff" size="2" face="Consolas"><FONT
color="#0000ff" size="2" face="Consolas">new</FONT></FONT></FONT><FONT size="2"
face="Consolas"><FONT size="2" face="Consolas">
Telerik.Reporting.Processing.</FONT></FONT><FONT color="#2b91af" size="2" face="Consolas"><FONT
color="#2b91af" size="2" face="Consolas"><FONT color="#2b91af" size="2" face="Consolas">ReportProcessor</FONT></FONT></FONT><FONT
size="2" face="Consolas"><FONT size="2" face="Consolas">();</FONT></FONT></P>
<P><FONT size="2" face="Consolas"><FONT size="2" face="Consolas"> </P>
<P> Telrpt.Parameters.Add(</P>
<P></FONT></P>
<P></P>
<P></FONT></P>
<P><FONT color="#0000ff" size="2" face="Consolas"><FONT color="#0000ff" size="2"
face="Consolas"><FONT color="#0000ff" size="2"
face="Consolas">new</FONT></FONT></FONT><FONT size="2" face="Consolas"><FONT
size="2" face="Consolas"> Telerik.Reporting.</FONT></FONT><FONT color="#2b91af"
size="2" face="Consolas"><FONT color="#2b91af" size="2" face="Consolas"><FONT
color="#2b91af" size="2" face="Consolas">Parameter</FONT></FONT></FONT><FONT
size="2" face="Consolas"><FONT size="2" face="Consolas">(</FONT></FONT><FONT
color="#a31515" size="2" face="Consolas"><FONT color="#a31515" size="2" face="Consolas"><FONT
color="#a31515" size="2" face="Consolas">"txtLocation"</FONT></FONT></FONT><FONT
size="2" face="Consolas"><FONT size="2" face="Consolas">,
Location));</FONT></FONT></P>
<P><FONT size="2" face="Consolas"><FONT size="2" face="Consolas"> </P>
<P> Telerik.Reporting.</P>
<P></FONT></P>
<P></P>
<P></FONT></P>
<P><FONT color="#2b91af" size="2" face="Consolas"><FONT color="#2b91af" size="2"
face="Consolas"><FONT color="#2b91af" size="2"
face="Consolas">InstanceReportSource</FONT></FONT></FONT><FONT size="2" face="Consolas"><FONT
size="2" face="Consolas"> instanceReportSource = </FONT></FONT><FONT color="#0000ff"
size="2" face="Consolas"><FONT color="#0000ff" size="2" face="Consolas"><FONT
color="#0000ff" size="2" face="Consolas">new</FONT></FONT></FONT><FONT size="2"
face="Consolas"><FONT size="2" face="Consolas">
Telerik.Reporting.</FONT></FONT><FONT color="#2b91af" size="2"
face="Consolas"><FONT color="#2b91af" size="2" face="Consolas"><FONT color="#2b91af"
size="2" face="Consolas">InstanceReportSource</FONT></FONT></FONT><FONT size="2"
face="Consolas"><FONT size="2" face="Consolas">();</FONT></FONT></P>
<P><FONT size="2" face="Consolas"><FONT size="2" face="Consolas"> </P>
<P> </P>
<P> </P>
<P> reportProcessor.PrintController = standardPrintController;</P>
<P> </P>
<P> reportProcessor.PrintReport(Telrpt, printerSettings); </P>
<P></FONT></FONT></FONT></FONT></P>
<P><FONT size="2" face="Consolas"><FONT size="2"
face="Consolas"></FONT></FONT></FONT></FONT> </P><FONT size="2" face="Consolas"><FONT
size="2" face="Consolas"></FONT></FONT><FONT size="2" face="Consolas"><FONT
size="2" face="Consolas"></FONT></FONT><BR>
IvanY
Telerik team
 answered on 18 Jun 2013
3 answers
118 views
ActiveReports has this option to display report:
pdfReport.Options.DisplayMode = DataDynamics.ActiveReports.Export.Pdf.DisplayMode.FullScreen;

Does telerik reporting have a similar option?  I can not seem to locate it .  So far I have tried the following:
Telerik.Reporting.Report Telrpt = new TelRptContract();
                    Telerik.Reporting.Processing.ReportProcessor TelContractrp = new Telerik.Reporting.Processing.ReportProcessor();
                    System.Collections.Hashtable deviceInfo = new System.Collections.Hashtable();
                    Telerik.Reporting.InstanceReportSource TelContractirs = new Telerik.Reporting.InstanceReportSource();
                    TelContractirs.ReportDocument = Telrpt;
                    Telerik.Reporting.Processing.RenderingResult result = TelContractrp.RenderReport("PDF", TelContractirs, deviceInfo);
                    string dContract = DateTime.Now.ToString().Replace("/", "");
                    dContract = dContract.Substring(0, 9);
                    string fileName2 = result.DocumentName + "_" + dContract + "." + result.Extension;
                    //string path2 = "c:\\Users\\akinw\\Desktop\\";
                    //string path2 = System.IO.Path.GetTempPath();
                    string path2 = Environment.GetFolderPath(Environment.SpecialFolder.Desktop);
                    string filePath2 = System.IO.Path.Combine(path2, fileName2);
                    FileStream fs = new FileStream(filePath2, FileMode.Create);
                    fs.Write(result.DocumentBytes, 0, result.DocumentBytes.Length);
                    fs.Close();
                    //fs = File.Open(filePath2, FileMode.Open);                   
                    System.IO.File.Open(filePath2, FileMode.Open);

The commented out part is an option I have tried.  The report converts and is saved to my desktop but does not open. What is missing?  Thanks in advance.
Peter
Telerik team
 answered on 18 Jun 2013
1 answer
128 views

I want to declare a telrik report and then start passing data to it for display.  In the following code it is seen that my activereports- which reside in another project) are seen.  but when i do similar code for telrik report it can not find the report and the telrik report resides in the same project that the activereports are.  What is the solution.  When I add Telrpt.Uri = "name of report"; at debug an error occurs stateing it can not find the uri. 

So this is two pronged 1. How can I do similar with telerik (Telerik.Reporting.Report = new TelRptContractTest(); as is done with activereport (DataDynamics.ActiveReports.ActiveReport rpt = new RptCustomerContract();)
2.  How can i pass data to telrik report in similar way as [((RptCustomerContract)rpt).MinContractYear = cheader.DeliveryBeginDate.Value.Year;]
The telrik reports have been added to the project and Telerik.Reporting is in the reference file of the application.

DataDynamics.ActiveReports.ActiveReport rpt = new RptCustomerContract();
DataDynamics.ActiveReports.ActiveReport rpt2 = new RptCustomerContractLocationDetail();
Telerik.Reporting.UriReportSource Telrpt = new Telerik.Reporting.UriReportSource();
((RptCustomerContract)rpt).MinContractYear = cheader.DeliveryBeginDate.Value.Year;

 

Squall
Top achievements
Rank 1
 answered on 17 Jun 2013
2 answers
544 views
When i run the following code a pdf is created but it will not open.  When i try to open it manually by double clicking on it an error which says that adobe can not open the file because it has been corrupted somehow . . . . . . .
The commented out lines are things that I have tried.
Telerik.Reporting.Report Telrpt = new TelRptContract();
                    Telerik.Reporting.Processing.ReportProcessor TelContractrp = new Telerik.Reporting.Processing.ReportProcessor();
                    System.Collections.Hashtable deviceInfo = new System.Collections.Hashtable();
                    Telerik.Reporting.InstanceReportSource TelContractirs = new Telerik.Reporting.InstanceReportSource();
                    TelContractirs.ReportDocument = Telrpt;
                    Telerik.Reporting.Processing.RenderingResult result = TelContractrp.RenderReport("PDF", TelContractirs, deviceInfo);
                    string fileName2 = result.DocumentName + "." + result.Extension;
                    //string path2 = "c:\\Users\\akinw\\Desktop\\";
                    //string path2 = System.IO.Path.GetTempPath();
                    string path2 = Environment.GetFolderPath(Environment.SpecialFolder.Desktop);
                    string filePath2 = System.IO.Path.Combine(path2, fileName2);
                    FileStream fs = new FileStream(filePath2, FileMode.Create);       
                    fs.Close();
                    //fs = File.Open(filePath2, FileMode.Open);
                    System.IO.File.Open(filePath2, FileMode.Open);
William
Top achievements
Rank 1
 answered on 17 Jun 2013
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?