I have been able to create a LOV in the Business View Manager and make it available to the Crystal Reports 2011 designer. From various things I have heard, I was made to believe that LOVs could be created in the Information Design Tool. I have done this and published the universe to the repository.
I have a report in Crystal Reports 2011 based on a stored procedure. When I am editing a parameter, and select Dynamic and Existing, the LOVs listed are only those I created in the Business View Manager. I am not seeing the LOV from the Information Design Tool in the repository. Is there a step that I missed, or have I been misled about this functionality?
Just a thought, why dont you go for Crystal Reports for Enterprise when you would like to leverage objects created with IDT(Information Design Tool)?
Further, yes when you try to create dynamic prompt, the prompt group displayed in the crystal reports parameter dialog box would be the once that you have created using BVM(Business View Manager).
Just wanted to add my inputs/thoughts…Please correct me
Crystal Reports for Enterprise will currently only connect to data via a universe (this is scheduled to change in a future release.) Most of the time this is not the most efficient way to get the data for the report. So, unless you’re using universes exclusively, CRE is not the solution you need.
(BOB member since 2005-05-06)