Telerik Forums
Reporting Forum
2 answers
486 views
Hello,

I have created a simple report using the standalone report designer.
This report is saved as a .trdx file and located in the same folder as my binaries (I initially wanted it to be in a subfolder, but go the same error)

here is my code to generate  a pdf file:

UriReportSource report = new UriReportSource();
report.Uri = "KiwixInterventionSheetActions.trdx";
            
report.Parameters.Add(new Telerik.Reporting.Parameter("CustomerId", customer_id));
            
ReportProcessor reportProcessor = new ReportProcessor();
File.WriteAllBytes(target_filename, reportProcessor.RenderReport("PDF", report, null).DocumentBytes);

When I do the RenderReport, I get the exception message: "Invalid URI: The format of the URI could not be determined."
If I use a different file name, I get another exception saying that the file cannot be found, so this means that the Uri is correctly interpreted at some stage.

If I use a XmLReportSource instead and fill the Xml field from the content of the file by using following code:

XmlReportSource report = new XmlReportSource();
report.Xml = File.ReadAllText("KiwixInterventionSheetActions.trdx");

then it works, but I need to be able to support UriReportSource, because my final application uses sub-reports specified as files. Whne using the XmlReportSource, the main report works, but the pdf contains identical error message for the sub reports.

Thanks in advance

Fred
Frederic
Top achievements
Rank 1
 answered on 30 Oct 2012
1 answer
337 views
Is it possible to customize an ASP.NET (C#) report to hide one or two columns at runtime depending on the presence of a column in the datasource, or any other way? Ideally we would pass in a DataTable to the report without certain columns, or use a flag to determine whether or not to show the column.
IvanY
Telerik team
 answered on 30 Oct 2012
1 answer
280 views
Hi

I'm using Telerik Reporting Q1 2012. I want to render the following html code in an HtmlTextBox:

<span style="font-family: 'pluto light';">Test</span>


Unfortunately, the text is in Microsoft Sans Serif and not in Pluto Light. I think there is a problem, because the font has a space. With fonts like Verdana it works fine.

Do you have any hint for me?

Thanks,
Chris
IvanY
Telerik team
 answered on 30 Oct 2012
1 answer
57 views
hay guys
how to create report without wizard
this project have design but show report with calling query string in it
note: query string do not writed in desigin writ in code editor
tanks.......................
IvanY
Telerik team
 answered on 30 Oct 2012
1 answer
460 views
Hi,

I've seen this thread here: - http://www.telerik.com/community/forums/reporting/telerik-reporting/how-to-allow-dynamic-grouping-selections-paramters-in-a-report.aspx as well as the example reports.

This enables me to apply dynamic grouping in my report by setting the grouping value to "=IIF(Parameters.GroupBy.Value is null,"",Fields(Parameters.GroupBy.Value))", which is working fine.

However, I want to place a table control inside of the group and obviously filter based on the group that it's in.

I've set the table binding to "DataSource=ReportItem.DataObject", but what would the syntax of the filter be because I can't declare the actual field name in the "ReportItem.Parent.DataObject.FieldNameHere" part as it's dynamic?

I've tried various variations of the below in the filter setting of the table, but without success.

=IIF(Parameters.GroupBy.Value is null,"",Fields(Parameters.GroupBy.Value)) = =ReportItem.Parent.DataObject.(Parameters.GroupBy.Value)

Many thanks!
IvanY
Telerik team
 answered on 29 Oct 2012
15 answers
2.8K+ views
Hello!

I'm playing around with the standalone designer and find the DataSource handling not really practical:

First, when you create a DataSource, the Wizard offers to save it in the application configuration file, which is of course read-only if the desinger is installed somewhere under Program Files. Instead the standalone Designer should store this information in a per-user configuration.

My scenario is to call the reports from my application, where the connection string changes depending on user input in a database connection dialog.
In this case the handling of the different DataSource objects in the report items and subreports etc. is rather tedious.
So far, I have to recursively find all Data Items in the report/subreports and change the connection string. This works as long as all items really use the same connection.

The proposed workaround with defining a report parameter and using binding requires a lot of discipline from the designer, OK for a programmer but not really practical for "Powerusers".

I would like to be able to define connections separately from sql statements (multiple DataSource objects using the same logical connection object)  and have these connections easily accessible in the designer UI and the API.

Am I missing something?

Regards
Erwin

BTW: really looking forward to being able to drop crystal report support from my application, as soon as the designer gets a bit more friendly for end users. Keep on with the great work!
Peter
Telerik team
 answered on 29 Oct 2012
4 answers
89 views
Hello,

I am using Telerik Reporting Q1 2012 (6.0.12.215).  I have a main report whose datasource is an object that returns a <List> collection. I also have two other fields in the report header that are set when the report is instantiated, these textboxes are set with parameters from my Winform application.  Also on this main report is a field that allows us to drill through to another report. When the field is clicked the drill through report opens fine however when I go back to the main report the value of the fields in the report header are gone however the datasource still maintains it result set.

How can I ensure that the values in the textboxes remain after I return to the main report...as it looks like their values are lost when navigating to the drill through report.

Thanks,

Kerry
Kerry
Top achievements
Rank 1
 answered on 29 Oct 2012
1 answer
127 views
I have a master reports with two sub reports.  Each sub report provides the sum of an item contained in different databases.  I need to be able to add these two sums together in the master report, but cannot figure out how to access the values in the sub reports to do the calculation.

Can someone tell me how I can add these two values together and display it in the master report?  If anyone has a code sample of how to do this I would really appreciate it.

Thanks

 
IvanY
Telerik team
 answered on 29 Oct 2012
2 answers
362 views
Hi,

   I am working in Telerik Reporting. I am using the Cross Tab Wizard to load the reports. It contains two columns in rowgroups and 3 columns in details section. My scenario is to add the columns dynamically based on the dropdown value. For ex. I have 4 column names in dropdown with multiple checkbox. If the user selects 1 column I need to display rowgroups columns with the selected column. I need to add the columns in Cross Tab Wizard dynamically based on the number of columns selected in dropdown. Is that possible to create the columns dynamically in Cross Tab Wizard based on the condition?. If it is possible please provide me the source code.

       Please reply me asap as i need to complete my task in urgent basis.



Thanks
Jegan S
Peter
Telerik team
 answered on 29 Oct 2012
1 answer
160 views
I have a page with a report viewer Version=6.1.12.820, I load a trdx to it, it displays fine, but when I generate a PDF from it and try to view it, I get the following:

Files does not begin with %PDF-

Seems the PDF is corrupt for some reason?
IvanY
Telerik team
 answered on 29 Oct 2012
Top users last month
Rob
Top achievements
Rank 3
Bronze
Iron
Iron
Sergii
Top achievements
Rank 1
Iron
Iron
Missing User
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?