Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 267 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Blank lines in RDLC reports
andySOLTEC
Member Posts: 36
I have been working for a number of weeks on chaning the base reports such as invoices and orders to match my customers current stationery.
On many of these reports I have encountered empty lines at the end of a table, this can usually be removed by simply hiding the row based on the content of a field, however when you also have empty rows mid-way through the data this causes major problems.
I am currently working out a total within the C/AL code and trying to output this to the report, however it comes through with an empty value as the last one, preventing me from using Last() to get the value I want.
I have used SQL Profiler to confirm that there is no blank entry at the end of the dataset, I have also run the basic Classic report and confirmed that it does not print an empty line. It seems this only happens when using the VS designer ](*,)
Has anyone else encountered this, and/or knows a way to stop this happening? [-o<
Regards
Andy
On many of these reports I have encountered empty lines at the end of a table, this can usually be removed by simply hiding the row based on the content of a field, however when you also have empty rows mid-way through the data this causes major problems.
I am currently working out a total within the C/AL code and trying to output this to the report, however it comes through with an empty value as the last one, preventing me from using Last() to get the value I want.
I have used SQL Profiler to confirm that there is no blank entry at the end of the dataset, I have also run the basic Classic report and confirmed that it does not print an empty line. It seems this only happens when using the VS designer ](*,)
Has anyone else encountered this, and/or knows a way to stop this happening? [-o<
Regards
Andy
0
Comments
If you are calculating a total on the footer section in the classic then this value will not be shown on the SSRS
the total value has to be set as hidden text field in the body of the classic report design. If this value will be shown on the footer of the SSRS then, set this value on the body section line of the SSRS namesd TxtTotal with value.
on the footer text box set value ReportItems!TxtTotal.value.
vasilis