Hi,
We design reports using telerik standalone designer using sql data-sources. One our requirement is to generate Bio-data report for employees in the company, which displays their pictures in a picturebox. The Picturebox values (absolute URL) is set from field values. The employees pictures are usually stored in a folder with their Id, so it is an assumption that their image file path is valid. However if the file path is invalid or image file is missing, the report shows an error like 'Invalid image data, could not find a part of the path'. i Would like to show blank picture box in case image is missing or folder is missing. How can i achieve this using report designer.
I know that I can output reports to separate Excel tabs using a Report Book, but that's not a good solution when data dynamically determines how many tabs your report should output. For example, I have an invoice report that outputs in the following group hierarchy.
[1] Invoice Summary (new tab)
[1 to Many] Facility/Department
Summary (new tab)
Detail (new tab)
Ideally, there would be a report property to export Excel in a mode similar to the Web output, where only explicit page breaks result in new tabs. I cannot believe that isn't a more common request. My clients constantly want summary data paired with detail data. If they said data is in the same Excel tab, converting the detail data to a table, de-merges and re-sizes all the columns, which is a difficult to use, ugly mess.
I have a report with a stored procedure for a datasource, returning 196 rows, which contain current month and YTD sums of database fields. I want to generate a column graph that displays 6 of these sum fields for all 196 rows. Is it possible to display the sum aggregate function result of a field as a column in the graph? For instance, Column1 would be the name of a field in my datasource. I want to display the sum of all 196 Column1 fields as a column in the graph. I have each of the 6 columns as GraphGroups and as BarSeries objects. I think it's trying to graph values from every row, but I only want one entry, the sum. This is my first Telerik report and graph. Any help would be appreciated.
//
// graphMonthGrandTotals
//
graphGroup1.Name = "categoryGroup";
this.graphMonthGrandTotals.CategoryGroups.Add(graphGroup1);
this.graphMonthGrandTotals.CoordinateSystems.Add(this.cartesianCoordinateSystem1);
this.graphMonthGrandTotals.DataSource = this.sqlDataSource;
this.graphMonthGrandTotals.Legend.Style.LineColor = System.Drawing.Color.LightGray;
this.graphMonthGrandTotals.Legend.Style.LineWidth = Telerik.Reporting.Drawing.Unit.Inch(0D);
this.graphMonthGrandTotals.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.60000002384185791D), Telerik.Reporting.Drawing.Unit.Inch(1.4659316539764404D));
this.graphMonthGrandTotals.Name = "graphMonthGrandTotals";
this.graphMonthGrandTotals.PlotAreaStyle.LineColor = System.Drawing.Color.LightGray;
this.graphMonthGrandTotals.PlotAreaStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Inch(0D);
this.graphMonthGrandTotals.Series.Add(this.barSeries1);
this.graphMonthGrandTotals.Series.Add(this.barSeries2);
this.graphMonthGrandTotals.Series.Add(this.barSeries3);
this.graphMonthGrandTotals.Series.Add(this.barSeries4);
this.graphMonthGrandTotals.Series.Add(this.barSeries5);
this.graphMonthGrandTotals.Series.Add(this.barSeries6);
graphGroup7.ChildGroups.Add(graphGroup2);
graphGroup7.Groupings.Add(new Telerik.Reporting.Grouping("= Fields.Column1"));
graphGroup7.Name = "column1Group";
graphGroup7.Sortings.Add(new Telerik.Reporting.Sorting("= Fields.Column1", Telerik.Reporting.SortDirection.Asc));
graphGroup6.ChildGroups.Add(graphGroup7);
graphGroup6.Groupings.Add(new Telerik.Reporting.Grouping("= Fields.Column2"));
graphGroup6.Name = "column2Group";
graphGroup6.Sortings.Add(new Telerik.Reporting.Sorting("= Fields.Column2", Telerik.Reporting.SortDirection.Asc));
graphGroup5.ChildGroups.Add(graphGroup6);
graphGroup5.Groupings.Add(new Telerik.Reporting.Grouping("= Fields.Column3"));
graphGroup5.Name = "column3Group";
graphGroup5.Sortings.Add(new Telerik.Reporting.Sorting("= Fields.Column3", Telerik.Reporting.SortDirection.Asc));
graphGroup4.ChildGroups.Add(graphGroup5);
graphGroup4.Groupings.Add(new Telerik.Reporting.Grouping("= Fields.Column4"));
graphGroup4.Name = "column4Group";
graphGroup4.Sortings.Add(new Telerik.Reporting.Sorting("= Fields.Column4", Telerik.Reporting.SortDirection.Asc));
graphGroup3.ChildGroups.Add(graphGroup4);
graphGroup3.Groupings.Add(new Telerik.Reporting.Grouping("= Fields.Column5"));
graphGroup3.Name = "column5Group";
graphGroup3.Sortings.Add(new Telerik.Reporting.Sorting("= Fields.Column5", Telerik.Reporting.SortDirection.Asc));
this.graphMonthGrandTotals.SeriesGroups.Add(graphGroup3);
this.graphMonthGrandTotals.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(4.9000000953674316D), Telerik.Reporting.Drawing.Unit.Inch(2.5250000953674316D));
graphTitle1.Position = Telerik.Reporting.GraphItemPosition.TopCenter;
graphTitle1.Style.LineColor = System.Drawing.Color.LightGray;
graphTitle1.Style.LineWidth = Telerik.Reporting.Drawing.Unit.Inch(0D);
graphTitle1.Text = "Showing Month Grand Totals";
this.graphMonthGrandTotals.Titles.Add(graphTitle1);
this.barSeries1.CategoryGroup = graphGroup1;
this.barSeries1.CoordinateSystem = this.cartesianCoordinateSystem1;
this.barSeries1.DataPointLabel = "Column1";
this.barSeries1.DataPointLabelStyle.Visible = false;
this.barSeries1.DataPointStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Inch(0D);
this.barSeries1.DataPointStyle.Visible = true;
this.barSeries1.LegendItem.Value = "Column1";
this.barSeries1.Name = "barSeries1";
this.barSeries1.SeriesGroup = graphGroup2;
this.barSeries1.Y = "= Sum(Fields.Column1)";
I'm trying to create a calendar report that makes use of 31 daily sub reports to display a line chart for each day of the month.
The issue I'm having is that to the bottom and left of the sub reports there is a half centimeter gap that I just can't get rid of; I assume it's space that's being reserved for the axis labels/scales (which I'm not displaying). The chart conforms to the very edge of the sub report at the top/right, but I can't get the bottom/left to behave the same.
Is there any way to get rid of that gap? I've scoured the report XML for references to padding or margins and set any I found to zero, and I've also set the axis scales/labels to not visible, but to no avail. I've attached an image in case my explanation isn't clear.