COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: kvchowdary on 12 Nov 2016 07:00:52 AM

Title: Data is not populating in RS
Post by: kvchowdary on 12 Nov 2016 07:00:52 AM
Hi,

I have a requirement and i am passing the values from the prompt to report,and i have created the macros in the query to directly fetch the data from the DB(I am not using any filters in the report),here the problem is when i checked the data for(view tabular data) i am able to get the data,but when i am passing the same parameters from the prompt page to report i am not able to getting the data.

Please help me on this

Thanks,
vck
Title: Re: Data is not populating in RS
Post by: MFGF on 14 Nov 2016 03:42:23 AM
Quote from: vck on 12 Nov 2016 07:00:52 AM
Hi,

I have a requirement and i am passing the values from the prompt to report,and i have created the macros in the query to directly fetch the data from the DB(I am not using any filters in the report),here the problem is when i checked the data for(view tabular data) i am able to get the data,but when i am passing the same parameters from the prompt page to report i am not able to getting the data.

Please help me on this

Thanks,
vck

Hi,

Can you explain this? What do you mean by "I have created the macros in the query to directly fetch data from the DB"? Are you saying you have manually coded SQL in your report?

MF.