A SQL-based Quick Report's user-prompt parameter (like `&DATE_FROM`) shows its raw underscore-separated name as the on-screen label ("DATE_FROM") instead of a friendly label like "Date From" — replacing the underscore with a space directly in the database-side bind variable name fails when run through the client.

All FAQ questions / Reporting and analytics

Answer

The bind-variable name itself can contain spaces and still work correctly when used consistently throughout the query — for example, referencing '&Date From' (or '&To Date') as the bind variable directly in the WHERE clause, rather than trying to rename an existing underscore-style variable after the fact, produces exactly the friendly label you'd expect on the parameter prompt, since the parameter label shown to the user is generated directly from however the bind variable itself is named in the SQL.

Documentation-based answer. Confirm the product and release before applying it. This answer has not been verified in an IFS environment.

← Browse Reporting and analytics questions