Questions on Reporting Forum

1 answer

638 views

Hi,

I have a report that I am converting from Crystal that has a need to determine the page numbers for a subreport, which then get passed to another subreport.
What I do today is determine the number of pages of the details and calculate the start page and populate some text that reads "See pages 2 to 5" for example of the 5 pages.
I then pass that from the master report to the first subreport as a parameter to add to a text box.

Any ideas, suggestions on this one?

Thank you!

General Discussions

answered on 26 Mar 2012

4 answers

397 views

Reports with Document Map & Excel Sheet

Hello everyone,
I have a website that calls a server side generated report, in function of some check-boxes selected. These reports are mainly exported in Excel. Each check-box selected should be a document map in the report and has to be a different sheet in the excel export.

For example there are 3 check-boxes:
- Generate report A
- Generate report B
- Generate report C
When the check-boxes A and C are checked, it generates a report with Document map: A & C and while exporting in Excel, it creates the sheets : A & C.

How does the report know what report to generate: A String parameter is sent to the report, for this example the String "A,C" is sent, and so the report knows that those 2 reports have to be generated.

I searched the several methods to do that :
1) Report Book
The report book is great. It creates a Document map and a excel sheet for each document map. But the problem is that it is not possible to work with the report parameters in the report book. So I cannot parse the String "A,C" that is sent to the report. The reports added to the Book are "static" and cannot be added dynamically.

2) Master - Sub reports
This generates a document map and it is possible to work with the report parameters in the master report. The master report parses the parameter "A,C" and knows that it has to generate those 2 reports . But the problem in that solution is that it doesn't create several sheets in excel; it puts all on the same page.

Is there a third solution I didn't think of? How can I generate dynamically reports and having excel sheets? Do I have to create a report book for each combination of the check-boxes? A, B, C, AB, AC, BC, ABC ; and choose on the client side which Report-book has to be called? But that would make a lot of work.
Is it possible to have a master-sub report with several excel sheets? I don't think so, because it is one master-report; so, one sheet.

Thanks a lot,
Raphael

PS: I am using the version Q3 2011 SP1 of Telerik Report

General Discussions

answered on 26 Mar 2012

0 answers

124 views

can grow not working in group hedaer section and detail section

iam creating a report using object datasource.when i display that report the data is not diaplaying with proper alignment iam giving textbox alignment as left and can grow="true" though it is not working,it is working fine for IE8 and reamining browsers like IE9 and mozilla and google crome can grow property not applied

General Discussions

asked on 26 Mar 2012

3 answers

974 views

Convert from Active Reports (*.rpx)

Hi,
Does Telerik Reporting support convert from active reports (*.rpx files)?
Rpx files are described here - http://www.telerik.com/community/forums/reporting/telerik-reporting/creating-reports-outside-vs-net.aspx

Thanks in advance.

General Discussions

answered on 26 Mar 2012

1 answer

112 views

Can I react on the printDialogResult

Hi. Tell me please. Am I can react on the printDialogResult in the report. I use telerikReportViewer Silvelight. On OK I'd like to insert into database and on Cancel nothing action, Help me please

General Discussions

answered on 26 Mar 2012

1 answer

183 views

crosstab needs to display columns with zero's

I have created a crosstab, and it works fine.
It shows months in each column, and sales per month. The problem is when a month doesn't have sales, this month will be hidden in the crosstab. I want the crosstab to show this month with zero values! is there a setting to avoid this tab-behaviour?

I'm using telerik 2012 Q1

General Discussions

answered on 26 Mar 2012

3 answers

378 views

[Solved] How to test a Barcode in my report

I am adding a Barcode filed to a report I'm using to print Avery labels for a parts Bin system. Each Bin label has the barcode of the Bin Number, pretty straight forward. I have not yet coded anything to read in the barcode but I would like to be able to test it before printing hundreds of labels. Is there some quick way of testing that the barcode will in fact return the Bin Number assigned to it? I am including an example of the labels I am creating and the barcode represents the bold number (Bin Number) on the top left of each label.

General Discussions

answered on 26 Mar 2012

1 answer

229 views

Telerik Report Bind with Linq

Hi,

I want to display the data into telerik report viewer control through the Linq with stored procedure.

I have tried this but not get the success.

Telerik report viewer showing as blank.

I used this source code also without LInq

Telerik.Reporting.ObjectDataSource objectDataSource = new Telerik.Reporting.ObjectDataSource();
objectDataSource.DataSource = GetAllData(); // GetData returns a DataSet with three tables
objectDataSource.DataMember = "VehiclePlanInformation"; /// Indicating the exact table to bind to. If the DataMember is not specified the first data table will be used.

// objectDataSource.CalculatedFields.Add(new Telerik.Reporting.CalculatedField("PlanCode", typeof(string), "=Fields.PlanCode")); // Adding a sample calculated field.

// Creating a new report
Telerik.Reporting.Table report = new Telerik.Reporting.Table();

// Assigning the ObjectDataSource component to the DataSource property of the report.
report.DataSource = objectDataSource;

// Assigning the report to the report viewer.
ReportViewer1.Report =(Telerik.Reporting.IReportDocument)report;

// Calling the RefreshReport method (only in WinForms applications).
ReportViewer1.RefreshReport();

but not get the success.

Please suggest me. Its urgent for me.

Thanks

Vikas

General Discussions

answered on 26 Mar 2012

1 answer

127 views

Question regarding Charts

Good Morning all!

Definitely new to Telerik. I'm coming from a slight background in Xcelsius, and I had a question regarding Tables and Charts. Do these items have the same ability to expand or contract dynamically (IE: new data added on top of exiting data, or items removed as they are no longer relevant.....and the component scales accordingly)?

My organization is looking to shift to Telerik for a project, and I am just trying to arm myself with some knowledge when we do our side by side comparison.

Thanks!

General Discussions

answered on 26 Mar 2012

1 answer

167 views

Need Direction on report

I am an untrained volunteer, attempting to solve a reporting problem.

I am experimenting with the standalone version of the report designer to see if it is a reporting solution that will work for me.

I am able to generate the reports I need individually, by inserting three where variables into the select statement. as follows

Select * from B_MRDATA where System = 'Inglemoor' and Level = 'Rookies' and Split = 'None'
Order By last

There are potentially 309 combinations of the three variables System, Level, and Split. Not all those combinations will be used.. Is there a way to automate a process and generate all the required reports at once?

Here is the xml code for one of the reports - I deleted the connection string.

Thanks in advance for any help you can give me - Billie

(<?xml version="1.0" encoding="utf-8"?>

</DataSources>

</PageSettings>

<DataSourceRef>sqlDataSource1</DataSourceRef>

</Style>

<Type>ReportItemBase</Type>

<StyleName>Title</StyleName>

</StyleSelector>

</Selectors>

</StyleRule>

</Style>

<Type>ReportItemBase</Type>

<StyleName>Caption</StyleName>

</StyleSelector>

</Selectors>

</StyleRule>

</Style>

<Type>ReportItemBase</Type>

</StyleSelector>

</Selectors>

</StyleRule>

</Style>

<Type>ReportItemBase</Type>

<StyleName>PageInfo</StyleName>

</StyleSelector>

</Selectors>

</StyleRule>

</StyleSheet>

<Items>

</Items>

</GroupHeaderSection>

</GroupHeader>

</GroupFooterSection>

</GroupFooter>

</Group>

</Groups>

<Items>

<Items>

</Items>

</PageHeaderSection>

<Items>

</TextBox>

</Items>

</PageFooterSection>

<Items>

</TextBox>

</Items>

</ReportHeaderSection>

<Items>

</Items>

</DetailSection>

</Items>

</Report> )

Report Designer (standalone)

answered on 26 Mar 2012