Data Access Worldwide Forums - Reports https://support.dataaccess.com/Forums/ Creating reports, forms, data-driven documents for screen viewing, printing, file and PDF output. DataFlex Reports are easily integrated with your Windows, web and mobile applications. en Wed, 15 Jul 2026 09:50:53 GMT vBulletin 60 https://support.dataaccess.com/Forums/images/misc/rss.png Data Access Worldwide Forums - Reports https://support.dataaccess.com/Forums/ DR 25.2 - SQL Error in datasource wizard when using SQL Statement https://support.dataaccess.com/Forums/showthread.php?73380-DR-25-2-SQL-Error-in-datasource-wizard-when-using-SQL-Statement&goto=newpost Tue, 07 Jul 2026 17:13:52 GMT SQL Server backend. ODBC driver. Was able to use the same db , using regular tables just fine. This time I tried to base the report in a SQL... SQL Server backend. ODBC driver.

Was able to use the same db , using regular tables just fine.

This time I tried to base the report in a SQL Statement , after providing the SQL Statement Text, added it to the list of tables, when clicked next, in the link page, I get an error.

DR25_SqlStatement_Error.png

HY090 - Invalid String or buffer length

The statement works just fine either in DF SQL Executor, or in MSSSQL Studio.

Code:
SELECT
  COALESCE(CCGD.RMCycleID, CCLD.RMCycleID) [RMCycleID],
  COALESCE(CCGD.ItemCode, CCLD.ItemCode) [ItemCode],
  ISNULL(CCGD.NumOfGaylords, 0) [NumOfGaylords],
  ISNULL(CCLD.NumOfLocations, 0) [NumOfLocations],
  (ISNULL(CCGD.Gaylord_Initial_Weight, 0) + ISNULL(CCLD.Location_Initial_Weight, 0)) [Initial_Weight],
  ISNULL(CCGD.[Gaylords_Counted], 0) [Gaylords_Counted],
  ISNULL(CCLD.[Locations_Counted], 0) [Locations_Counted],
  (ISNULL(CCGD.Gaylord_Final_Weight, 0) + ISNULL(CCLD.Location_Final_Weight, 0)) [Final_Weight]
 FROM CCGD FULL OUTER JOIN CCLD ON CCGD.RMCycleID = CCLD.RMCycleID AND CCGD.ItemCode = CCLD.ItemCode
the only string/varchar column is the second one. all others are either integer or decimal types.
Attached Images
]]> Reports Samuel Pizarro https://support.dataaccess.com/Forums/showthread.php?73380-DR-25-2-SQL-Error-in-datasource-wizard-when-using-SQL-Statement Order https://support.dataaccess.com/Forums/showthread.php?73375-Order&goto=newpost Sat, 04 Jul 2026 23:18:21 GMT Hi all How do you arrange the months? Edgar Hi all

How do you arrange the months?

Edgar
Attached Images
]]> Reports Edgar H. Peņa C. https://support.dataaccess.com/Forums/showthread.php?73375-Order What is the token for a datetime/timestamp datatype to use in DR formula language ? https://support.dataaccess.com/Forums/showthread.php?73373-What-is-the-token-for-a-datetime-timestamp-datatype-to-use-in-DR-formula-language&goto=newpost Thu, 02 Jul 2026 18:31:59 GMT Want to suppress dummy datetime values in report. Was not able to find anything in DR help on how to work with this type. only found stuff for... Want to suppress dummy datetime values in report.

Was not able to find anything in DR help on how to work with this type. only found stuff for dates or time isolated, but not datetime/timestamps values. !?

How can I compare in DR built-in language a datetime column value ?

I miss a datetimeserial() function for this ..

{someDateTimeColumn} = '????'

ISO format? yyyy-MM-dd HH.mm.ss.nnn ?

Please don't tell me that this depends on Windows regional settings.. ! ]]> Reports Samuel Pizarro https://support.dataaccess.com/Forums/showthread.php?73373-What-is-the-token-for-a-datetime-timestamp-datatype-to-use-in-DR-formula-language DF 25.2 - Subreport page header ? https://support.dataaccess.com/Forums/showthread.php?73372-DF-25-2-Subreport-page-header&goto=newpost Thu, 02 Jul 2026 17:56:10 GMT Why a subreport does not have a page-header ? My subreport span several pages. It has captions headers that should be displayed on each page,... Why a subreport does not have a page-header ?

My subreport span several pages. It has captions headers that should be displayed on each page, otherwise you loose context , users don't know anymore what each column means !

How to achieve that ? ]]> Reports Samuel Pizarro https://support.dataaccess.com/Forums/showthread.php?73372-DF-25-2-Subreport-page-header Pass static Validation Descriptions to Report - ODBC source https://support.dataaccess.com/Forums/showthread.php?73368-Pass-static-Validation-Descriptions-to-Report-ODBC-source&goto=newpost Tue, 30 Jun 2026 17:28:56 GMT ODBC based report.. so can't use RDS to pass an static (hardcoded) Validation table descriptions using RDS.

What are other options ?


----
Side note. (To Vincent)

Tried to Create a new RDS table in a ODBC based report.
The interface (Database Expert) allowed me to define the new RDS table, but I can't add it to the report.
It complains only one datasource type is allowed, and odbc is already being used.

Fine, but now I can't remove this rds definition from the report. Can't find any option to do it in Database Expert dialog. Is there any place ? or this report will have to live with that garbage for the rest of its life ?

And why it would allow me to define a rds table if it won't let me to use it !? ]]> Reports Samuel Pizarro https://support.dataaccess.com/Forums/showthread.php?73368-Pass-static-Validation-Descriptions-to-Report-ODBC-source Ambiguous Column Name https://support.dataaccess.com/Forums/showthread.php?73353-Ambiguous-Column-Name&goto=newpost Tue, 23 Jun 2026 13:17:15 GMT Hi - DR 25.2. New RDS report that I am building - no integration yet, just sample data in the report. What does this mean? There is only one... Hi -

DR 25.2. New RDS report that I am building - no integration yet, just sample data in the report. What does this mean? There is only one column in any of the tables named BatchDateFrom.

ambiguous.jpg

ambiguous2.jpg

Thanks
Attached Images
]]> Reports Garret Mott https://support.dataaccess.com/Forums/showthread.php?73353-Ambiguous-Column-Name