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?
2 - Can't get company logo on RTC report?
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?
Thanks.
Jatin Patel
Microsoft Dynamics NAV Consultant
Jatin's Blog 0
Answers
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..
Sr. Software Engineer
India
i Solved my problem with help of your solution.
Microsoft Dynamics NAV Consultant
Jatin's Blog