XL Reporter - Selection of date range for report templates

[Former Member]

Dear All,

I want to create a report using XL reporter and attach it to the main SAP B1 reports module . For this I have created the template using report composer .

Issue:

I have only one sub-period (ie,year wise in the posting periods)

how i can select the date range in the Composer and attach it to the main menu.

Regards,

Suresh Kannan.P.

[Former Member · Accepted solution]

Hi Suresh,

Create two parameters. one parameter is for "From Date" and other one is for "To Date". U r problem will solved.

Thanks,

Suresh Yerra.

[Former Member · Accepted solution]

Hi,

Can u please explain that parameter window .

Any problem on that i have choosen the sub-period type as year.

Please help me in this regard.its very urgent

Thanks & regards,

Suresh Kannan.P.

[Former Member · Accepted solution]

Suresh,

1. Goto Report Designer

2. there u can find "Advanced Report Builder" on left side of the window

3. At the below u can find three buttons like "Parameters", "Properties","Apply"

4. Click on "Parameters"

5. then Parameters window will populate

6. Click the new Button

7. Name: give as u like

Category: Literal

Type: Date

Attribute: Leave blank

Default Vale: Leave Blank

Prompt: From Date

This is the process to create the parameters.

create two parameters. one is fdate and ldate.

[Former Member · Accepted solution]

Hi,

I tried this and i have choosen the date range also.

But everytime the report is da same.It is not considering the date.

Why it happening?

Any other settings we have to do.

Thanks & Regards

Suresh Kannan

[Former Member · Accepted solution]

Suresh,

After creating the parameters,

In Advanced Report Builder u can find "Transaction Row"

In that Transaction Row u can find ... button

click on then u can find one window

there select "parameters tab"

At the below u can find "selection"

select the required attribute on which u want to make selection.

Thanks,

Suresh Yerra