Questions on Reporting Forum

1 answer

202 views

Best way to generate a multiple page report

I want to create a report that has one page per customer. Each customer has multiple line items on the report in two different sections on the page. What is the best way to do this. Ideally I would like to run these from a few views I have in SQL.

Below is an example of what I am looking for...

---- Customer 1 ----

Customer Name: Bob Smith
Customer Email: bsmith@somedomainname.com

Customer Usage
This Month Last Month Year to date
100 200 300

Customer Data
Events Notes
50 75

---- Customer 2 ----

Customer Name: Larry Smith
Customer Email: lsmith@somedomainname.com

Customer Usage
This Month Last Month Year to date
100 200 300

Customer Data
Events Notes
50 75

General Discussions

answered on 25 Nov 2014

1 answer

110 views

Passing Report Parameter

I have a form that gets a value form the user. I call the report form (the winform with the report viewer) and pass it the value the user supplied. I thought I could pass this to the report but I can't see to figure it out.

In the report class, I have:

           public rptTimeSheet(string sheetID)

           {

            string comStr = "SELECT * FROM vwTimeSheetReport WHERE TimeSheetID = " + sheetID;

            SqlConnection sqlConnection1 = new SqlConnection();

            SqlCommand sqlSelectCommand1 = new SqlCommand();

            SqlDataAdapter sqlDataAdapter1 = new SqlDataAdapter();

            sqlConnection1.ConnectionString = "XXXX";

            sqlSelectCommand1.CommandText = comStr;

            sqlSelectCommand1.Connection = sqlConnection1;

            sqlDataAdapter1.SelectCommand = sqlSelectCommand1;

            this.DataSource = sqlDataAdapter1;

            InitializeComponent();

        }

Obviously, I want to pass that value to the report class, but I'm baffled as to where I should do it. I have a reportviewer in a winform and the report source is the above report class.

How do I do this?

General Discussions

answered on 21 Nov 2014

4 answers

212 views

Localization with custom provider

I work with a system that has a custom resource provider that uses a database to store values.

Would it be possible to leverage that provider with the reporting localization or can you only use .resx files?

Thanks in advance!

General Discussions

answered on 21 Nov 2014

3 answers

320 views

how to insert hyperlinks in telerik.reporting.processing.textbox in ItemDataBound events

Hi everyone,
I am a newbie in telerik world I am required to change something in existing report
here is my question,
how to insert hyperlinks in telerik.reporting.processing.textbox in ItemDataBound event
Please Help!
Cheers
Hanif

General Discussions

answered on 21 Nov 2014

1 answer

110 views

Hidden Subreport executes datasource

I have a report that contains several subreports and depending on which parameters are passed will hide all irrelevant subreports.

These subreports have their own datasources that appear to execute regardless if they're visible or not.

Is it intended functionality for a hidden subreport to execute its datasource?

General Discussions

answered on 21 Nov 2014

1 answer

116 views

Details section repeats in report with 2 groups

My report is broken down by subcustomer and then by project (e.g. 2 groups). It displays on screen correctly but when I export it to a pdf, the details section repeats on a second page although the details do not actually appear. I used a color background to see what's going on.This happens across the entire report so that a 4 page report will turn into 8 pages, for example. To be clear, the report layout is GH1, GH2, details, GF2, GF1. Please look at the attached screen shots and you'll see how it's repeating.

What should I look at in my report to address this problem?

General Discussions

answered on 21 Nov 2014

1 answer

89 views

Table header too close to page header

Hello,

See the attached files. When i set ColumnHeaderPrintOnEveryPage = true, it prints the header on every page when i export to PDF. Why is it that there is not the same space between the page header and the table header?

General Discussions

answered on 21 Nov 2014

3 answers

105 views

Show Cover Page only while Exporting

Is there a way of adding a cover page in a Telerik Report only whilst exporting using the Telerik Reporting Web Services? I assume if the answer is no, the only option is to manually handle exports?

Another option, would it be possible to hide pages in the Report Viewer (e.g. the first/cover page) instead?

General Discussions

answered on 20 Nov 2014

6 answers

294 views

How to set Sub Report's visibilty as per Row Count of Sub Report's Datasource?

I have used Telerik reporting service for my silverlight application.In my main report there is a sub-report.Both have own Datasource and I have pass Main report's One Field value as parameter value of Sub-report to get relevant data only.Everything is working fine.Now In case of zero record in Datasource of Sub-Report,I do not want to Display Sub-Report.I have try to make aggregate field(=Count(FieldName) and as per it's value I thought I will be able to know whether want to display report or not.But I am getting TextBox.Value equal to "=Count(FieldName)" inseated of any numeric value. I have use SQL Datasource.Let me know what to do in such scenario?

General Discussions