Questions on Reporting Forum

2 answers

194 views

Hi

I need to show sum of the values appeared in a column of the table for each page. Means if I have total 10 records in the column 'Price' of the table and 6 of them appear on the first page of the report. Then I need to show the sum of those 6 prices on first page(not total of all the 10 items) and sum of the remaining 4 items on the second page.

Please suggest.

General Discussions

answered on 12 Aug 2015

1 answer

216 views

Why Telerik web reporting is sending multiple request?

I'm using Telerik Reporting with MVC, but I had an Issue with the requests count sent when the report is rendering, as u can see in the screenshot there is at leat 5-6 request sent, is there is any way so I can make the Whole report one request ?

General Discussions

answered on 11 Aug 2015

1 answer

99 views

Extended Y axis

Is there a way to do the extended y-axis in Q3 2013 7.2.13.1016? (So columns are not to top of plot area)

General Discussions

answered on 11 Aug 2015

4 answers

599 views

Report Page Border

Is it possible to add a border around each page of a report. I tried placing a border around the Report section which shows up in the viewer, but when exported to pdf or printed it does not display?

General Discussions

answered on 11 Aug 2015

1 answer

177 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

694 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

247 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

188 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

244 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

88 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