report wise List Box Filters

[vinod2086]

Hello

i have created one report in that report am using 2 sheets. for example i hv created status report i have used two sheets one is for closed and one is for pending status report.

am using straight table i have applied condition it displaying separately that's fine. but when i select the list box by default it displaying all values here i don't want to display for closed report status list box should display only closed, closed by l1 and so on..

same as pending report

STATUS
closed
closed by l1
closed by l2
closed by l3
closed by l4
pending
pending from L1
pending from L2

is it possible.?

Thanks in advance.

[mrossoit]

Hi,

I'm not sure to understand what you really want.

Have you tried to cycle report's page on closed by field?

If page 1 shows straight table containing closed status' records, you could go to Page's settings -> Union and cycle by "closed by" field.

Same for page 2 (that I suppose contains straight table showing pending status' records).

As alternative, upload your qvw so the problem will be clearer, please.

Regards

MR

[sunilkumarqv]

in listbox expression

=If(status,wildmatch(status,'closed*'))

then it gives only closed related fields in listbox

same way you can create pending listbox if you want

=If(status,wildmatch(status,'pending*'))

[vinod2086]

Hi Sunil,

i have tried above expression but list box displaying all values.

[sunilkumarqv]

sorry for the prev one

this is the write one

Check the attach

its working for me ..

=If(WildMatch(Status,'closed*'),Status)

[vinod2086]

sorry sunil still am getting all data...

[sunilkumarqv]

can use share sample data

[vinod2086]

hi sunil pls find attached app !

[jagan]

Hi,

Try like this

LOAD

*,

If(WildMatch(Status, '*closed*'), Status) AS ClosedStatus

FROM DataSource;

Hope this helps you.

Regards,

Jagan.

[sunilkumarqv]

I didnt see any app