locked
ssrs report creation through dynamic sq RRS feed

  • Question

  • User2108234275 posted

    Hi,

    I am having sp which is an dynamic sql to fetch an end result, when I called that to report wizard in both report builder and winform dataset. it was able to create the required parameter but was unable to fetch the data fields used in that sp. How to fetch that fields into the dataset .

    Thanks in advance

    Padhu

    Thursday, February 10, 2011 4:23 AM

All replies

  • User-830595639 posted

    Hi,

    If you want to call dynamic query from SSRS, then you need to write a custom code and that custom code you can call to fill your dataset.

    Please let me know if you have any other concertn.

    Nishant 

    Friday, February 11, 2011 3:54 AM
  • User2108234275 posted

    Hi,

    I tried implementing it in datset but it shows ly parameter, fields are not enabling as it is dynamic query.

    Custom code means Report->Report Properties->CustomCode eh?? In that how shall v write dynamic code, v can write normal code rit?

    Padhu

    Friday, February 11, 2011 8:49 AM
  • User-830595639 posted

    Hi,

    I said you can write dynamic query in custom code not dynamic code, and I didn't get that what you are trying to say through dynamic code. Do you want to change you display column dynamically or you want any thing else?

    Thanks

    Nishant 

    Monday, February 14, 2011 4:40 AM