Skip to Content
0
Former Member
Feb 25, 2009 at 09:34 PM

stored procedure prompting twice in CR XI

18 Views

Hi, I followed the example of oracle stored procedure as described in the website and the example of dynamic cascading,

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/1084c536-711e-2b10-e48a-924a60745253

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/e09f8496-7a64-2b10-f587-da7c1f66f2b1

I want to make the a list of values that brings some values then send them back to the stored procedure but it prompts twice, the first time it asks for the test_parameter and it just ignores it, then it displays the list of values and it brings the requested values. How can I avoid being prompted the first time please. Does this the way crystal works, bringing whatever stored procedure parameter then showing the invites? by the way I see my parameter (Test_parameter, should it be @Test_parameter instead?)

I am using crystal reports XI. Thanks in advance,

Kartit