RDLC Report Design Problem

Answers

• Options

  brijeshvaidya Member Posts: 50

  2010-08-27

  Hi.
  I am converting classic reports to RTC in NAV 2009 sp1.
  but i am facing some problems.
  
  
  1 - In one report when i run from classic client than i get one report with two copy on different page with same record
  
  
  but
  
  in RTC i get same record two times on one page.
  
  i want to display it on two different page in RTC?
  Answer 1-> use page break for that,
  
  take one table with grouping on the field, that u want to start on next page,
  
  and in the grouping property, tick on the "page break at end".
  
  2 - Can't get company logo on RTC report?
  
  answer 2->
  for company logo there is two simple steps
  
  step1-> -in the classic report, go to header section and take one picture box,
  -take global variable of the company information table's record variable
  -in the OnInitReport() trigger
  write this code:-==>>
  if CompanyInfo.GET then
  CompanyInfo.CALCFIELDS(Picture);
  -in the picture box, set the property SourceExpr= CompanyInfo1.Picture
  -now set the picture box property DataSetFieldName =CompanyInfo1_Picture
  -set the name of text box =companyInfotextboxname
  
  -save and compile the classic report.
  
  Step 2
  ->goto the rdlc layout of your report using
  alt+V+Y from classic report designer
  
  -now take the texbox with the value
  =Convert.ToBase64String(Fields!CompanyInfo_Picture.Value)
  
  - in the reort header take one image
  - set the impage property source= database, and mimetype= image/jpg or bmp what is your image type is.
  - set the value property of image >>>=Convert.FromBase64String(ReportItems!companyInfotextboxname.value)
  
  -save and build the solution
  
  
  
  
  
  
  
  
  3 - i write header in table but i cant get it when i run RTC report?
  
  I also try to write in report header also but i cant get it.
  
  so what i have to do to display table header in RTC on each page?
  
  answer 3-> to write header manually it will not work..
  
  - for that u have to take header detail in the classic client and then
  take the datasetfield name of all ...
  
  now come to rtc report and take all fields!header1.value.., 2.vale... and so on..
  put all header detail in the table header... not in the report header..

  Brijesh Vaidya
  Sr. Software Engineer
  India

  0
• Options

  Jatin_Patel Member Posts: 200

  2010-08-31

  Thanks Brijesh,
  i Solved my problem with help of your solution.

  Jatin Patel
  Microsoft Dynamics NAV Consultant
  Jatin's Blog

  0