Skip to Content
0
Former Member
Nov 29, 2006 at 07:07 AM

Cascading Parameters - having problems....

52 Views

<p>Hi,</p><p>&nbsp;</p><p>Although I have some experience with CR, I am new to the whole repository thing and so I&#39;m struggling to make use of it correctly - in particular with Cascading Prompts.</p><p>I have a report in the repository that uses 2 tables - orders and products. Orders contains geo and country and I am using those (in the report selection) against regular report parameters using static values I have typed in. I want to change it so that it uses Business Views to get the complete list of Geos, and based on the selection choose 1 (or more countries).<br /></p><p>I eventually found the BV help and read through the instructions for creating a Connection, Foundation, Element and Views etc. looked at the samples and the tutorial and did the following:</p><p>Connection (Location CN) - single table (orders). This is the same table used in the report itself..<br /></p><p>Foundation (Location FN) - single connection (Location CN)</p><p>Business Element (Location BE) - single foundation (Location FN) with the Geo and Country selected<br /></p><p>Business View (Location BV) - single element (Location BE)<br /></p><p>Prompt Group (Location PG) - selecting the Business Element (Location BE) and the 2 fields defined in it</p><p>&nbsp;</p><p>I went to my report to change the parameters and here is where I have become confused. I had two separate parameters but when I try and change one to point to the Prompt Group, it tries to select both of the Prompt Group entries - so what do I do withy my other existing parameter?</p><p>To be safe, I deleted both parameters and created a new one (location) and made it Dynamic, and selected the Prompt Group from the &#39;Existing&#39; data source and made sure both values were parameterized. I then changed the report selection to point to the parameters and tried to preview it - the report runs for several minutes before hanging with the following error:</p><p>&nbsp;</p><p><font color="#cc0000">Prompting failed with the following error message: &#39;List of Values failure: fail to get values [Cause of error: CORBA_SystemException]&#39;.</font></p><p><font color="#cc0000">Error source: prompt.dll Error Code: 0x8004380D</font></p><p>&nbsp;</p><p>I&#39;ve tried rebuilding the Business View components and playiong around with the report and parameters etc. but have failed to identify what the problem is - have I missed something in the repository definitions or am I using the Business View incorrectly in the report.</p><p>I&#39;m hoping one of you experts can quickly see a step I&#39;ve missed or a mistake I&#39;ve made in the process.. <br /></p>