Search found 3 matches

by JB429
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: 1872

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...
by JB429
Wed Sep 24, 2008 8:32 pm
Forum: R&R ReportWorks Users
Topic: Totals on summary line
Replies: 1
Views: 1499

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...
by JB429
Tue Sep 23, 2008 8:32 pm
Forum: R&R ReportWorks Users
Topic: SQL DB Access error
Replies: 1
Views: 1572

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 ...