Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Developing Drill Down Reports Using Stored Proc NameSpace

Status
Not open for further replies.

MacintoshF16

Technical User
Aug 27, 2003
21
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top