Questions on Reporting Forum

6 answers

386 views

How can I enter a GUID in the parameter values editor? I've tried
{F1F613B9-1D64-40E9-B437-A837F0B1BC6D}
'F1F613B9-1D64-40E9-B437-A837F0B1BC6D'
"F1F613B9-1D64-40E9-B437-A837F0B1BC6D"
'{F1F613B9-1D64-40E9-B437-A837F0B1BC6D}'
"{F1F613B9-1D64-40E9-B437-A837F0B1BC6D}"

General Discussions

answered on 07 Feb 2013

3 answers

2.3K+ views

How to remove BOM characters "ï»¿" from CSV file generated by ReportViewer export to CSV file

I am using Telerik Reporting version 6.1.12.820, Runtime version: v2.0.50727

I use ReportViewer to render the reports. If I export to CSV files when the report is empty, I noticed there are BOM characters "ï»¿" at the beginning of the file.

How can I remove it?

I searched the forum and found some post in Telerick Radgrid

http://www.telerik.com/community/forums/aspnet-ajax/grid/exporting-without-bom.aspx#1474434

But for ReportViewer, there is no such event handler.

Can you help?

Thanks

General Discussions

answered on 07 Feb 2013

1 answer

544 views

Data shows in Report Designer Preview but does not in Web Viewer

Overview: I am using Reporting Q1 2012 and Visual Studio 2010. I have built a very simple aspx page which contains the Q1 2012 Report Viewer control. In the code behind, I am binding the ReportViewer.Report to a deserialized instance of a .trdx file that was created using the Q1 2012 Report Designer. I have SQL Server Express 2008 R2 as the data source for the SQLDataSource defined in the report.

Problem: When I view the report (.trdx) in the Report Preview of the Report Designer, the expected data populates correctly. When I run the web application and attempts to view the report using the ReportViewer control a blank page is displayed after the "Generating Report.." message disappears. Print Preview mode of the ReportViewer yields the same results. Printing and exporting to any format generates a single blank page.

Details:

I have followed the official documentation for deserializing the report file and binding it to the viewer.
The report has no parameters and is a simple "Select * From [Table]" select command.
The [Table] has only three columns.
The SQLDataSource connection string is NOT being stored in a configuration setting.
I have stepped through the code line by line to verify that the deserialized Report object connection strings are pointing at the correct server and database with appropriate access.

Code:
viewer.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="viewer.aspx.cs" Inherits="Panda.Web.App.Reports.Repository.Viewer" %>

<%@ Register Assembly="Telerik.ReportViewer.WebForms, Version=6.0.12.215, Culture=neutral, PublicKeyToken=a9d7983dfcc261be"

Namespace="Telerik.ReportViewer.WebForms" TagPrefix="telerik" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head runat="server">

<title></title>

<link type="text/css" rel="stylesheet" href="~/Styles/reset.css" />

<style type="text/css">

html#html, body#body, form#form1, div#content

{

height: 100%;

}

</style>

</head>

<body id="body">

<form id="form1" runat="server">

<div id="content">

<telerik:reportviewer Id="ReportViewer1" runat="server" Width="100%"

Height="790px" ShowDocumentMapButton="False" ShowHistoryButtons="False"

ShowPrintPreviewButton="False" Skin="WebBlue" ViewMode="PrintPreview"

ZoomPercent="50"></telerik:reportviewer>

</div>

</form>

</body>

</html>

viewer.aspx.cs

var reportDefinitionFile = Server.MapPath("~/app/reports/repository/rpt/" + _reportPath);

using (System.Xml.XmlReader xmlReader = System.Xml.XmlReader.Create(reportDefinitionFile))

{

System.Xml.Serialization.XmlSerializer xmlSerializer = new System.Xml.Serialization.XmlSerializer(typeof(Telerik.Reporting.Report));

Telerik.Reporting.Report reportDocument = (Telerik.Reporting.Report)xmlSerializer.Deserialize(xmlReader);

var conn = WebConfigurationManager.ConnectionStrings["Panda.Data.ConnectionString"];

if (conn == null)

{

conn = WebConfigurationManager.ConnectionStrings["Panda.Data." + Environment.MachineName + ".ConnectionString"];

}

var connString = conn.ConnectionString;

// Set Report datasource connections for report, parameters and all other objects

var sds = (Telerik.Reporting.SqlDataSource)reportDocument.DataSource;

sds.ConnectionString = connString;

// parameters

foreach (var obj in reportDocument.ReportParameters)

{

if (obj.AvailableValues.DataSource != null)

{

var ds = (Telerik.Reporting.SqlDataSource)obj.AvailableValues.DataSource;

ds.ConnectionString = connString;

}

////// other report objects

//SetConnectionStrings(reportDocument.Items, connString);

ReportViewer1.Report = reportDocument;

ReportViewer1.DataBind();

ReportViewer1.RefreshReport();

}



Settings.trdx


<?xml version="1.0" encoding="utf-8"?>
<Report Width="10.45833333in" DocumentName="Panda Settings|List of global properties" Name="Settings">
  <DataSources>
    <SqlDataSource ConnectionString="Server=***\***;Database=***;uid=***;pwd=****;" SelectCommand="Select * from PandaSetting" Name="Panda" />
  </DataSources>
  <PageSettings PaperKind="Letter" Landscape="True">
    <Margins Left="0.25in" Right="0.25in" Top="0.25in" Bottom="0.25in" />
  </PageSettings>
  <DataSourceRef>Panda</DataSourceRef>
  <StyleSheet>
    <StyleRule>
      <Style BackgroundColor="" Color="28, 58, 112">
        <Font Name="Tahoma" Size="18pt" Style="Regular" />
      </Style>
      <Selectors>
        <StyleSelector>
          <Type>ReportItemBase</Type>
          <StyleName>Title</StyleName>
        </StyleSelector>
      </Selectors>
    </StyleRule>
    <StyleRule>
      <Style BackgroundColor="28, 58, 112" Color="White" VerticalAlign="Middle">
        <Font Name="Tahoma" Size="11pt" Style="Bold" />
      </Style>
      <Selectors>
        <StyleSelector>
          <Type>ReportItemBase</Type>
          <StyleName>Caption</StyleName>
        </StyleSelector>
      </Selectors>
    </StyleRule>
    <StyleRule>
      <Style Color="Black" VerticalAlign="Middle">
        <Font Name="Tahoma" Size="10pt" Style="Regular" />
      </Style>
      <Selectors>
        <StyleSelector>
          <Type>ReportItemBase</Type>
          <StyleName>Data</StyleName>
        </StyleSelector>
      </Selectors>
    </StyleRule>
    <StyleRule>
      <Style Color="Black" VerticalAlign="Middle">
        <Font Name="Tahoma" Size="8pt" Style="Regular" />
      </Style>
      <Selectors>
        <StyleSelector>
          <Type>ReportItemBase</Type>
          <StyleName>PageInfo</StyleName>
        </StyleSelector>
      </Selectors>
    </StyleRule>
  </StyleSheet>
  <Groups>
    <Group Name="labelsGroup">
      <GroupHeader>
        <GroupHeaderSection PrintOnEveryPage="True" Height="0.28125in" Name="labelsGroupHeader">
          <Items>
            <TextBox Value="name" CanGrow="True" Left="0.02083333in" Top="0.02083333in" Width="5.19791667in" Height="0.20000001in" Name="nameCaptionTextBox" StyleName="Caption" />
            <TextBox Value="description" Angle="0" CanGrow="True" Left="5.23958333in" Top="0.02083333in" Width="4.46041679in" Height="0.20000001in" Name="descriptionCaptionTextBox" StyleName="Caption" />
          </Items>
        </GroupHeaderSection>
      </GroupHeader>
      <GroupFooter>
        <GroupFooterSection Height="0.28125in" Name="labelsGroupFooter">
          <Style Visible="False" />
        </GroupFooterSection>
      </GroupFooter>
    </Group>
  </Groups>
  <Items>
    <PageHeaderSection Height="0.28125in" Name="pageHeader">
      <Style>
        <BorderStyle Default="Solid" />
      </Style>
    </PageHeaderSection>
    <PageFooterSection Height="0.28125in" Name="pageFooter">
      <Items>
        <TextBox Value="=NOW()" Left="0.02083333in" Top="0.02083333in" Width="5.19791667in" Height="0.20000001in" Name="currentTimeTextBox" StyleName="PageInfo" />
        <TextBox Value="=PageNumber" Left="5.23958333in" Top="0.02083333in" Width="5.19791667in" Height="0.20000001in" Name="pageInfoTextBox" StyleName="PageInfo">
          <Style TextAlign="Right" />
        </TextBox>
      </Items>
    </PageFooterSection>
    <ReportHeaderSection Height="0.80823493in" Name="reportHeader">
      <Items>
        <TextBox Value="Panda Settings" Left="0in" Top="0in" Width="10.45833333in" Height="0.7874016in" Name="titleTextBox" StyleName="Title" />
      </Items>
    </ReportHeaderSection>
    <ReportFooterSection Height="0.28125in" Name="reportFooter" />
    <DetailSection Height="0.28125in" Name="detail">
      <Items>
        <TextBox Value="=Fields.name" CanGrow="True" Left="0.02083333in" Top="0.02083333in" Width="5.19791667in" Height="0.20000001in" Name="nameDataTextBox" StyleName="Data" />
        <TextBox Value="=Fields.description" Angle="0" CanGrow="True" Left="5.23958333in" Top="0.02083333in" Width="4.46041679in" Height="0.20000001in" Name="descriptionDataTextBox" StyleName="Data" />
      </Items>
    </DetailSection>
  </Items>
</Report>



Where am I going wrong?

General Discussions

answered on 07 Feb 2013

1 answer

98 views

Hide subreports based on selection criteria from website

I have a website that includes a report with multiple subreports. I have to add the functionality that the user can choose which subreports they can/cannot see. For example, the user may choose to only include reports 1,3 & 5, but not 2 & 4, or any of the rest. I will probably use some sort of list control to allow the user to select the subreports that they want included.

I have a reportviewer defined in my HTML:

<telerik:ReportViewer ID="ReportViewer1" runat="server" Height="500px" Width="100%">

<typereportsource typename="ETRrpts.IndividualSummary, ETRrpts, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null"></typereportsource>

</telerik:ReportViewer>

So what is the optimal way for me to identify, show and/or hide the subreports based on the user's selection?

Thank you!

General Discussions

answered on 07 Feb 2013

3 answers

221 views

Show Page Footer before Report Footer on Last Page

Hi,

How to show Page Footer before Report Footer on Last Page??

I have a report in which I show Pagewise Totals and Grand Total both.
But on last page Grand total comes before Page total and I want Grand total in the end of Report and Page total come before it.
I have attached screen shots...

Can i achieve this? and How?

Thanks in Advance...

General Discussions

answered on 06 Feb 2013

1 answer

51 views

Crosstab grouping cell edges thicker

I successfully did a report but now I want to make the cell edges ticker on each grouping to make a differentiation:

I'm using the: "=" to be thicker

Example:
=====================
=               = detail1       =
= Group1 =__________=
=               = detail2        =
=               =_________ =
=               = detail3        =
====================
=               = detail4       =
= Group2 =__________=
=               = detail5        =
=               =_________ =
=               = detail6        =
====================

General Discussions

answered on 06 Feb 2013

1 answer

391 views

How to put Group and Detail side by side?

I have built a simple report with one group, where the data output looks something like this:

C1 C2 C3 C4

AAA Blue

5 10

6 20

AAA Yellow

2 10

BBB Green

3 20

I need to change the format (preferably into a table) where the first line of the detail is on the same line as the group. I need to do this because most of the time, there will only be one detail line per group. So it should look more like this:

C1 C2 C3 C4

AAA Blue 5 10

6 20

AAA Yellow 2 10

BBB Green 3 20

My existing group and detail insist on being on different lines. I suspect the way to do it has to do with adjacent left or right groups in a table, but I can't figure out how to make it work.

General Discussions

answered on 06 Feb 2013

6 answers

210 views

Report upgrade to 6.2.13.110 causing design/parameter problems

Hi,

Couple of issues.

I installed reporting using and upgraded the project using the wizard.

When I try to open a report in design mode I get the problem shown in capture2.jpg which is trying to find a prior versioned dll.

Also one of reports has parameters that the viewer prompts for at runtime. the report will take the parameter but the following code that has always run in the past no longer runs:

private void RptADASummary_ItemDataBinding(object sender, EventArgs e)

{

if (txtStartDate.Value == string.Empty)

{

SchoolMonth _schoolMonth = SchoolMonthService.GetByID(Int32.Parse(this.ReportParameters["SchoolMonthID"].Value.ToString()));

txtMonthNumber.Value = _schoolMonth.SchoolMonthNumber.ToString();

txtStartDate.Value = _schoolMonth.StartDate.ToShortDateString();

txtEndDate.Value = _schoolMonth.EndDate.ToShortDateString();

}

specifically it says the "this.ReportParameters["SchoolMonthID"

].Value" is null.  This code has always compliled and run fine until the most recent upgrade.  has anything changed how one can access parameters in the report? If I take out the contents of this function, the report runs fine but is missing the text boxes.  see capture1.jpg



Thanks,



Jonathan

General Discussions

answered on 05 Feb 2013

0 answers

136 views

Toggle Visibility

Is there a way to initially toggle visibility conditionally? I have a report that a grouping toggles the detail visibility, Everything works fine I can either have the report completely expanded, everything visible, or I can have the report open with all the Details section invisible. What I would like would be for the report to open with only one specified grouping already expanded while the other are still invisible, and then have the toggle function normally after that. Is this possible, I have played with the conditional formatting but whatever I have the detail section visibility section set to over rides the conditional, and once the conditional is set the toggle will no longer properly work.

General Discussions

asked on 05 Feb 2013

7 answers

298 views

Indent cell in Excel report

I have a Telerik report that I'm exporting to Excel. My TextBox has a padding-left set, and in the designer it looks good (the text in the TextBox is indented). But when I export the report to Excel, the indenting goes away. How can I get the Excel report to indent the text in the cell?

General Discussions

answered on 05 Feb 2013