Using SP in dynamic reports.

  • Hi All,

    I want to make a huge report. i want it as a dynamic report.

    I have the SP ready with me. I have used few functions to bring out some logic as per requirement.

    so writing a query will not support the requirement.

    Can i use that SP to created a dynamic report?

    I need it to be user-friendly.....

    I tried with some simple query. but when i try to run report, it is giving

    error saying i must give filter.

    this is not mandate condition i think....

    what if i want to just display few columns (say a select * from emp or something like tht)? then i will not need any filter...

    Please help

  • Can you define what you mean by "dynamic report"?

  • Hi

    thnks for reply.

    dynamic reports are built using the report builder . they dont have any pre-defined layout....

    the tables, joins and necessary filter conditions are provided with the query and the user drags and drops the fields into the layout at run time and run the report.

    so each user can make a layout of his own according to his requirement.

    this works for queries... but i wanted to know can we use SPs.....

    Also, i want to know can we user parameters as we do in our normal report.

  • All right, had you said Report Builder I think you would have gotten more responses. I have not used Report Builder or report models yet, so I don't have a sure answer, but I think you can use an SP to create the report model.

  • Sorry everyone here refers to it as dynamic reports itself....

    i was not sure of this....(i will change it now)

    now after much trial and error methods, i have found how to place filters.

    now i am finding it diff in grouping them the way i want.....

    among the thousands of members, m sure there will be few people who use this and can help me out......

    i will be really greatful for any suggestions....

    Regards,

    Malavika

  • Hi all,

    I am now getting the report .... i am getting a drill down report also...

    but that is not what i made....

    for all the fields which have total it is showing a detail report.

    Can anyone suggest how can i control this to display the fields i need?

    Also if you can suggest some good books or sites related to this it will be bery helpful.

    Thanks,

    Malavika

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply