Questions on Reporting Forum

3 answers

260 views

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

93 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

535 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

125 views

[Solved] 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

119 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

874 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

1 answer

290 views

Crosstab group column widths with multiple column groups

I have a crosstab report with 2 levels of column groups.

The child group column just has a numbered heading and needs be narrow, but sometimes the parent group only has one child group and that is making the overall column much too narrow to display the parent group heading legibly.

Is there some way of specifying a minimum width for the textbox in the parent group heading?

I'm trying to achieve something similar to the first attached image where the 3rd group is still wide enough to display the group name. What I'm currently getting is the third group being really narrow and forcing the group name to wrap onto multiple lines similar to the second attached image.

I can't just make the child group columns wider because that will make the report too awkward to print.

General Discussions

answered on 10 Aug 2015

6 answers

492 views

Grouping by parameters

Hello I currently have a multivalue parameter 'username' and a crosstab which displays information based on the usernames selected in the parameter dropdown. Currently if I select multiple usernames the data will be added together in the one crosstab. What i'd like is to have a separate crosstba for each of the usernames selected. Is this possible? In SSRS I would just add to a listbox and group by username, I have tried adding the crosstab to a listbox in telerik and group the list by username but it doesnt work. Would be grateful of any advice in he right direction.

Thanks

Report Designer (standalone)

answered on 07 Aug 2015

1 answer

75 views

y-axis 0 based

We are still using Q3 2013 7.2.13.1016

How do I set the y-axis to always start at 0?

General Discussions

answered on 07 Aug 2015

9 answers

763 views

Navigating with parameters

I want to navigate from column of the report to other page with a parameter with field value (eg. =Fields.ProjAdvName) and also want a popup window rather than tab on next page as I redirect to other page with the column click. I searched it and tried it but didn't work sorry if my search is inadequate

Please help: While opening other aspx page, i need to pass parameter in url. This parameter name = value should come from column of telerik report.

General Discussions

answered on 06 Aug 2015