Reporting

[Willinger, Norm]

I have been tasked with creating a report from BridgeWorks data and I need help pulling it out of the application.  I need to pull Inspections planned, date planned, inspections completed/submitted and their dates, and the inspection hours spent. 

If possible, we would like to pull the data without running a report through BW, but by querying the data directly.  Is that a possibility?  Is there a reporting tool which will allow us to save reports?

Thanks a lot!

Norm Willinger
Information Systems Coordinator
1300 Franklin, Suite 185
Vancouver, WA 98660
360.397.6118 x4503

Please consider the environment before printing this e-mail

---

This e-mail and related attachments and any response may be subject to public disclosure under state law.

[Michael B. Erickson]

There are a series of views that begin with "viewAdHoc_tbl" that are provides current information for each structure. The one in particular that should provide the information you need is "viewAdHoc_tblInspectionsPerformed", which provides the current inspection performed data for each structure. To look at historical data, you have to use one of the views that begin with "viewAdHoc_history_tbl".

 

I hope this helps.

--
You received this message because you are subscribed to the Google Groups "Bridge Works .NET Support" group.
To post to this group, send email to bridge-works...@googlegroups.com.
To unsubscribe from this group, send email to bridge-works-net-s...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/bridge-works-net-support?hl=en.

--
Michael B. Erickson
Erickson and Associates
PO Box 60021
Renton, WA  98058
Phone: (425)269-8106
email: Mic...@MErickson.com
web: http://www.MErickson.com