Hi All,
I have an html list box that i populate with say 5 digit customer numbers. I pass them to my report along with 11 other variables.
My report displays fine and on my report I have a drilldown on one column thats gives the user 2 tabs to pick from.
Now the issue. When I enter 9 5 digit customer numbers in the list box and go to the drill down in my report it works fine. If i enter a 10th customer and go the the drilldown when i click on the link it will not show me the tabs.
Does anyone have any idea what is going on.

thanks

This message has been edited. Last edited by: Kerry,

Can you post the code, or repro the problem with one of the sample files ?

HERE IS THE DRILLDOWN CODE THIS DRILLDOWN WILL NOT OPEN BUT IF I REMOVE 54824 BELOW IT WILL OPEN


$
TYPE=DATA,
COLUMN=N2,
TARGET='_blank',
DRILLMENUITEM='Show By Customers',
FOCEXEC=mi262allcustdetail( \
LYENDDATE='01/15/2008' \
LYSTRTDATE='01/01/2008' \
TYENDDATE='01/15/2009' \
TYSTRTDATE='01/01/2009' \
DEPTNAME=N2 \
PLList='1' \
CURRPLSALES='239941.75 ' \
LASTPLSALES='202268.44 ' \
CURRCOMPANY='1657890.44 ' \
LASTCOMPANY='1553349.83 ' \
topcust=99999 \
newlist='51413,51415,69661,69660,51600,51608,51971,54348,54823,54824 ' \
custlist=1 \
),

It's been a while since I have done this, but I think there is a limit to the total number of characters you can pass. Try shortening your fieldnames and see if you can pass one more value.

All the field-name variables and their values get padded together to build a long string for the drilldown call.

Cannot remember right off top, but there is certainly a limit to the length of this string. Minimize field-name lengths and even code/decode values if possible.

If the "newlist" string will be of extremely long lengths, I would suggest writing it out to some file/database and read it back in the next program.

You could also device a mechanism to re-generate the "newlist" from scratch by passing enough info to the subsequent fex and re-running the logic.

Generally speaking, passing extremely long strings is not good for effeciency and security.

Sandeep Mamidenna

How large is the DEPTNAME ?

You may have to use javascript to populate a form the has a method of POST, to solve this.