May 18, 2010 at 12:53 am
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
May 18, 2010 at 9:12 pm
Can you define what you mean by "dynamic report"?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
May 18, 2010 at 10:03 pm
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.
May 19, 2010 at 6:30 am
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.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
May 19, 2010 at 6:59 am
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
May 19, 2010 at 10:35 pm
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