Telerik Forums
Reporting Forum
1 answer
374 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
304 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
70 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
491 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
3.0K+ 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
113 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
148 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
384 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
186 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
2 answers
222 views

Followed the advice form this link below but still no luck
http://www.telerik.com/community/forums/reporting/telerik-reporting/how-do-you-programmatically-bind-subreports-in-q2-2012.aspx

Telerik.Reporting.SubReport mySubReport = (Telerik.Reporting.SubReport)oReport.Items.Find("MySubReport", true)[0];

//*** This is working
// this code block loads the data in sub report in this case if i set the subreport as an object Instance

var repSource = (InstanceReportSource)mySubReport.ReportSource;
var subreport = (Telerik.Reporting.Report)repSource.ReportDocument;
var odsItems = (Telerik.Reporting.ObjectDataSource)subreport.DataSource;
subreport.DataSource = objectDataSource;

//*** End

//*** This is not working
// this code block doesn't load the data in sub report in this case if i set the subreport as an XML Source (serialized report using ReportXmlSerializer)
var repSource = (XmlReportSource)kpiActionsSubReport.ReportSource;
Report subreport = TelerikReportHelper.DeSerilizeTelerikReportXML(XElement.Parse(repSource.Xml)); //(deserialized report using ReportXmlSerializer)
subreport.DataSource = objectDataSource;
//*** End

John North
Top achievements
Rank 1
 answered on 27 Oct 2012
Top users last month
Miljana
Top achievements
Rank 2
Iron
Iron
Joel
Top achievements
Rank 3
Bronze
Bronze
Bronze
Cynthia
Top achievements
Rank 1
John
Top achievements
Rank 1
Iron
Mozart
Top achievements
Rank 1
Iron
Veteran
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?