Crystal reports Publications

[Former Member]

Hi All,

I have report with parameter and one of which accepts multiple values, is there a way to create a publication which will pass multiple values to the report?

Report is built joining tables from SQL server. (Do I have to modify the report, and pass the multiple values as comma separated string? or is there a way to pass multiple values to publication?)

We are using Dynamic list to pass the emails and parameters to the publication where the details are stored in the database table.

Thanks in advance!

[Former Member]

Hi Santosh,

You just open the report in Crystal designer, In the "Field Explorer" change parameter option to "multiple".

Then the crystal report automatically allows multiple prompts in the publication...

Regards,

Naga.

[Former Member]

Thanks Naga for the reply.

My question now is how do pass multiple values to the source report in the publication, as the multiple values cannot be comma separated from the dynamic recipient list?

Thanks!

[JWiseman]

hi Santhosh,

if you need to create a comma separated output in crystal reports then you can create a string running total...

1) create a new Formula named "srt" with syntax like

whileprintingrecords;

stringvar srt:= srt + {yourtable.yourtextfield} + (if not onlastrecord then ',')

2) place this formula on your details section

3) create a new Formula named "srtfinal" that reads

whileprintingrecords;

stringvar srt

4) place this formula in your report footer

you should now be able to use the srtfinal formula in the publication personalization.

it's been a while since i did a publication, but i am assuming from your question that you can't map multiple field values to a mutliple value parameter.

i hope this helps,

jamie

[Former Member]

Hi Jamie,

Thanks for the reply!

I could use the stringvar function, but how do I pass multiple values to the source document in the publication from the dynamic recipient list, I have one live for each instance for the source report.

Thanks!

Santhosh

[JWiseman]

hi Santhosh,

this may be best posted to the BI Platform question as you're dealing with the personalizing aspect of a publication.

before you repost there though you can try this:

1) if you're source report is grouped on a value that is passed to the target report, put in a reset formula on the group header

whileprintingrecords;

stringvar srt:= ''

2) move the srtfinal formula to the group footer

3) try to use the srtfinal final to personalize the publication between the source group and the target parameter

i don't have an enterprise product in front of me so i can't really help any further with this and it is as mentioned before a question that should be going to the bi platform forum.

-jw