Hello,

I am doing a feasibility study of using Seal reports for our project as reporting tool. I am struggling to find a way, where i can pass the value to a column in oracle which is a DATE type.

1. I have dragged the date column in the 'Restrictions and Aggregation' section
2. In the Definition section i have selected Operator as 'Between'
3. In the Restriction values section i have tried all the combinations ..i need to filter the data on current date i.e Sysdate in oracle.

When i type in Sysdate and tab out i get an error message that => Property value in is invalid. Invalid numeric value Sysdate.

Tried to work around the error by going to Advance section and change the dataype from Default to Date & time.
I have tried using Today from the dropdown when of Value 1 Keyword.

This allows me to go ahead ..but when i run the report ..i get an error Ora -01843 Not a Valid Month.

please help ..to resolve this problem,...thanks

--
Regards,
Kuldeep

Thank you very much for your quick response.

I have followed the steps provided by you and have moved a bit further. I still have couple of questions for which I would need your help.

1. I have selected a Date datatype Column in the Restrictions section. For this restriction I have set Prompt Restriction as Prompt at Execution.
2. When i run the report, I am prompted for the Date value ...which i am able to pick from the Calander control.
3. When i select the required date and when the date is displayed on the box(area from where its picked to filter the data in the table) I see that the date format is mm/DD/yyyy.

Please suggest how can i change it to dd/mm/yyyy or any other format.

My other problem is with the ora error i get while running the report...
1. I can see in the SQL view...that the restricted field is shown as 1=1..looks like a palce holder for runtime value substitution
2. Due to this when the value is picked at runtime...the Where clause becomes as follows:
Date_col = ('08/09/2015 00:00:00')
3. Due to this i get an oracle error that ORA:01843 : not a valid month

This proble will go off if the WHERE clause is replaced as follows:
Date_col = to_date('08/09/2015 00:00:00', 'dd/mm/yyyy hh:mi:ss')

Please suggest how i can make Seal report to actaully have a date value prefixed with the TO_DATE oracle fuction.

If there is another way of filtering data based on oracle dates ..please suggest that..I am ok with any solution.

Thanks in advance.

regards
Kuldeep

Thanks again ....

I have tried a simple report with Date datatype in the Restriction field...and as per your instruction it works fine...

I have realized that the column i am using is actually a Timestamp datatype.

In the connection section i have Oracle and date format as mentioned by you as 'yyyy-mm-dd hh24:mi:ss.

any clue ...on what needs to be done for timestamp data type column ..coz i am getting problem ..when using Keyword Today and fetching teh records.

I have tried what you have mentioned in your test too....there too i have set column data type as Date & Time.

regards

Perfect solution ...i am now having a hang of the way Seal reports works..
Thanks for the solution.

Something which i have noticed and would like to bring to your notice too...
When we select a date from the calander control to populate the value for date on which we want to filter the rows...then as we pick the date ..its displayed in mm/dd/yyyy format ..and after the report is fetched ...it changes the format thats defined in the report manager.

Thanks again for the solution on how to filter data on a oracle timestamp column

regards
kuldeep

Hi, can you make a new post ?
Your question is not clear at all, can you explain it again ?