0

When I create a report view, cognos is trimming the spaces of the value of each prompt. Then, when I try to run the report view, Cognos can't bind the saved values with the prompt values.

How can I solve this issue?

Thanks!

Agus Vago
  • 3
  • 2
  • Are you saying your database legitimately and deliberately stores values with leading or trailing spaces? ...and the Cognos report view is not saving what you actually entered as prompt values? – dougp Mar 01 '19 at 20:01

1 Answers1

0

As a suggestion change the filter by having the field trimmed as well as the parameter

For example, Detail filter would be: trim([Customer Name]) = trim(?PromptName?)

JeremyW
  • 5,157
  • 6
  • 29
  • 30
VAI Jason
  • 534
  • 4
  • 14