More joins than allowed help required?

[Trainingjason]

A question I was asked last week was, I want to do a parameter query with multiple discrete options. When I try to place the selection on the report, using join it will only allow 254 characters.

I want to select via a parameter more characters than that and place on a report. I was using crystal 8. Does any one have an idea how?

Thanks



Jason

 

[dgillz]

This was discussed recently. I have never done this but here is my best idea.

Create a string variable array, then write a loop that builds the first element of the array until it is close to 254 characters. Then make the loop start building the 2nd element of the array, then the 3rd, etc. Use the UNTIL command in your loop so it will stop looping when you run out of parameter data.

Then display the array in the report header. Use multiple report header sections, maybe 10 or some number that you can never reasonably be expected to populate with the array you just built. Place array[1] in RH1, array[2] in RH2, etc. Format each section to suppress blank section to get rid of white space.

I am very sure this is doable but I have never done it. If you successfully pull this off I would love to see the code, or if you get close and need help debugging the code please post it on Tek-Tips. Software Support for Macola, Crystal Reports and Goldmine
dgillz@juno.com

 

[Trainingjason]

I am training crystal later in the week and will have a go.

Thanks


Jason