I am Having a really difficult time with this, it seems like it should be so simple. I wish there were better/more complete examples. It seems a lot of post about this but not a lot of info.

Here is what I am trying to do. I have an aspx page with a report viewer control. I have a simple report built in it's own class that has a SqlDataSource. The SqlDataSorce have one parameter for the record ID. In my aspx page I get a QueryString for the records ID and want to pass it to the SqlDataSource. I have tried both the Report Parameter method and trying to pass straight to the SqlDataSource.

Here is my code in my report that sets the SQL Param:

And Here is what I have on my aspx page:

This is slight different than the examples I saw because I kept getting an error that certain methods were now obsolete.

Every time I open the report it is just blank. I don't know if I need to use the Need_DataSource event or what. Also, do I need some parameter on the report? If I remove the parameter and just have a straight query it work fine. Something is not passing the vale to the SqlDataSource.

A real good example with all of the steps would be great (the video is hard to follow, especially with some of the methods becoming obsolete). I think it would also help a lot of other out.

Thanks,
Craig

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

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.

Hi

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



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

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.......................

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!

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!

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

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

 

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