[mwilliams]

There were some major changes between 2.3 and 2.5, I believe, so some reports will not open when created in 2.3 and opened in a newer version. That's probably the reason you're unable to open the design. I'll just make a new one. So, you've got a start date and an end date and you want the user to be able to either select to enter a date or select to pass a null value, which will return all dates? Is this correct? Let me know and I'll make an example.

[ocremedios]

Michael,
Thanks for the reply and you are correct about the date parameter thing. Appreciate your help

[mwilliams]

Ok. Take a look at this report. If you run it in the web viewer, be sure to add the URL parameter &__parameterpage=true.

Attached File(s)

•  RunReportForAllValuesIfParametersNull.rptdesign (18.05K)
  Number of downloads: 5

[ocremedios]

I am getting an error on the report i have attached the report would really appreciate your help.
Oscar

Attached File(s)

•  zone vandalism.rptdesign (41.42K)
  Number of downloads: 3

[mwilliams]

What is the error? Can you post the error stack in here? Thanks!

[ocremedios]

The error is
"The following items have errors:


Table (id = 11):
+ Can not load the report query: 11. Errors occurred when generating the report document for the report element with ID 11. "


Thanks

[mwilliams]

Can you click the '+' sign and post the entire error stack? Thanks!

[mwilliams]

Do your query results show up under preview results in the dataSet editor? Also, what is the scenario in which you receive that error? With the date parameters empty, with parameters entered, or both?

[ocremedios]

My results show up under the preview results dataSet editor. I receive the error in both scenarios with parameters entered and with data set empty.
No idea what i am doing wrong here, done exactly what you have in your example.

[mwilliams]

Can you expand the error by clicking on the '+' and post the error stack in here? Thanks!

[ocremedios]

I got it working something to do with the BIRT version i use. When you make changes to the data set it throws thar error no idea why had to re do the report.

Thank you,
Oscar

[mwilliams]

Hmm. Well, glad you got it working! Let us know whenever you have issues!

[ocremedios]

Now since you have asked i have a question, i want to know how do i get a calendar to pop up on date parameters so customers can select the date instead of typing/writing it in.
Is it something simple or involves a lot of javascript?

[mwilliams]

Sorry for the delay. Take a look at this devShare post:

http://www.birt-exch...get-to-reports/

Hope this helps.

[AnnibalS]

mwilliams, on 01 June 2012 - 08:07 AM, said:

Sorry for the delay. Take a look at this devShare post:

http://www.birt-exch...get-to-reports/

Hope this helps.

Good morning, mwilliams.

I'm trying to use the datatime param but the following error occours:

The following items have errors:


Table (id = 10):
+ Cannot execute the statement.
SQL statement does not return a ResultSet object.
SQL error #1: The syntax of the string representation of a datetime value is incorrect.


My script used is:

if (params["PARAMDATETIME"].value!=null){
this.queryText = " select XXX.PRODUCT.ID_PRODUCT, XXX.PRODUCT.NAME, XXX.PRODUCT.MARCA, XXX.PRODUCT.DATE_VALIDADE"+
" from XXX.PRODUCT" +
" where XXX.PRODUCT.DATE_EXPIRED<='"+params["PARAMDATETIME"].value+"'";
} else {
	this.queryText = " select XXX.PRODUCT.ID_PRODUCT, XXX.PRODUCT.NAME, XXX.PRODUCT.MARCA, XXX.PRODUCT.DATE_EXPIRED "+
" from XXX.PRODUCT";
}

I inserted the following values for it, but occours error above:
- 13-09-2012 09:22:49.001-0300
- 2012-11-10 00:00:00.000
- 2012-11-10 00:00:00
- 2012-11-10 00:00
- 12-11-10 00:00
- 11-10-2012 00:00
- 11-10-12 00:00
- 10-11-2012 00:00
- 10-11-12 00:00

Could you help me, please?

Thanks.

[mwilliams]

What format is PRODUCT.DATE_EXPIRED, in your dataSet?

[Rajesh Kakawat]

Use same format in which your date is stored in database

[AnnibalS]

mwilliams, on 13 September 2012 - 01:46 PM, said:

What format is PRODUCT.DATE_EXPIRED, in your dataSet?

I add into "Report Parameters" how "Date Time" format.

In may database the column is Timestamp.

[AnnibalS]

AnnibalS, on 14 September 2012 - 07:17 AM, said:

I add into "Report Parameters" how "Date Time" format.

In may database the column is Timestamp.

I no longer need the datetime parameter.

Thanks for help.

[mwilliams]

Ok. Let us know whenever you have questions!