Validating in Prompt Page

[nsrajiv]

Hi All

i need help.

I have a prompt page. It has a textbox that gets the value of a column.

When I enter a valid value in that text box I get the report perfectly. When I enter an invalid value into the textbox I get the report with no records. Thatââ,¬â,,¢s fine.
But I need to Print "Invalid Input " on the report when an invalid input in given into the textbox......got it?

Any idea how this could b done?

Thanks & Regards,
Rajiv.

[JO]

Hi,

Use a HTML item in the prompt page. and write java script to validate the text box.

Cheers
JO

[nsrajiv]

thanx Jo.

iam new to cognos reportnet. can u please explain it how to do.
i have a prompt page with a "Text Item" and a "finish" button below.

how can i validate the "TextItem" on click of "finish" button.

Thanks and Regards
Rajiv.

[JO]

can u explain me briefly, what is there in prompt page and report page. and also explain ur requirement.

JO

[nsrajiv]

as already said  i have a prompt page with a "Text Item" and a "finish" button below.

how can i validate the "TextItem" on click of "finish" button.

Thanks and Regards
Rajiv.

[Merri]

Based on your original request, you have two options:
either validate the input data via javascript as previously suggested;
or accept the invalid data, let the report run, and display "Invalid input" on the report.

You can achieve the second option by using conditional formatting on a text box in the list header or footer.

• Add a text box with the text to want to display when no data is returned.
• Define a condition for a report variable as count(some query column) > 0.
• Apply the condition to the text box. Where value > 0, set box type property to None.