topic Re: Report help for multiple Date Select options in Application Development and Automation Discussions

Report help for multiple Date Select options

Former Member — Tue, 30 Jun 2009 05:33:21 GMT

Hi Friends,

For a particular year wise report, the client wants 12 date select-options which are changeable and informal every year .The report will also be displayed as per the given date selection period wise. Please help me how to fetch the datas from the table as per the given selection period. Currently the report have one date select-option where the user gives selection range as 1.04 to 31.03. It's related to EB power consumption report and hence the new requirement on date selection which are informal and not a fixed date of every year.

Ex:Selection-Screen

Period 1 : 08.04.2008 to 12.05.2008

Period 2: 12.05.2008 to 20.06.2008

Period 3: 21.06.2008 to 28.07.2008

Period 4: 29.07.2008 to 15.08.2008

Period 5: 15.08.2008 to 21.09.2008

Period 6 : 21.09.2008 to 14.10.2008

The data will derive as per the above selection ranges.......

Please advise with example.

thanks & regards

Sankar.

Re: Report help for multiple Date Select options

Former Member — Tue, 30 Jun 2009 05:39:35 GMT

Just define the selection-screen with the appropriate Logical data base.

then Conider Pn-begda : Low value

Pn-endda.:high.

Then consider

select querry * where date1<= pn-begda and date2 >= pn-endda.

Hope this helps....

regards

sas

Re: Report help for multiple Date Select options

Former Member — Tue, 30 Jun 2009 05:40:44 GMT


> Ex:Selection-Screen
> Period 1 : 08.04.2008 to 12.05.2008
> Period 2: 12.05.2008 to 20.06.2008
> Period 3: 21.06.2008 to 28.07.2008
> Period 4: 29.07.2008 to 15.08.2008
> Period 5: 15.08.2008 to 21.09.2008
> Period 6 : 21.09.2008 to 14.10.2008

Hi,

In this case just derive all records matching dates between 08.04.2008 (low in first select-options) and 14.10.2008(high in last select-options.

Also my advice is to use a single select-options and prompt the user to give the dates as ranges in the multiple entries dialog which can be opened by clicking the button on the right side of the select-options.

Regards

Karthik D

Re: Report help for multiple Date Select options

Former Member — Tue, 30 Jun 2009 05:43:29 GMT

thanks for your prompt reply.

But , the user can also take the report by giving only one date selection or two or three as like month wise report. So as u said, here the date selection pn-endda-high will differ and not knwon at the time of select command. How to derive it in this scenario.

please advise.

regards

sankar.

Re: Report help for multiple Date Select options

Former Member — Tue, 30 Jun 2009 05:48:03 GMT

Then use a single select-options and ask the users to enter the select ranges in the multiple selection dialog.

Just use as usual in query as IN s_date.

Regards

Karthik D

Re: Report help for multiple Date Select options

Former Member — Thu, 26 Aug 2010 10:30:11 GMT

Solved