Open document Question in BO

[Former Member]

Hi Gurus,

Does anyone know how to link webi report to crystal 2011 report. I'm using the open document method to do this. I need in such a way that when a user clicks on a value of a field in webi report then it should open the crystal report with data related to the clicked value in webi. I tried this by passing the parameter values from webi to crystal but it always prompts to enter parameter values for crystal report.

Does, I'm doing something that can't be done ?

Thanks,

Abhi

[Former Member · Accepted solution]

Thanks Abhilash for your help.

I found that actually my report B itself is not giving data.

Thanks,

Abhi

[JWiseman]

hello Abhi,

it is possible to go from webi to crystal or from crystal to webi using an opendocument link. if you're at the stage when opendocument finds the report but then runs the prompt / parameter dialogue then usually the issue is one of:

a) you're missing one or more parameter in the opendocument url...check that the number of prompts / parameters on the report matches with the number in the opendoc url

b) one of the parameters is spelled incorrectly or the case is incorrect...double check the spelling and case of the url params so that they match the report

c) you've got an illegal character in the url which stops the complete url from being processed...not sure about webi but in crystal there's a function that you can use to url encode values. this can happen when you've got database values that have the illegal characters in them. what i've done in the past to avoid this is to try to pass the parameter as lsM[] instead so that the database value is in brackets and thus does not break the url.

hopefully the above will help,

jamie

[Former Member]

Thanks Jamie for your reply !!

I have got around this by using the document link in webi and there by I can successfully link webi to crystal without prompting but I have another issue which I'm actively investigating on.

lets check this case.

Report A                        

Column A    KF1             

1234           $26

1235           $24

1237           $21

Report B : it is detailed report with prompt on column A field in report A.

Now that when I hit on value 1235(Row #2 in Report A), report B opens without prompting but captures data for values 1234,1235 as well. whereas I need the report b to capture data for value 1235 only.

Any help is highly appreciated !!

Thanks,

Abhi

[abhilash_kumar]

Hi Abhishek,

Make sure the Record Selection formula in the CR report reads:

{database_field} = {?Promp_Name}

-Abhilash