Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
MODIFYING THE QUERY DYNAMICALLY
Migrateduser
Hi,<br />
<br />
I have a query as shon below. I placed this query in dataset. Now If i pass the parameters like JAN,FEB,MAR....I would like to replace 'APR' with my parameter value like JAN, FEB....<br />
<br />
select <br />
sum(<span style='color: #FF0000'>APR</span>_OPBAL) AS AA, <br />
sum(<span style='color: #FF0000'>APR</span>_OPBAL_VAL_PTR), <br />
sum(<span style='color: #FF0000'>APR</span>_OPBAL_VAL_BPTR), <br />
sum(<span style='color: #FF0000'>APR</span>_PURCHASE_QTY), <br />
sum(<span style='color: #FF0000'>APR</span>_PURCHASE_VAL_PTR), <br />
sum(<span style='color: #FF0000'>APR</span>_PURCHASE_VAL_BPTR), <br />
sum(<span style='color: #FF0000'>APR</span>_SOLD_QTY), <br />
sum(<span style='color: #FF0000'>APR</span>_SOLD_VAL_PTR), <br />
sum(<span style='color: #FF0000'>APR</span>_SOLD_VAL_BPTR), <br />
sum(<span style='color: #FF0000'>APR</span>_ADJUST_QTY), <br />
sum(<span style='color: #FF0000'>APR</span>_ADJUST_VAL_PTR), <br />
sum(<span style='color: #FF0000'>APR</span>_ADJUST_VAL_BPTR),<br />
sum( <span style='color: #FF0000'>APR</span>_HMSRET_QTY), <br />
sum(<span style='color: #FF0000'>APR</span>_HMSRET_VAL_PTR), <br />
sum(<span style='color: #FF0000'>APR</span>_HMSRET_VAL_BPTR),<br />
sum( <span style='color: #FF0000'>APR</span>_CLBAL), <br />
sum(<span style='color: #FF0000'>APR</span>_CLBAL_VAL_PTR),<br />
sum( <span style='color: #FF0000'>APR</span>_CLBAL_VAL_BPTR) <br />
from tbl_summary_rate where year=2010<br />
<br />
<br />
plz help me.<br />
<br />
Thanks and Regards,<br />
Arun
Find more posts tagged with
Comments
There are no comments yet