When developing complicated reports, we could use many variables to control conditional styles as well as to display different images based on different conditions. Is there a clean way to handle these situations without using variables? This document is intended to provide a method to display images and styles without using variables. See sample screen below
The design view is attached here
Please download report specification for detail review.
Display different images
Use variables
- Define a query and a variable
- Assign variable to the image
- Select image URL based on variable values
Not using variables
- Define the same query with image URL data item
- Directly assign URL source to dataitem
Comment: The approach of not using variables is preferred, as it is much more clear process and report is much better organized, especially for complicated report.
Alternate shading
Use variables
- Define a query item
- Define a variable
- Assign style variable to list column body
- Select variable values and make silver background
Not using variables
- Define the same query
- Highlight column body and define a conditional style
Comment: The approach of not using variables is preferred, as it is much more clear process and report is much better organized, especially for complicated report.
No comments:
Post a Comment