Problem with Text box Prompt with Multiselect

[kvchow]

Hi all,
i am getting a problem with Text Box Prompt,My User wants to enter Multiple values

I created the text box with multiselect,if my user select more than one value then the report keeps on running and throwing the query execution time out error

If i entered one value the data is populating in less than a minute

Any Help?

Thanks,
kvchow

[Lynn]

What does your filter expression look like? Is your source relational? What does the generated SQL look like?

[Raghuvir]

Hi all,
i am getting a problem with Text Box Prompt,My User wants to enter Multiple values

I created the text box with multiselect,if my user select more than one value then the report keeps on running and throwing the query execution time out error

If i entered one value the data is populating in less than a minute

Any Help?

Thanks,
kvchow

Hi,

Have you used the 'IN' operator for your filter expression ?

Regards

[kvchow]

Hi Lynn and raghuvir

My source is Relatinal and filter is having IN operator

Thanks,
Kvchow

[Lynn]

Hi Lynn and raghuvir

My source is Relatinal and filter is having IN operator

Thanks,
Kvchow

You will need to provide more information. I previously asked about your generated SQL. Did you compare to see any differences when one value is selected vs multiple values? I also asked what your filter expression looks like although you only commented that it has an IN operator without actually posting any further information on what it looks like.

Perhaps you should work with your DBA to have them monitor what is going on when you run the report with one value vs multiple.

[kvchow]

Hi Lynn,
i created a ticket and asigned to DB2 team,after 4 days i got the reply from those guys,we can't do anything from DB2 side and no need to create any index they said like that

i want to enter multiple course swith in (text box prompt) to see which one is completed with in the given date range,if i enter more than one its keep on running and giving me the query execution time exceeds more than 2700 seconds

Any idea?

Thanks,
Kvchow

[BigChris]

Hi kvchow,

Can you copy and paste your filter expression please? I imagine it's something along the lines of:

Code Select Expand

[Course Name] in ?promptCourse?

but it will help if we can see the actual text.

C