Data not showing in a single row on the Trend Log Comparison Report

[Product_Support]

Issue

Data not showing in a single row on the Trend Log Comparison Report

Creating Custom Reports

Environment

Report Builder 3.0

Struxureware Building Operation WebReports

Cause

Trend sample data is stored in the Reports Server at a resolution of less than 1 second. In some cases the user wants to compare data in showing less resolution than what is in stored in the database. 

Resolution

1. Open Microsoft Report Builder and Edit the existing Trend Log Comparison Report.  You can get detailed instructions on how to perform this task on the online help guide.
2. Scroll to the bottom and select the DateTimeStamp Field in the Second Tablix object.
   
3. Click on the drop down menu in the Row Groups pane and select Group Properties
   
4. On the General Tab, click on the Fx button
   
5. Change the Expression to say: =FORMAT(Fields!DateTimeStamp.Value, "dd MM yyyy hh:mm")
   
6. Repeat this for the Sorting Tab. Enter the same Expresssion. =FORMAT(Fields!DateTimeStamp.Value, "dd MM yyyy hh:mm")
   
7. Click OK to save changes.
8. Right click on the DateTimeStamp TextBox and select Text Box Properties.
   
9. In the Number tab, change the default format to the desired display format
   
10. Perform a Save AS to ensure you do not overwrite the factory supplied report. 
11. Follow the instructions on web help to allow the modified report to be used in WebReports.