Telerik Forums
Reporting Forum
4 answers
352 views

Hi,

I’m trying to display some master-detail data on a report. I have designed two separate reports and linking the detail report to a sub report item in the detail section of the master report. But the detail report (for any master row) is always displaying the records related to the first master row. Code I’m using is similar to below. Can you please help solving this.

Thanks and regards,

Kushan

 

MasterReport  masterReport  =  new  MasterReport();

DataTable  masterDataSource  =  getMasterDataSource();

Foreach(DataRow drM  in  masterDataSource.Rows)

{

   FormatMasterRows(drM);

   DataTable  detailDataSource  =  getDetailDataSource(drM);

   If(detailDataSource.RowCount > 0)

   {

            DetailReport  detailReport  =  new DetailReport();

            Foreach(DataRow  drD  in detailDataSource.Rows)

            {

               FormatDetailRows(drD);

            }

            detailReport.DataSource  =  detailDataSource;

            masterReport.subReportItem1.ReportSource  =  detailReport;

            masterReport.subReportItem1.ReportSource  =  true;      

   }

   Else

  {

            masterReport.subReportItem1.ReportSource  =  false;

            masterReport.detailSection.Height  =  masterReport.detailSection.Height   -  masterReport.subReportItem1.Height;

  }

}

masterReport.DataSource  =  drM;

DisplayRepotViewer(masterReport);

Ivan
Telerik team
 answered on 29 Aug 2008
1 answer
366 views
Hi, on some reports with over 3000 records and heavy grouping I'm getting out of memory exception errors (after I updated httpRuntime executionTimeout="240" in web.config to stop the timeout errors). I notice in another thread you recommend setting app pool to "A value of 300 Mb used memory and default value for virtual memory" would this still be your recommendation and is there anywhere you can point me to to optimise and reduce the memory footprint in the report design?

cheers
Martin
Chavdar
Telerik team
 answered on 29 Aug 2008
1 answer
145 views
I can't show data from report in chart. All i've found to bind data from datasource to chart is chart.datasourceid but it doesn't exist. Is there any step by step manual how to show sql results in a chart?
Chavdar
Telerik team
 answered on 29 Aug 2008
1 answer
125 views
Is it possible to have Adobe PDF as the only exporting format choice in the report viewer? 
Ivan
Telerik team
 answered on 29 Aug 2008
2 answers
163 views
Hi,

  I published the web aplication with a telerik application, I copied all dlls
into bin folder but when it rendering, the page are blank.

  Have more files or configurations in the server?

  Thanks,
  Jose
Francisco
Top achievements
Rank 1
 answered on 28 Aug 2008
1 answer
143 views
I am tring to figure out how to add multiple datasections onto a report.  I need it to be some thing like this.
Page Header
Detailsection 1
Detailsection 2
Page Footer

I want the detail sections to be seprate from each other.  I tried the copy paste trick that does not work.

Any help would be great.

Thanks,
JM
Steve
Telerik team
 answered on 28 Aug 2008
4 answers
284 views
I am wondering if Telerik Reporting can perform this particular task that I want to achieve.

This the case when in the end I need to print out a few documents. Instead of having a few reports, I want to have it all in 1.

I want to have 2 templates in 1 report. As a case, I want to have a contract template and invoice template in 1 report. Each on 1 page itself. When after keying in customer information, I want to see the preview of the contract and invoice on the 1 reportviewer. Meaning that I will have 2 pages for my report. 1st page is the contract and 2nd page the invoice.

I have no idea on whether this can be done and if can how?
Eugene
Top achievements
Rank 1
 answered on 28 Aug 2008
3 answers
155 views
We've recently upgraded our reports from 2007 Q2 to 2008 Q2.  We also upgraded from VS2005 to VS2008.  One conversion (or possibly a combination of the two), resulted in some of the report fields overlapping.  We corrected this but now the headings that should be black appear as light grey.

Please note the following:
  • The column headings (correctly) appear black in the VS Designer pane.
  • This headings appear grey in the VS Preview pane as well as when deployed on the web.
  • I updated the header styles to black several times, to no avail.
  • Changing a heading to another colour or font works fine.
  • Changing the heading back to black results in a grey heading.
  • The data in the report correctly appears black.
  • The reports that didn't require field adjustment are fine.
Could it be interpreting black as some kind of 'default'?

How can we get the column headings to be black?

Svetoslav
Telerik team
 answered on 28 Aug 2008
6 answers
579 views
Hi, I have simplified the report down to bare constituents to try and explain the issue and the report layout is as follows;
No Page Header or Footers
A Group : Grouping =Fields.Name
A Group Header :  Visible = false
Detail  : Visible = false
A Group Footer : Visible = true
   TextBox Value :  =Fields.Name
   TextBox Value :  =Sum(Fields.[aValue])

There are 10 records all with same Fields.Name and the report shows one line in A Group Footer ok as expected, this also PDFs ok

If you elect to Export to CSV then you have 10 entries in the csv file all with identical values Fields.Name & Sum(Fields.[aValue])

I would've only expected to see one line in the CSV, could you explain if this is by design or an issue you can address?

Not wanting to confuse the csv issue but try exporting to Excel with another 5 records with different Fields.Name to previous 10 records.  The first line is OK but the second line only has the Fields.Name, the Sum(Fields.[aValue]) is blank.

Many thanks
Martin
Martin P
Top achievements
Rank 1
 answered on 27 Aug 2008
1 answer
169 views
I have a simple report with:
GROUP A Header
    GROUP B Header
            Data
    GROUP B Footer
GROUP A Footer  

No matter what I do GROUP B will not keeptogether 
Sometimes I get just the header at the bottom of the page and on the next page 1-2 detail line and a footer, sometimes I get enerything but the footer which is on the next page.
I am sure it is something simple that I am missing.
I have tried every combination of header, footer, detail keeptogether that I can think of.
Steve
Telerik team
 answered on 27 Aug 2008
Top users last month
Simon
Top achievements
Rank 2
Iron
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Marco
Top achievements
Rank 4
Iron
Iron
Iron
Grant
Top achievements
Rank 3
Iron
Iron
Iron
Kao Hung
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?