The above illustrates a report where the actual table is less than 16 cms but the report width is not. You will still get extra blank pages when you print this or export to PDF. Make sure therefore that there is no extra space after the table on the right ( if not needed ).
The other way to control the report width is on the Report Properties Tab.
This is a useful window, lots of properties to set here
The above image shows the same report exported to PDF after the change is made. Easy as pie…….
You can also :
- Use Parameters or static fields instead of fields from the dataset ( This applies to most functions )
- Change the "d" ( which means compare days ) to "M" or "yyyy"
If it doesn’t work , remember that the values you are comparing must be date values. Use "CDate" to convert strings to Date values.
And remember , when you want compare a date to todays date , getdate() won’t work, since this is VB Script not SQL !! Use the Now() command as follows :
If the first date is smaller than the second date , the difference will be a positive number. You need to remember this since normally your expression for conditional formatting is normally something like :