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.
Hi,
Use a HTML item in the prompt page. and write java script to validate the text box.
Cheers
JO
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.
can u explain me briefly, what is there in prompt page and report page. and also explain ur requirement.
JO
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.
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.