Questions on Reporting Forum

5 answers

493 views

Error: The OVER SQL construct or statement is not supported

I've built a report based on a query which does have the OVER statement in it. When I originally used the wizard to build this report, it worked great. I then went back into my .xsd file to "Configure..." this query, and all of a sudden I'm getting this error. I've been working with this report for a day now (successfully; giving me my desired results), but I can't edit it? Anyone have any suggestions aside from starting from scratch again (I have it looking the way I want, but I just need to change one line of code in my where statement)??

General Discussions

answered on 13 Aug 2010

1 answer

157 views

report top margin printed size issue

I have a report with a requirement of .675in for the top margin and .275 in for the other margins. I have the snapgrid set to .05inches. I have a report that I'm printing I'm having a problem with the top margin when I'm printed out the report. I am trying to match a report that was previously generated in another vendor program. The left margin is matches the old report but the top margin is wider by about a 1/16 of an inch. which pushes everything down on the page.

Are there any issues with my diminsions? When I look in the InitializeComponent the margins have the correct values.

Thanks,
Robert

General Discussions

answered on 13 Aug 2010

1 answer

275 views

Extra pages when generating PDF report

Hello,

Does anybody know how to get rid of the extra blank pages that occurs when you generate a PDF report? Ive been trying to figure out how to keep the document a single page document. It generates the page header and page footer twice even though it is only a 1 page document. Thank you for the help in advance.

Thanks,

john

General Discussions

answered on 13 Aug 2010

2 answers

290 views

ReportViewer window is not resizing

Can some explain why my ReportViewer Height is not changing according the heigt of my RadWindow?

When I change the horizontal size the reportviewer changes as it should be. When I change my vertical heigt then it doesn't change?

Header="Report window" WindowStartupLocation="CenterScreen" Top="-5" Width="550" Height="539" ResizeMode="CanResize">

<Grid x:Name="LayoutRoot" VerticalAlignment="Stretch">

<Grid.RowDefinitions>

<RowDefinition Height="*"/>

<RowDefinition Height="27"/>

</Grid.RowDefinitions>

<Telerik_ReportViewer_Silverlight:ReportViewer x:Name="ReportViewer" HorizontalAlignment="Stretch" VerticalContentAlignment="Stretch" Height="475" Grid.Row="0" ReportServerUri="../ReportService.svc"

Report="GaSuiteReportLib.EmergencyReport, GaSuiteReportLib, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null" ZoomPercent="80" VerticalAlignment="Top"/>

<Button x:Name="OKButton" Grid.Row="1" Content="OK" Click="OKButton_Click" Width="75" Height="23" HorizontalAlignment="Right" VerticalAlignment="Bottom" Margin="0,0,0,3"/>

</Grid>

For some reason the ReportViewer height of 475 stays. I have also changed this into * etc. but that won't help me?

General Discussions

answered on 13 Aug 2010

2 answers

156 views

Silverlight Report Viewer

Hello,

is it possible to add custom buttons to the toolbar to execute custom commands (eg. close ReportVewer)?
I saw that the viewer has some styles included. How can I create my one style?

Thanks,
Manuel

General Discussions

answered on 13 Aug 2010

1 answer

93 views

Problem is displaying data in StackedSpline chart

Hi,
I have created a report with StackedSpline chart. The report should display the chart for each device with its parameter values(Y-Axis) vs DateTime(X-Axis). Following the code snippet of the report.

namespace Reports

{

using System;

using System.ComponentModel;

using System.Drawing;

using System.Windows.Forms;

using Telerik.Reporting;

using Telerik.Reporting.Drawing;

/// <summary>

/// Summary description for Report2.

/// </summary>

public partial class Report2 : Telerik.Reporting.Report

{

public Report2()

{

/// <summary>

/// Required for telerik Reporting designer support

/// </summary>

InitializeComponent();

//

// TODO: Add any constructor code after InitializeComponent call

//

this.reportTableAdapter1.Fill(this.temp1.report);

}

private void chart1_NeedDataSource(object sender, EventArgs e)

{

Telerik.Reporting.Processing.Chart procChart = (Telerik.Reporting.Processing.Chart)sender;

procChart.DataSource = this.temp1;

chart1.Series[0].DataYColumn = "ParamValue";

chart1.PlotArea.XAxis.DataLabelsColumn = "timeDate";

chart1.PlotArea.XAxis.Appearance.LabelAppearance.RotationAngle = 300;

chart1.PlotArea.Appearance.Dimensions.Margins.Bottom = Telerik.Reporting.Charting.Styles.Unit.Percentage(30);

chart1.PlotArea.Appearance.Dimensions.Margins.Right = Telerik.Reporting.Charting.Styles.Unit.Percentage(30);

}

The chart is plotting the values in one line for all the parameters. But I want to display the parameter values in different line for each parameter name.

My database table looks like this,

DateTimeStamp	Parameter_Name	ParamValue	DeviceID
7:03:58 PM	PM_PH_A_ABC	125	129
7:03:59 PM	PM_PH_A_ABC	125	129
7:04:00 PM	PM_PH_A_ABC	25	129
7:04:01 PM	PM_PH_A_ABC	125	129
7:03:58 PM	PM_XYZ	125	129
7:03:59 PM	PM_XYZ	125	129
7:04:00 PM	PM_XYZ	5	129
7:04:01 PM	PM_XYZ	50	129
7:03:58 PM	PM_PH_A_ABC	100	133
7:03:59 PM	PM_PH_A_ABC	25	133
7:04:00 PM	PM_PH_A_ABC	8	133
7:03:58 PM	PM_XYZ	125	133
7:03:59 PM	PM_XYZ	15	133
7:04:00 PM	PM_XYZ	7	133

From the above table I need to show two lines(PM_PH_A_ABC, PM_XYZ) in the graph.

In my report I am getting one line for the two parameters. Please refer the attached output of my report

Can anyone please help me how to plot lines for each parameters(the parameters are dynamic) in the StackedSpline chart.

Thanks in advance.

Regards,
Manoj

General Discussions

answered on 13 Aug 2010

1 answer

147 views

toolbar is not rendering all items

Dear All,

I am using telerik report in mvc 2.0,I am getting report but report toolbar is not clear.

General Discussions

answered on 13 Aug 2010

1 answer

123 views

Drill Down Link in Group Footer

I have a report with two groups. In this report, only the lower-level group footer is displayed, detail lines and the higher-level group footer lines are hidden. In the footer that is displayed is a link to another report with the field values from the group footer used as parameters to the other report. Although I am using the Last() aggregate function on both the fields displayed on the group footer and in the report parameters of the link, one of the parameter values I am passing is getting lost when it gets to the routine specified in the other report's data source even though it is displayed correctly in the footer itself.

Does anyone have any suggestions?

Thanks,

Lee Sauer

General Discussions

answered on 12 Aug 2010

5 answers

405 views

Styling report parameters section

Is it possible to style report parameters section.

I want to put some labels on there and plus change backgroud of dropdown lists ,also to play with the width and height of parameters entry textbox/dropdownlist ?

Thanks in advance

Regards

General Discussions

answered on 12 Aug 2010

0 answers

108 views

Sample code required

Hi,
I need sample code for a chart report, which should have multiple series (Line chart).

Example the Employee sales summary report in "On line Example".
The report data should bind from the database table. Y-Axis should be some range of data(any datatype) and X-Axis should be date/time range.

Thanks,

Regards,
Manoj

General Discussions

asked on 12 Aug 2010