{var%20f='http://v.t.sina.com.cn/share/share.php?appkey=1515056452',u=z||d.location,p=['&url=',e(u),'&title=',e(t||d.title),'&source=',e(r),'&sourceUrl=',e(l),'&content=',c||'gb2312','&pic=',e(p||'')].join('');function%20a(){if(!window.open([f,p].join(''),'mb',['toolbar=0,status=0,resizable=1,width=440,height=430,left=',(s.width-440)/2,',top=',(s.height-430)/2].join('')))u.href=[f,p].join('');};if(/Firefox/.test(navigator.userAgent))setTimeout(a,0);else%20a();})(screen,document,encodeURIComponent,'','','https://www.manongdao.com/data/attach/logo/logo.png', '推荐 对你真心纯属浪费 的问题《Make Stored Procedure parameters cascading in Crys》','https://www.manongdao.com/q-932663.html','页面编码gb2312|utf-8默认gb2312'));){kind=link}
I don't have a lot of experience using Stored Procedure as a data source for Crystal Reports. My question is that when you connect to an Oracle Stored procedure which has 2 parameters - Country and City, the parameters are already mapped in Crystal individually. Is there a way i can make these parameters cascading i.e. Country > City, either on front end or backend
相关问题
- What is the best way to cache a table from a (SQL)
- Pass code to a method as an argument
- Can I parameterize labels and properties on CREATE
- JasperReports Server parameter dependency
- SQL [Conversion to bool]
相关文章
- How can I convert a PHP function's parameter l
- SQL Server 2008: Joining results of STORED PROCEDU
- Is SaveChanges() Necessary with Function Imports (
- Can I lazy load a navigation property by delegatin
- Using UNREFERENCED_PARAMETER macro
- Is there a simple way to pass specific *named* Pow
- What is the best way to cleanup the resources used
- how to pass two parameters to call a stored proced
After you add a stored procedure to the report, you should see the two parameters listed in the Parameter Fields section in the Field Explorer.
Edit one of the parameters, select 'Dynamic' from the List of Values picklist. Click the first row below in the Value column to select which field in your SP will contain the value (key) for Country. Do the same for the description. Click the second row to follow the same process for the City.
The parameters' values will be limited to what the SP returns.
If you publish the report to BusinessObjects Enterprise, it will create a BusinessView (and lots of other objects) to host the List of Values. This allows you to specify a broader (not just limited to the SP's result) set of values.