Dynamic/Cascading prompts with LBI

You are trying to do dynamic/cascading prompts in LBI?

Yes.

Sorry, I'm confused as to why Lawson would've told you that "dynamic/cascading prompts are only failsafe with OLEDB" LBI doesn't support Crystal XI cascading parameters funtionality (regardless of the data source). The only way I know of to implement this, outside of custom programming, is to force the report to use the Crystal parameter page in LBI by deleting the report parameters after publishing.

Hey Chris

Thanks for the response. Lawson was steering me away from ODBC-based reports with dynamic/cascading prompts. Maybe the rep wasn't clear about what I wanted to do. I know about deleting the parameters after you publish the report.

Yeah, sounds like they misunderstood. Honestly, the only reason I would ever use the Lawson OLE DB connection is when I absolutely have to (ie RW output as a datasource). Performance is just too limiting.

Well, for very large tables, we want to limit our data at the command level (a big advantage for large tables) as well as enforce security.

From my experience, even the "fast" OLE DB reports are slow compared to ODBC or Native connections. So you don't enforce security through the LBI bursting functionality, but rely on laua to control this instead?

I agree, but the dynamic prompts were the reason to go w/ OLEDB for most of these.

I added an ODBC report from HRHISTORY with prompts, published it, deleted the parameters, and tried to run it.

I get a 'fail to start prompting' error though.

Any ideas? I have a case open with Lawson. LBI hasn't exactly been bug-free.

ps

Is there any more detail on the error in your tomcat/websphere log or in your RAS log? For Tomcat, your RAS log is located in the \webapps\ers\logs directory.

I'll check that out and get back to you.

Thanks, Chris.

Chris

Hey. I’ve searched Crystal support site and apparently the problem with prompts is a known issue in Crystal. There are many references to this issue:

Error: "List of Values failure: fail to get values…CORBA_SystemException" (c2019530)

Crystal Reports is running behind a firewall. When running a Crystal report that contains a dynamic parameter, or when selecting a predefined dynamic list of values...

Published 6/22/06 KBase Article ID: c2019530

Error: “failed with the following error message: 'List of Values failure: fail to get values’…” when refreshing Crystal Reports XI Release 2 (4145186)

After migrating from Crystal Reports XI to Crystal Reports XI Release 2, when refreshing a document...

Published 6/13/07 KBase Article ID: 4145186

Error: "List of Values failure…prompt.dll Error code: 0x8004380D" (c2019296)

In Crystal Reports, reports using List of Values (LOV) based on a Business View are refreshed and after 5 minutes an error message appears: Prompting failed with the...

Chris/Phil,
I split the post off from the original "Learning SQL" post since it has deviated from that topic..