Questions on Reporting Forum

6 answers

2.2K+ views

Report does not fit in print preview or on Pdf export.

My table report cuts off the far right portion of the table and puts it on another line. This happens when I export to Pdf or when I view it in print preview. I am using the latest version (2015 Q2) of the HTML 5 report view. I want the report to appear as it appears in the report viewer when I export it to Pdf.

Here is the report definition:

<?xml version="1.0" encoding="utf-8"?>
<Report Width="11.9999605814616in" Name="AttendanceReport" xmlns="http://schemas.telerik.com/reporting/2012/3.8">
<DataSources>
<SqlDataSource ConnectionString="ZENContext" SelectCommand="exec spReporting_AttendanceReport @InterventionId, @ProgramId, @MethodId, @EventId,
@EducatorId, @City, @Location, @StartDate, @EndDate" Name="sqlDataSource1">
<Parameters>
<SqlDataSourceParameter DbType="String" Name="@InterventionId">
<Value>
<String>= Parameters.InterventionId.Value</String>
</Value>
</SqlDataSourceParameter>
<SqlDataSourceParameter DbType="Int32" Name="@ProgramId">
<Value>
<String>= Parameters.ProgramId.Value</String>
</Value>
</SqlDataSourceParameter>
<SqlDataSourceParameter DbType="String" Name="@MethodId">
<Value>
<String>= Parameters.MethodId.Value</String>
</Value>
</SqlDataSourceParameter>
<SqlDataSourceParameter DbType="String" Name="@EventId">
<Value>
<String>= Parameters.EventId.Value</String>
</Value>
</SqlDataSourceParameter>
<SqlDataSourceParameter DbType="String" Name="@EducatorId">
<Value>
<String>= Parameters.EducatorId.Value</String>
</Value>
</SqlDataSourceParameter>
<SqlDataSourceParameter DbType="String" Name="@City">
<Value>
<String>= Parameters.City.Value</String>
</Value>
</SqlDataSourceParameter>
<SqlDataSourceParameter DbType="String" Name="@Location">
<Value>
<String>= Parameters.Location.Value</String>
</Value>
</SqlDataSourceParameter>
<SqlDataSourceParameter DbType="DateTime" Name="@StartDate">
<Value>
<String>= Parameters.StartDate.Value</String>
</Value>
</SqlDataSourceParameter>
<SqlDataSourceParameter DbType="DateTime" Name="@EndDate">
<Value>
<String>= Parameters.EndDate.Value</String>
</Value>
</SqlDataSourceParameter>
</Parameters>
</SqlDataSource>
</DataSources>
<Items>
<PageHeaderSection Height="1in" Name="pageHeaderSection1">
<Style BackgroundColor="255, 255, 255" />
<Items>
<TextBox Width="2.69999980926514in" Height="0.400000015894572in" Left="0.100000381469727in" Top="0.0999999841054281in" Value="Attendance Report" Name="textBox1">
<Style>
<Font Name="Times New Roman" Size="20pt" />
</Style>
</TextBox>
</Items>
</PageHeaderSection>
<DetailSection Height="2in" Name="detailSection1">
<Items>
<Table DataSourceName="sqlDataSource1" Width="9.80000026226044in" Height="0.4in" Left="0.100000381469727in" Top="0.199999968210856in" Name="table1" StyleName="Corporate.TableNormal">
<Body>
<Cells>
<TableCell RowIndex="0" ColumnIndex="0" RowSpan="1" ColumnSpan="1">
<ReportItem>
<TextBox Width="0.999999988018249in" Height="0.2in" Left="0in" Top="0in" Value="= Fields.InterventionName" Name="textBox15" StyleName="Corporate.TableBody" />
</ReportItem>
</TableCell>
<TableCell RowIndex="0" ColumnIndex="1" RowSpan="1" ColumnSpan="1">
<ReportItem>
<TextBox Width="0.8in" Height="0.2in" Left="0in" Top="0in" Value="= Fields.ProgramId" Name="textBox16" StyleName="Corporate.TableBody" />
</ReportItem>
</TableCell>
<TableCell RowIndex="0" ColumnIndex="2" RowSpan="1" ColumnSpan="1">
<ReportItem>
<TextBox Width="0.8in" Height="0.2in" Left="0in" Top="0in" Value="= Fields.ProgramName" Name="textBox17" StyleName="Corporate.TableBody" />
</ReportItem>
</TableCell>
<TableCell RowIndex="0" ColumnIndex="3" RowSpan="1" ColumnSpan="1">
<ReportItem>
<TextBox Width="0.8in" Height="0.2in" Left="0in" Top="0in" Value="= Fields.MethodName" Name="textBox18" StyleName="Corporate.TableBody" />
</ReportItem>
</TableCell>
<TableCell RowIndex="0" ColumnIndex="4" RowSpan="1" ColumnSpan="1">
<ReportItem>
<TextBox Width="0.8in" Height="0.2in" Left="0in" Top="0in" Value="= Fields.EventId" Name="textBox19" StyleName="Corporate.TableBody" />
</ReportItem>
</TableCell>
<TableCell RowIndex="0" ColumnIndex="5" RowSpan="1" ColumnSpan="1">
<ReportItem>
<TextBox Width="0.8in" Height="0.2in" Left="0in" Top="0in" Value="= Fields.EventName" Name="textBox20" StyleName="Corporate.TableBody" />
</ReportItem>
</TableCell>
<TableCell RowIndex="0" ColumnIndex="6" RowSpan="1" ColumnSpan="1">
<ReportItem>
<TextBox Width="0.8in" Height="0.2in" Left="0in" Top="0in" Value="= Fields.Educator" Name="textBox21" StyleName="Corporate.TableBody" />
</ReportItem>
</TableCell>
<TableCell RowIndex="0" ColumnIndex="7" RowSpan="1" ColumnSpan="1">
<ReportItem>
<TextBox Width="0.8in" Height="0.2in" Left="0in" Top="0in" Value="= Fields.Location" Name="textBox22" StyleName="Corporate.TableBody" />
</ReportItem>
</TableCell>
<TableCell RowIndex="0" ColumnIndex="8" RowSpan="1" ColumnSpan="1">
<ReportItem>
<TextBox Width="0.8in" Height="0.2in" Left="0in" Top="0in" Value="= Fields.ParticipationStatus" Name="textBox23" StyleName="Corporate.TableBody" />
</ReportItem>
</TableCell>
<TableCell RowIndex="0" ColumnIndex="9" RowSpan="1" ColumnSpan="1">
<ReportItem>
<TextBox Width="0.8in" Height="0.2in" Left="0in" Top="0in" Value="= Fields.ParticipationStatusCount" Name="textBox24" StyleName="Corporate.TableBody" />
</ReportItem>
</TableCell>
<TableCell RowIndex="0" ColumnIndex="10" RowSpan="1" ColumnSpan="1">
<ReportItem>
<TextBox Width="0.8in" Height="0.2in" Left="0in" Top="0in" Value="= Fields.StartDate" Name="textBox25" StyleName="Corporate.TableBody" />
</ReportItem>
</TableCell>
<TableCell RowIndex="0" ColumnIndex="11" RowSpan="1" ColumnSpan="1">
<ReportItem>
<TextBox Width="0.8in" Height="0.2in" Left="0in" Top="0in" Value="= Fields.EndDate" Name="textBox26" StyleName="Corporate.TableBody" />
</ReportItem>
</TableCell>
</Cells>
<Columns>
<Column Width="1.00000006103394in" />
<Column Width="0.800000078033429in" />
<Column Width="0.800000078033429in" />
<Column Width="0.800000078033429in" />
<Column Width="0.800000078033429in" />
<Column Width="0.800000078033429in" />
<Column Width="0.800000078033429in" />
<Column Width="0.800000078033429in" />
<Column Width="0.800000078033429in" />
<Column Width="0.800000078033429in" />
<Column Width="0.800000078033429in" />
<Column Width="0.800000078033429in" />
</Columns>
<Rows>
<Row Height="0.2in" />
</Rows>
</Body>
<Corner />
<RowGroups>
<TableGroup Name="Detail">
<Groupings>
<Grouping />
</Groupings>
</TableGroup>
</RowGroups>
<ColumnGroups>
<TableGroup>
<ReportItem>
<TextBox Width="0.999999988018249in" Height="0.2in" Left="0in" Top="0in" Value="Intervention" Name="textBox3" StyleName="Corporate.TableHeader" />
</ReportItem>
</TableGroup>
<TableGroup>
<ReportItem>
<TextBox Width="0.8in" Height="0.2in" Left="0in" Top="0in" Value="Program Id" Name="textBox4" StyleName="Corporate.TableHeader" />
</ReportItem>
</TableGroup>
<TableGroup>
<ReportItem>
<TextBox Width="0.8in" Height="0.2in" Left="0in" Top="0in" Value="Program" Name="textBox5" StyleName="Corporate.TableHeader" />
</ReportItem>
</TableGroup>
<TableGroup>
<ReportItem>
<TextBox Width="0.8in" Height="0.2in" Left="0in" Top="0in" Value="Method" Name="textBox6" StyleName="Corporate.TableHeader" />
</ReportItem>
</TableGroup>
<TableGroup>
<ReportItem>
<TextBox Width="0.8in" Height="0.2in" Left="0in" Top="0in" Value="Event Id" Name="textBox7" StyleName="Corporate.TableHeader" />
</ReportItem>
</TableGroup>
<TableGroup>
<ReportItem>
<TextBox Width="0.8in" Height="0.2in" Left="0in" Top="0in" Value="Event" Name="textBox8" StyleName="Corporate.TableHeader" />
</ReportItem>
</TableGroup>
<TableGroup>
<ReportItem>
<TextBox Width="0.8in" Height="0.2in" Left="0in" Top="0in" Value="Educator" Name="textBox9" StyleName="Corporate.TableHeader" />
</ReportItem>
</TableGroup>
<TableGroup>
<ReportItem>
<TextBox Width="0.8in" Height="0.2in" Left="0in" Top="0in" Value="Location" Name="textBox10" StyleName="Corporate.TableHeader" />
</ReportItem>
</TableGroup>
<TableGroup>
<ReportItem>
<TextBox Width="0.8in" Height="0.2in" Left="0in" Top="0in" Value="Status" Name="textBox11" StyleName="Corporate.TableHeader" />
</ReportItem>
</TableGroup>
<TableGroup>
<ReportItem>
<TextBox Width="0.8in" Height="0.2in" Left="0in" Top="0in" Value="Count" Name="textBox12" StyleName="Corporate.TableHeader" />
</ReportItem>
</TableGroup>
<TableGroup>
<ReportItem>
<TextBox Width="0.8in" Height="0.2in" Left="0in" Top="0in" Value="Start Date" Name="textBox13" StyleName="Corporate.TableHeader" />
</ReportItem>
</TableGroup>
<TableGroup>
<ReportItem>
<TextBox Width="0.8in" Height="0.2in" Left="0in" Top="0in" Value="End Date" Name="textBox14" StyleName="Corporate.TableHeader" />
</ReportItem>
</TableGroup>
</ColumnGroups>
</Table>
</Items>
</DetailSection>
<PageFooterSection Height="1in" Name="pageFooterSection1">
<Items>
<TextBox Width="1.99999968210856in" Height="0.2999607026577in" Left="0.00003941853841146in" Top="0.100000143051147in" Value="=Parameters.TimeRan.Value" Name="textBox2" />
</Items>
</PageFooterSection>
</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="Corporate.TableNormal" />
</Selectors>
</StyleRule>
<StyleRule>
<Style BackgroundColor="28, 58, 112" Color="White" 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="Corporate.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="Corporate.TableBody" />
</Selectors>
</DescendantSelector>
</Selectors>
</StyleRule>
</StyleSheet>
<PageSettings>
<PageSettings PaperKind="Letter" Landscape="False" ColumnCount="1" ColumnSpacing="0in">
<Margins>
<MarginsU Left="1in" Right="1in" Top="1in" Bottom="1in" />
</Margins>
</PageSettings>
</PageSettings>
<ReportParameters>
<ReportParameter Name="InterventionId" Type="Integer" AllowNull="True">
<Value>
<String></String>
</Value>
</ReportParameter>
<ReportParameter Name="ProgramId" Type="Integer" AllowNull="True">
<Value>
<String></String>
</Value>
</ReportParameter>
<ReportParameter Name="MethodId" Type="Integer" AllowNull="True" />
<ReportParameter Name="EventId" Type="Integer" AllowNull="True" />
<ReportParameter Name="EducatorId" Text="EducatorId" AllowNull="True" />
<ReportParameter Name="City" AllowNull="True" />
<ReportParameter Name="Location" AllowNull="True" />
<ReportParameter Name="StartDate" Type="DateTime" AllowNull="True" />
<ReportParameter Name="EndDate" Type="DateTime" AllowNull="True" />
<ReportParameter Name="TimeRan" Type="DateTime" AllowNull="True">
<Value>
<String></String>
</Value>
</ReportParameter>
</ReportParameters>
</Report>

Thanks in advance.

Report Designer (standalone)

answered on 15 Jul 2015

1 answer

313 views

Preview button

Hello people,

I have created "search kind of " functionality by using Report parameter and Filters. It works fine, but now I need to change button text from preview to something else? Whole report is in Finnish and that one button is in English and text is not very descriptive for functionality.

Thanks in advance.

Mikko

Report Designer (standalone)

answered on 15 Jul 2015

1 answer

854 views

Remove empty space

I have multiple textboxes in the detail section. If I set visibility of one textbox to false with conditional formatting empty space is visible.

Also I put

textBox3.Height = new Telerik.Reporting.Drawing.Unit(0);

in the constructor.

How can I remove that empty space and move below textboxes on top? You can see my report from report designer and report viewer in the attached images.

Thanks

General Discussions

answered on 14 Jul 2015

1 answer

54 views

Displaying multidimentional data on tabular form with telerik reporting designer

Hi,

How to display multidimentional data (multipile line, grouped) on a tabular grid.

Regards,

General Discussions

answered on 14 Jul 2015

3 answers

333 views

Suppressing Report Error Messages

I have a data structure where some fields may or may not be present. If the fields are not there, I just don't want to display anything. How do I suppress the 'object not found in this context' error message? There appears to be a thread that discussed this very issue, but the link to the answer has been deleted:

http://www.telerik.com/help/reporting/telerik.reporting-telerik.reporting.processing.renderingresult_members.html

General Discussions

answered on 13 Jul 2015

2 answers

813 views

Using a table in a report

I have a basic report that has about 10 columns and I have created the table and put the =field.XXXX in each text box. I had it working using the report and saw that I needed to use the table since the export adds merged cells to EXCEL. What I am trying to figure out is how to bind data to it. I used a datatable when I created it originally but it doesn't seem to work using the table. Can someone post a code snippet to populate table cells? Let me know if you need more information.

thanks for help in advance,

Mark

General Discussions

answered on 13 Jul 2015

1 answer

160 views

Performance Difference Between TRDX and Report CLass

I have the same report defined in both a report class and a trdx file. The report is very simple, it prints a name and address on a single line. There is only a detail band and the report doesn't do any data manipulation, calculations, method calls etc... I ran the following tests with 50,000 records in a WinForm application.

Test 1: Report Class

It takes ~10 minutes to render and preview the report. I'm using an InstanceReportSource created from my report class. I have tried this using both a DataTable and a Telerik.Reporting.SqlDataSource as the DataSource with the same results.

Test 2: TRDX File

It takes ~2 minutes to render and preview the report.

Is this performance difference normal/expected and if so why? Given the nature of our application we can't really use trdx files due to their limitation. We also can't afford to take such a huge performance hit.

General Discussions

answered on 13 Jul 2015

3 answers

100 views

Need help for Multi Column sorting in Interactive Sorting

Hi Team,

We are developing one report which works fine with single column sort via Interactive sorting.

-------------------------------------

http://www.telerik.com/support/kb/reporting/styling-and-formatting-reports/details/how-to-add-interactive-sorting-to-a-table-item-

-------------------------------------

Now here we are facing issue for multicolumn sorting. we need multiple column to sort via Interactive sorting only and yes we need it to work in HTML5 report viewer.

Thank You.

General Discussions

answered on 13 Jul 2015

1 answer

200 views

Using EF6 and EntityDataSource in report designer

I have tried several times to create a new Telerik Report with with Visual Studio Report Designer. I am able to create reports that connect to a database using the SqlDataSource, however when I try and connect using the EntityDataSource, I end up with the report preview throwing one of two errors related to connection string and/or dbconnection.

1)I created a class library in a separate project complete with an EF6 edmx and dbcontext class. All went well.

2) I added an reference to the project in my Report library project. All went well

3) I created a new report with the designer and added an EntityDataSource using the wizard. It recognized my entity model gave me options for choosing the entity in the model I wanted to use.

4) I tried to flip to the Preview and Html Preview and get an error indicating "no connection string named "myentitiesname" could be found in the application config file.

5) I even tried adding the connection string to the project's app.config file with no luck.

From the reading online, it seems like I may need to manually configure the connection string /db context for the preview to work, but I am not sure exactly what is needed.

General Discussions

answered on 13 Jul 2015

2 answers

161 views

Report Parameters Disappear after preview

The developer just upgraded our application to Telerik Reporting Q1 2015 (9.0.15.324) and all of a sudden the preview button on report viewer makes the parameters disappear. Here's a 9 second screencast that illustrates the issue - http://screencast.com/t/QY49ul4h

Any suggestions? Seen it before? Addressed in the service pack?

Thanks -

Chris

General Discussions

answered on 10 Jul 2015