Hello,

I have a table that runs across multiple page in a report. What I would like to have is:
- at the beginning of the report, add a special row with an initial value.
- at the end of each page, when the table continues to the next page, have a total row of the items at this position.
- at the beginning of each page, when not at the start of the table, have a repetition of the total row of the previous page.
- at the end of the table, have a special total row, that is not the same as the total row for each page.

How can I do this with Telerik Resporting?

I am having an extremely difficult time doing a simple task. I need to create a text box that contains both text and a decimal from my database. I want to add formatting to the decimal to remove all trailing zeros (not round, I want the full number displayed just not trailing zeros). Below is my current textbox value and the result;
='Acreage:  '+ Fields.AssignmentAcres
Acreage:  640.000000000000000000
I've tried every iteration I can think of with the format function to no avail. Below is what I assume the textbox should look like but I keep receiving errors.
='Acreage:  '+Format(Fields.AssignmentAcres, '####################.######################')
I've tried with single quotes, double quotes, no quotes, I even tried the formatting '0000.0000....'. No matter what I keep receiving errors. Please keep in mind that I am not a developer, I do not know coding very well. I've seen several answers googling this that requires quite a bit of code and I have no idea where to even put that code. I am using the "Edit Expression" dialog box to enter my field values. Thanks

Hi all,

New user here (long term crystal user...so be nice please).

 I am attempting to create a cross tab report and I am noticing a couple of things. First some background.

Local install of Microsoft SQL 2014.

Query in SQL runs in under 1 sec returning 5707 records.

Telerik is Q3 2015.

If I just put the fields on the report (no crosstab), the report is rendered in ~ 3 seconds (takes a few more seconds to get to 600 pages).

I remove all the data fields and start the CrossTab wizard. I have my Customers in as the rows, Year as the columns (limited to just 2015 via the SQL query) and the sales amounts in my summary field.

 Here are my issues:

1. I have sat for 30 minutes and it never displayed a preview.

2. I run an SQL trace and see the exact same query hitting my server every few seconds. That query is the same query I used to build the report.

 I am assuming as a new user to the system I have done something horribly wrong.

I'm kind of new into the usage of the Telerik Platform and I haven't found any information about the usage of the Report Viewer on mobile environments. I currently have a development that I upgraded to 2015 version of the Reporting and I want to know if there is a way to know if the version is compatible with smartphones/tablets.     

Good morning,
I was trying the trial version of Telerik Reporting and noticed a problem:
Unable to create the directory store. (Exception from HRESULT: 0x80131468)
Description: An unhandled exception occurred During the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.IO.IsolatedStorage.IsolatedStorageException: Unable to create the directory store. (Exception from HRESULT: 0x80131468)
On my site I have a shared hosting there are no write permissions in the temp folder as my provider does not allow to have these permits.
I therefore ask you, you can change this parameter in IsolatedStorageFile.Get MachineStoreFor Assembly () par accessible directory / writable on shared hosting?

In landscape mode for report  their is a table which contain more than 50 column and the table is used in list for repeating table . But the problem is when i increase width of table more than page size as their are many column for readability of user ,in interactive view all table are shown properly but in print preview some of table are not visible when they are paginated and while printing also they are not visible .pls reply asap .

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.

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.