RDLC Report Design Problem

Jatin_Patel
Member Posts: 200
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.
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
Microsoft Dynamics NAV Consultant
Jatin's Blog
0
Answers
-
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
India0 -
Thanks Brijesh,
i Solved my problem with help of your solution.Jatin Patel
Microsoft Dynamics NAV Consultant
Jatin's Blog0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions