Skip to Content
avatar image
Former Member

SAP B1 CRYSTAL REPORT DATE RANGE PARAMETER IN SQL MODIFY COMMAND

Hi Experts,

How to make a date range parameter in sql modify command? I have already created the report but It seem a have difficulties In making a date range parameter. So This is what I made.

First:

I made two Parameter List in the modify command named DateFrom@ and DateTo@ value type 'DATE' and Default Value '9/1/17'(DateFrom@) and '9/31/17' (DateTo@).

Second:

I Inserted the parameter list in my sql query as "T0.DocDate Between {?DateFrom@} and {?DateTo@}"

Then I run the report. It Generate fine but It only appears that the showing parameter is the default value that you set. No Date Picker appeared only the Default Value.

Third:

I Created A token like this 'SELECT Distinct DocDate FROM OINV UNION ALL SELECT Distinct DocDate FROM ORIN' But It Didn't work at all Can Click the parameter no showing to pick!

Fourth:

I only made a token like this 'SELECT Distinct DocDate FROM OINV' Now I can see a list of date but when I generate It. I think It didn't get the AR Credit memos date bec. of the token only showing the dates of invoices.

Note: I only made this procedures because I have no field date In my query.

Question:

How can I make a parameter list in the modify command like a date picker? And Is it possible? If not what work around should I do?


here the link for the rpt if you want to view.

https://www.dropbox.com/s/937oqtpqfjryu50/Gp.rpt?dl=0

I hope you can help me experts

Very Much Thanks In Advance.

Best Regards,

Socrates Ariola

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers