Telerik Forums
Reporting Forum
3 answers
88 views
Hello,

In my silverlight application, I have two projects:
GestionJ and GestionJ.Web

In my Home.xaml page of GestionJ, I have a ReportViewer which comes from the toolbox "Telerik Reporting Q3 2011".

For the moment, in design view  it indicates "No report".

The code is:

<my:ReportViewer Name="reportViewer1" Height="220" />



In GestionJ.Web, I have had one file named "ReportService.svc" which contains only one line:

<%

 

@ServiceHost Service="Telerik.Reporting.Service.ReportService, Telerik.Reporting.Service, Version=5.3.11.1116, Culture=neutral, PublicKeyToken=A9D7983DFCC261BE" %>


5.3.11.1116 is the version of Telerik.Reporting.Service.dll in references of GestionJ, I hope this is correct...

In GestionJ.Web, I have added a new Item (a Telerik Report Q3 2011) named ClientsRPT.cs.

I have followed the Wizzard and if I open ClientsRPT.cs[Design] I see all needed fields, and if I click "Preview" or "Html Preview", I see the report with the right data.

My question is how can I link this report  ClientsRPT from GestionJ.Web with the ReportViewer in GestionJ ?





Steve
Telerik team
 answered on 11 Jan 2012
2 answers
214 views
Dear Telerik Team

I am setting a custom background color (e.g. R:15, G:55, B: 147) for textboxes and some table rows. This look fine when rendering the reports within Reportviewer, however, once I export them to Excel they suddenly get slightly different colors (e.g the custom colors get 0, 0, 128 in Excel)

I have tried formatting this within the Report Designer and setting the Background colors programmatically, however, they change each time.

is there a solution to this problem.

Thank you
Mark
Steve
Telerik team
 answered on 11 Jan 2012
2 answers
67 views

I have Create the report and tried to exprot programatially like below, but styles does not seem to be exproted.

TRANS_DELIVERY_REPORT

 

report = new TRANS_DELIVERY_REPORT();

 

Telerik.Reporting.Processing.

ReportProcessor reportProcessor = new Telerik.Reporting.Processing.ReportProcessor();

 

Telerik.Reporting.Processing.

RenderingResult result = reportProcessor.RenderReport("XLS", report, null);

 

 

 

FileStream fs = new FileStream("C:\\report1.xls", FileMode.Create);

 

fs.Write(result.DocumentBytes, 0, result.DocumentBytes.Length);

fs.Flush();

fs.Close();

can any one please let me know what need to be done? thank you.

Steve
Telerik team
 answered on 11 Jan 2012
8 answers
361 views
Hi,
I have a problem in Exporting my Telerik Report to Excel, I have a color of a TextBox should change depend on a binding field, I use the 'ItemDataBound'  event to change the color of the textbox and its work correct BUT when I export my report to PDF the color appear corect the same color I assign to but when I export to Excel the color look different !!!, I use the below syntax to assign the color to the TextBox Style:

CO = (System.Drawing.

Color)ColorTranslator.FromHtml("#a17e9a");

 

 

txtEvent.Style.BackgroundColor = CO;

 

Please help me to find what is the error and why in PDF work right and in Excel not.

Thanks


Steve
Telerik team
 answered on 11 Jan 2012
21 answers
1.5K+ views
Hi all,

I installed Reporting SP1, PageCount problem is solved. But after the installation other problems occured. When I run ReportViewer every textbox gives error message "#ERROR# The expression contains object '####' that is not defined in the current context. ". But the preview of report doesn't give any error. I'm usinf Business objects for datasource. I have a business object and a List class that is filled by that business objects. I try to rebind datasource to report but the result is same. It doesn't make sense that this error is occured after installation of SP1.
Do you have any advice?

Thanks..
Cristian
Top achievements
Rank 1
 answered on 10 Jan 2012
3 answers
87 views
Hi,

I have a customer who has Adobe acrobat pro PDF Printer  ver.  9.4.7  driver installed, so he can, via the print menu ,save the report as PDF.

However the footer comes out strange in the PDF as seen in the attached jpg. To the left of the footer a date should been shown and to right a page nr.(1 in this case not 4)

Using the normal save as pdf in the wpf reportview , the pdf is fine.

How can this problem be solved ?.

Best

Ole
Steve
Telerik team
 answered on 10 Jan 2012
1 answer
131 views
Hi,

I'm using Telerik Reporting Q2 in my application. In this, I'm creating report using the following code and it works fine:


//Code that calls the report designer goes here

ReportProcessor processor =
new ReportProcessor();
RenderingResult result = processor.RenderReport("PDF", report, null);
  
string fileName = "Report" + string.Format("{0:yyyy-MM-dd_hh-mm-ss-tt}", DateTime.Now) + ".pdf";
Response.ContentType = "application/pdf";
Response.AddHeader("Content-Disposition", "attachment; filename=" + fileName);
Response.ClearContent();
Response.OutputStream.Write(result.DocumentBytes, 0, result.DocumentBytes.Length);
Response.End();

Now, I want to add another result in the same report. For that, I did something like this:

byte[] documentBytes = new List<byte>().ToArray();
for(int i=0; i<count; i++)
{
            //Code that calls the report designer goes here
  
            ReportProcessor processor = new ReportProcessor();
            RenderingResult result = processor.RenderReport("PDF", report, null);
        
            documentBytes = documentBytes.Concat(result.DocumentBytes).ToArray();
}
  
string fileName = "Report" + string.Format("{0:yyyy-MM-dd_hh-mm-ss-tt}", DateTime.Now) + ".pdf";
Response.ContentType = "application/pdf";
Response.AddHeader("Content-Disposition", "attachment; filename=" + fileName);
Response.ClearContent();
Response.OutputStream.Write(documentBytes, 0, documentBytes.Length);
Response.End();

But in the resulting PDF, I'm only seeing the final result (I have chart and table inside the report) from the for loop. Does this have a solution? Suppose the for loop have been traversed two times, the resulting PDF should be having chart & table for the first item followed by chart & table for the second item.

Please help asap.
Thanks
Pradeep
Top achievements
Rank 1
 answered on 10 Jan 2012
5 answers
262 views
Hello,

I have created a report with few parameters for filtering the report data. There is one parameter drop-down which needs to be filled as per choice made in the other parameter drop-down. For example, one drop-down is for 'Subject' and the other is for 'AreaOfSubject'. Now I want 'AreaOfSubject' to be filled as per the choice made in Subject drop-down. I am filling both the drop-downs with the business logic.

Would you please suggest the way it can be achieved?

Thanks and regards,
Deepak Saboji
Steve
Telerik team
 answered on 10 Jan 2012
1 answer
94 views

Hi all!

I'm trying to view the datasouce source of theTelerik  Cross Tab example  ie. productSalesDataSet but when i try to configure... so as to view after "Edit in DataSet designer..."

 i get the error below.

 

Failed to open a connection to the database.

"This server version is not supported. You must have Microsoft SQl Server 2005 Beta 2 or later"

Change connection and try again.

 

I have SQL server 2008.

 

Can someone send the the query used in the productSalesDataSet so i can have a look. I think after i've seen it i'llget my crosstab to work

 

thnx so much.

Steve
Telerik team
 answered on 10 Jan 2012
2 answers
186 views
I'm trying to print a 4-detail per page report in a special paper (139mm x 304mm).

First it was working trying it using native printing but it was a problem when I tried to print it in a network printer it was HUGE (every page was more than 165MB) and it was very slow. I solutioned this with this thread:
http://www.telerik.com/community/forums/preview-thread/reporting/telerik-reporting/printing-problem-with-reportviewer-in-silverlight.aspx 

But now I'm having problems with margins. I setup the page with no margin and it is the same size than the page... but it leaves top, left, right and bottom margins...

I don't know what to do... any suggestion?
Fernando
Top achievements
Rank 1
 answered on 10 Jan 2012
Top users last month
Rob
Top achievements
Rank 3
Bronze
Bronze
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?