|Reg dynamic parameter [message #896010]
||Mon, 16 July 2012 17:47
| A R
Registered: April 2012
For one specific requirement I need to come up a quesry as follows for my dataset.|
select * FROM ASSET_REQUEST_29 UNION ALL
select * FROM ASSET_REQUEST_31 UNION ALL
select * FROM ASSET_REQUEST_32 UNION ALL
select * FROM ASSET_REQUEST_33 UNION ALL
select * FROM ASSET_REQUEST_34 UNION ALL
select * FROM ASSET_REQUEST_36
Problem here is there is possibility of that ifin future new version of the "ASSET_REQUEST" is created like "ASSET_REQUEST_37, ASSET_REQUEST_38" then my report won't be able to capture the informaiton from the same. I need to modify the report.
Please suggest me , how can i be able to achieve the approach where I can dynamically over come this issue.
Let me know if I need to provide any details further.
Powered by FUDForum
. Page generated in 0.02999 seconds