Search found 3 matches
- Fri Jul 06, 2012 9:54 am
- Forum: R&R ReportWorks Users
- Topic: Finding difference b/w values stored in same database field
- Replies: 1
- Views: 2002
Finding difference b/w values stored in same database field
I need to create an expression to find the difference between two time values which are stored in the same field in a database table but different record lines. There are two records which represent the same transaction at two different points in time, and I need to know how long it took to get from...
- Wed Sep 24, 2008 8:32 pm
- Forum: R&R ReportWorks Users
- Topic: Totals on summary line
- Replies: 1
- Views: 1548
Totals on summary line
We have a customer who tracks shipments of products by ton. They are requesting a report that will show totals for each customer in the following format:____Customer Month of September 08 YTD Last 12 Months 07 Total__AAA__ABC__Acme__BBB____I am able to create expressions for the "Last 12 Months...
- Tue Sep 23, 2008 8:32 pm
- Forum: R&R ReportWorks Users
- Topic: SQL DB Access error
- Replies: 1
- Views: 1642
SQL DB Access error
When generating a report from an SQL table called "scale" we receive the following error:____"DB access: [Microsoft][ODBC SQL Server Driver][SQL Server] The column prefix _scale_ does not match with a table name or alias name used in the query. [Microsoft][ODBC SQL Server Driver][SQL ...