MacintoshF16
Technical User
Hi Folks,
How r u all..
I am facing one problem in CRN, my problem is goes here..
I have created Stored Proc in SQL Server with 3 passing variables. I am passing three varialbes in the Procedure.
I have successfully imported the Proc in the FM and validated with some testing values. Its working fine.
and my problem come hre.. I wud like to create Drill Down report based on this Stored PRoc Namespace.. Ok..?
I ahve created master report using this namespace and its working fine. and It is asking the variables as prompt while running the report. Ok.. Its fine.( We cant avoid those Proc variables as prompt in the report. bcoz those variables are passing thru PRoc)
and i have developed child report using the same namespace (My requirement is like that) . now i wud like to drill down from the master reprot to child reprot. While drilling down its asking again the parameters as prompt. It doesnt make sense if it asks again the prompts in child reprot (ie detail Reprot) right?
Is ther any possibility to, shud not not ask the Proc passing variable as prompt values.
I will thank you to U.. Please give me the solution..
Mac
How r u all..
I am facing one problem in CRN, my problem is goes here..
I have created Stored Proc in SQL Server with 3 passing variables. I am passing three varialbes in the Procedure.
I have successfully imported the Proc in the FM and validated with some testing values. Its working fine.
and my problem come hre.. I wud like to create Drill Down report based on this Stored PRoc Namespace.. Ok..?
I ahve created master report using this namespace and its working fine. and It is asking the variables as prompt while running the report. Ok.. Its fine.( We cant avoid those Proc variables as prompt in the report. bcoz those variables are passing thru PRoc)
and i have developed child report using the same namespace (My requirement is like that) . now i wud like to drill down from the master reprot to child reprot. While drilling down its asking again the parameters as prompt. It doesnt make sense if it asks again the prompts in child reprot (ie detail Reprot) right?
Is ther any possibility to, shud not not ask the Proc passing variable as prompt values.
I will thank you to U.. Please give me the solution..
Mac