Users want to enter more than 20K lines into Prompt

[RMSReddy]

Hi,

I have a detail report which has 'Serial no' as the unique identifier. Users want to copy and past some of the serial numbers from an already saved data elsewhere into a prompt of this report and see the detail output.

I have provided them with a "Text box prompt" and changed properties to Multi-Select and Multi- Line. We are using 10.2.
Users sometime query for about 1000 Serial no's and that function works fine. But they would sometime have to do it for about 20K serial's (i.e 20K lines). The report doesnot give any output.

Any Suggestions of alternates? They have this function in a VBA report they are using and need to replicate the same in Cognos.

Please Help!!!! long pending issue...need to close.

[adam_mc]

What is your underlying database?

We have Oracle and I believe Oracle has a 1000 entry limit on the number of entries in the associated IN statement that is created.

Hope this helps.
Adam.

[RMSReddy]

It is  SQL database. I am able to filter the report to a max of 3948 lines. If enter even 1 serial number more the 3948number, the report output is blank.

Is there a JavaScript Code or anything to increase the number of input lines for a TEXT BOX Prompt? or any other way to provide this input to the Cognos query for filtering?

[BigChris]

Link your report to an excel spreadsheet (you'll need to create the accompanying package) and get the user to put the serial numbers into that.

[bdbits]

If at all possible, I would look at getting the data into the warehouse and joining the data. I do not mean to offend, but this seems like a giant kludge to me.

[BigChris]

No offense taken - I was just trying to offer a quick and dirty workaround...

[RMSReddy]

Link your report to an excel spreadsheet (you'll need to create the accompanying package) and get the user to put the serial numbers into that.

Thanks for you reply, Do you have document of how to achieve this....

[Lynn]

I think Chris is referring to the External Data feature but your file may exceed what is permitted. I agree with bdbits that addressing the requirement by getting the data into the warehouse is a better approach.

http://www-01.ibm.com/support/docview.wss?uid=swg21474174