Hi,
I have a main Report, and i call a sub report.
In the main report the Sub report Size is set to 0.1cm. And it can grow.
This Subreport has:
- Label
- Table with rotate layout
- Label
I did create a report parameter on the SubReport, using the DataSource of the table i want to hide, With value =Count(Fields.Id).
I did that because i wanted to create a conditional formating to hide the table.
But with this try i have "Missing or invalid parameter Value. please input valid data for all parameters." .
I am trying Every solution i can find for this .
I have no more Idea.
I created a report that contains a cell as an indicator (conditional formatting --> new rules --> If .... --> Background --< imagedata). When y try to export the report to excel format. The cell is emplty ?!! (it work when i export the report to pdf).
Any solution ?
Regards,
Having read a number of posts here it does not appear that you can hide columns or rows dynamically. Is there any plans on add this capability?
I have tried
performSubReportTable.Body.Rows[2] = new TableBodyRow(Telerik.Reporting.Drawing.Unit.Inch(0.001));
but neither the Rows or when I change to columns they do not resize.
I have a report that has a few sub-reports and these sub-reports have tables in them. Depending on what account is being printed I want to dynamically show and hide specific columns and rows. As of now it appears my only option is to either create multiple table with each possible combination of rows an columns and then hide and show the appropriate table or create multiple sub-reports with each possible combination of rows an columns and then dynamically hide and show the proper sub- report. It would be much nicer if I could create one sub-report with one table and then conditionally hide and show rows and columns, much like how SQL reporting works.
I recently updated the Telerik.ReportViewer control from 9.0.something to 9.2.15.1126. Since this update I have started noticing that the report-resolver is called multiple times (more than the previous version before) as now our database procedures (that fetch the data for the report) are being hit multiple times - ONLY for the first time a report is run. Subsequent calls only call the data fetch once as before.
I was already aware that the Resolve method is called multiple times, and to stop it getting the data multiple times, I access the view model and check the ReportObject to ensure it is null before going to get the data - (resetting this to null every time user request to run the report). So the first line in my resolver is:
If (viewModel.ReportObject == null)
{
viewModel.ReportObject = FETCHDATA()
}
This would stop the data being fetched multiple times. However, since updating to the 9.2.15.1126, the resolver seems to be hit twice instantly, the code has not had chance to set the ReportObject before resolver is called again.... What has changed? And how do I stop this now? Its putting heavy loads on databases unnecessarily and degrading overall performance of the server.
Could someone shed a light on this situation?
My ObjectDataSource data is flattened as follows (simplified)
Year 1, Item 1, Attribute String {empty}
Year 2, Item 1, Attribute String {empty}
Year 3, Item 1, Attribute String {Some data I want to express as a detail record}
Year 1, Item 2, Attribute String {Some data to display for this detail record}
Year 2, Item 2, Attribute String {empty}
Year 3, Item 2, Attribute String {Some more data to display for this detail record}
Year 1, Item 3, Attribute String {empty}
Year 2, Item 3, Attribute String {empty}
Year 3, Item 3, Attribute String {empty}
I am grouping the data by item name (Item 1, Item 2, Item 3 in this example) and am displaying the item name in the group header. I would like to suppress group headers for items that do not contain any rows with an attribute string (similar to Item 3 in this example.)
I am able to suppress detail rows with empty attribute strings using conditional formatting Field.[Attribute String] = {blank}, Visibility = false.
However, I have not discovered how to suppress the group header. Filtering the group header on Field.[Attribute String] <> {blank}, seems to only test the first detail row (returning only Item 2 in this example.)
Can anyone think of a way to suppress the group header for only Item 3 for the example data above?
Thanks in advance for any assistance you can offer.
I have a Telerik Reporting Table in a report. I am trying to dynamically set the width of first column but it never changes in the report. Is there some sort of update or refresh method that I need to use?
report.calcTable.Body.Columns[0].Width = new Unit(100);
I am now trying to hide hole table dynamicaly but I am having an odd issue
This will not work, none of the table show
var performSubReportTable = performSubReport.Items.Find("table1", true)[0] as Table;
var performSubReportTable2 = performSubReport.Items.Find("table2", true)[0] as Table;
if (show1 == 1)
{
performSubReportTable2.DataSource = performanceDataSet;
performSubReportTable.Visible = false;
}
else
{
performSubReportTable.DataSource = performanceDataSet;
performSubReportTable2.Visible = false;
}
This works for the true but the false the none of the table show
var performSubReportTable = new Table();
if (show1 == 1)
{
performSubReportTable = performSubReport.Items.Find("table1", true)[0] as Table;
}
else
{
performSubReportTable = performSubReport.Items.Find("table2", true)[0] as Table;
}
performSubReportTable.DataSource = performanceDataSet;
performSubReportTable.Visible = true;
but this does work
var performSubReportTable = performSubReport.Items.Find("table1", true)[0] as Table;
var performSubReportTable2 = performSubReport.Items.Find("table2", true)[0] as Table;
performSubReportTable.DataSource = performanceDataSet;
performSubReportTable2.DataSource = performanceDataSet;
if (show1 == 1)
performSubReportTable.Visible = false;
else
performSubReportTable2.Visible = false;
I would prefer if the second method since it is cleaner, but I am not sure why the first two ways wont work.
Then big difference is the first and the third I set the tables to be visible on the report. The second method I set the table visibility to false on the report.