Questions on Reporting Forum

1 answer

158 views

Hiding blank pages caused by some sections being wider than others

I have a crosstab in a grouped report. Because the crosstab width can vary between one and several pages wide depending on the current group value this means that when using Page layout mode or exporting to PDF I get lots of blank pages in the middle because although for most group values the crosstab is only a page or two wide in some groups it can be several pages wide and this is making each group print that wide. The attached image probably explains this better.

Is there a way to dynamically suppress the blank pages and alter the page numbering - basically in the attached screenshot to hide the pages marked with a blue X ? I'm assuming this is going to require code in the report itself.

(If any examples could be in VB rather than C# that would be extra helpful :) )

General Discussions

answered on 11 Aug 2015

1 answer

648 views

Setting a parameter default value while using available values dropdown

I have a report that I want to set parameter available values that a re data bound but I want the report to load using the users ID initially. Then they would be able to select someone else from the dropdown to view their report. It looks like it is one or the other right now. If I set the available values data source the report's needsdatasource event does not fire and nothing is loaded. If I set the parameter available values in the code it will run using the default parameter but the dropdown box does not get displayed in the report.

What am I doing wrong?

General Discussions

answered on 11 Aug 2015

1 answer

212 views

Heatmap?

Has Telerik added support for generating heatmaps in reports?

In this style: http://www.bing.com/images/search?q=heatmap&view=detailv2&qpvt=heatmap&id=550E87DA4D9A5CC0ED803BF3E07F62AD53D858CE&selectedIndex=22&ccid=mrn22%2fyC&simid=608043288174198845&thid=JN.Y0I%2fjxgurmhcTVLcACzQxw

Thanks!

General Discussions

answered on 11 Aug 2015

1 answer

158 views

Crosstab column heading not repeated to next horizontal page

I have a wide crosstab report with a lot of horizontal page breaks as well as vertical page breaks.

I have both the ColumnHeadersPrintOnEveryPage and RowHeadersPrintOnEveryPage settings set to True.

When a column group heading spans a horizontal page break it isn't being repeated on the next page but I'm pretty sure our client will want it to repeat.

In the attached pictures the upper column group heading on "previous page.png" should be repeated in the space marked "XXX" on "next page.png"

General Discussions

answered on 11 Aug 2015

3 answers

221 views

Legend Titles Not Displaying

Hello, I have created a new report/graph using Q3 2014 (8.2.14.1204) on my dev laptop. When I display the report on my production website the graph does not display the legend text. I am hoping there is a setting I can use to force the text to display. Attached is what the report looks like when I run it on my laptop (I purposely redacted part of the text) and what it looks like on the server. Notice the little markers in the middle of each of the legend lines on the No Text image - possibly there is a setting that will force the text to display and hide these markers?

Here is the source XML:

<?xml version="1.0" encoding="utf-8"?><Report Width="9.99996089935303in" Name="Report1" xmlns="http://schemas.telerik.com/reporting/2012/3.7"><DataSources><SqlDataSource ConnectionString="Reporting.Properties.Settings.CompanyName"

SelectCommand="SELECT        DATEPART(yy, Table1.DateChanged) AS Year, DATEPART(mm, Table1.DateChanged) AS Month, UPPER(Table2.Name) AS AP,
                         SUM(Table1.Price - Table1.Discount) AS Price
FROM            Table1 INNER JOIN
                         Table2 ON

Table1.APID = Table2

.EntityID
WHERE        (Table2.Name NOT LIKE '%test%') AND (Table1.APID > 0) AND
                         (Table1.APCustomerName NOT LIKE '%test%')
GROUP BY UPPER(Table2.Name), DATEPART(mm, Table1.DateChanged), DATEPART(yy, Table1.DateChanged)
HAVING        (DATEPART(yy, Table1.DateChanged) = 2015)
ORDER BY Year, Month, AP" Name="CompanyName" /></

DataSources><Items><DetailSection Height="6.94791650772095in" Name="detailSection1"><Items><Graph DataSourceName="CompanyName" Width="5.20000028610229in" Height="3.10000014305115in" Left="0.19999997317791in" Top="0.147916629910469in" Name="graph1"><PlotAreaStyle LineWidth="0in" LineColor="LightGray" /><Axes><GraphAxis Name="graphAxis4"><MajorGridLineStyle LineWidth="1px" LineColor="LightGray" /><MinorGridLineStyle Visible="False" LineWidth="1px" LineColor="LightGray" /><Scale><CategoryScale /></Scale></GraphAxis><GraphAxis Name="graphAxis2"><MajorGridLineStyle LineWidth="1px" LineColor="LightGray" /><MinorGridLineStyle Visible="False" LineWidth="1px" LineColor="LightGray" /><Scale><NumericalScale /></Scale></GraphAxis></Axes><CoordinateSystems><CartesianCoordinateSystem XAxis="graphAxis4" YAxis="graphAxis2" Name="cartesianCoordinateSystem1" /></CoordinateSystems><Style><Padding Left="10px" Right="10px" Top="10px" Bottom="10px" /></Style><SeriesGroups><GraphGroup Name="aPGroup"><Groupings><Grouping Expression="= Fields.AP" /></Groupings><Sortings><Sorting Expression="= Fields.AP" Direction="Asc" /></Sortings></GraphGroup></SeriesGroups><CategoryGroups><GraphGroup Name="monthGroup"><Groupings><Grouping Expression="= Fields.Month" /></Groupings><Sortings><Sorting Expression="= Fields.Month" Direction="Asc" /></Sortings></GraphGroup></CategoryGroups><Series><LineSeries CoordinateSystem="cartesianCoordinateSystem1" CategoryGroup="monthGroup" SeriesGroup="aPGroup" Size="null" MarkerSize="5px" MarkerMinSize="5px" MarkerMaxSize="50px" Y="= Sum(Fields.Price)" DataPointLabel="= Sum(Fields.Price)" Name="lineSeries1"><LineStyle LineWidth="1px" /><DataPointStyle Visible="False" /><DataPointLabelStyle Visible="False" /><LegendItem Value="= Fields.AP" /></LineSeries></Series><Legend><Style LineWidth="0in" LineColor="LightGray" /></Legend><Titles><GraphTitle Text="graph1" Position="TopCenter"><Style LineWidth="0in" LineColor="LightGray" /></GraphTitle></Titles></Graph></Items></DetailSection><PageHeaderSection Height="0.0520833320915699in" Name="pageHeaderSection1" /><PageFooterSection Height="0.0520833320915699in" Name="pageFooterSection1" /></Items><StyleSheet><StyleRule><Style><Padding Left="2pt" Right="2pt" /></Style><Selectors><TypeSelector Type="TextItemBase" /><TypeSelector Type="HtmlTextBox" /></Selectors></StyleRule><StyleRule><Style Color="Black"><BorderStyle Default="Solid" /><BorderColor Default="Black" /><BorderWidth Default="1px" /><Font Name="Tahoma" Size="9pt" /></Style><Selectors><StyleSelector Type="Table" StyleName="Normal.TableNormal" /></Selectors></StyleRule><StyleRule><Style VerticalAlign="Middle"><BorderStyle Default="Solid" /><BorderColor Default="Black" /><BorderWidth Default="1px" /><Font Name="Tahoma" Size="10pt" /></Style><Selectors><DescendantSelector><Selectors><TypeSelector Type="Table" /><StyleSelector Type="ReportItem" StyleName="Normal.TableHeader" /></Selectors></DescendantSelector></Selectors></StyleRule><StyleRule><Style><BorderStyle Default="Solid" /><BorderColor Default="Black" /><BorderWidth Default="1px" /><Font Name="Tahoma" Size="9pt" /></Style><Selectors><DescendantSelector><Selectors><TypeSelector Type="Table" /><StyleSelector Type="ReportItem" StyleName="Normal.TableBody" /></Selectors></DescendantSelector></Selectors></StyleRule></StyleSheet><PageSettings><PageSettings PaperKind="Letter" Landscape="True"><Margins><MarginsU Left="0.5in" Right="0.5in" Top="0.5in" Bottom="0.5in" /></Margins></PageSettings></PageSettings></Report>

General Discussions

answered on 11 Aug 2015

1 answer

75 views

Reporting Fields Bug

I have a report and Sql Query but my report cant read fields.

WITH T AS (SELECT P.PARAMETRE_ADI AS ID,HI.ISTASYON_ADI,HTS.TUR_ID AS TID FROM HALKALAMA_CALISMALARI t JOIN HALKALAMA_TUR_SAYILARI HTS ON HTS.HALKALAMA_CALISMA_ID = T.ID JOIN HALKALAMA_ISTASYONLARI HI ON HI.ID = T.HALKALAMA_ISTASYON_ID JOIN PARAMETRELER P ON P.ID = T.PARAM_HALKALAMA_DONEMI_ID) SELECT ISTASYON_ADI,ILKBAHAR_TUR, ILKBAHAR_BIREY,SONBAHAR_TUR,SONBAHAR_BIREY FROM T PIVOT(COUNT(DISTINCT TID) AS TUR,COUNT(*) AS BIREY FOR ID IN ('İlkbahar' AS ILKBAHAR,'Sonbahar' AS SONBAHAR))

General Discussions

answered on 11 Aug 2015

1 answer

470 views

Fit a table height with a Report/SubReport height.

I have a sub report that contains a table; I want to adjust the height of this table automatically with the height of the sub report knowing that the height of the sub report is dynamic depending on the height of its left adjacent item at the parent report.

Report Designer (standalone)

answered on 11 Aug 2015

2 answers

104 views

Missing drawing in output file

Hi,

I created programmatically the report which includes horizontal lines. I defined them this way:

var shape = new Shape();

shape.Location = new PointU(new Unit(positionX - MARGIN_COLUMN_HORIZONTAL, UnitType.Pixel),

new Unit(DEFAULT_HEIGTH, UnitType.Pixel));

shape.Size = new SizeU(new Unit(widthColumn, UnitType.Pixel),

new Unit(1, UnitType.Pixel));

shape.ShapeType = new LineShape(LineDirection.EW);

shape.Visible = true;

// add to report

headerBoxes.Add(shape);

It works fine and I see all lines in my ReportViewer. But lines are missing if I print or export it. They are visible only on XPS or HTML export. Maybe some other property must be set or is it known bug?

Thank you for answer,

Petr

General Discussions

answered on 10 Aug 2015

1 answer

87 views

Reporting not working in 1 environment

Hello,

We have a asp.net application that contains a few reports that were built with Telerik Reporting for asp.net. We are using the version Q1 2013.

We have 4 environments where our product is hosted (dev,test,pre-prod,prod), and in all 4 it is working fine.

However, we had a customer install our application in their environment, and the reports do not work. The toolbar of the ReportViewer shows up, however it is showing both the disabled and enabled version of each button. And the reports themselves are completely blank. (not rendering)

I have compared the customer's web.config and our web.configs and they are identical. It's not the browser they are using, because they can view the reports in our environment - just not theirs.

Do you have any thoughts about other variables that could cause this? Any ideas on how I could find the source of this behavior?

Any help would be very appreciated.

Justin

General Discussions

answered on 10 Aug 2015

2 answers

812 views

Variable for Holding expression result

Hi,

I need to use an expression result multiple times. Do we have any variable to hold the result of the expression result to be used later?

In my scenario, I am using the expression Sum(Fields.Field1 * Fields.Field2) for four report items(textboxes). I think it will get evaluated for each of the report item( 4 times in my case) which can be time consuming. So I was wondering if there is any option such as a temporary field(like hidden field in ASP.Net) or any alternative variable to hold the expression result and then use it for the next time it is required.

Please suggest !

General Discussions

answered on 10 Aug 2015