Reporting Services - Please Advice

Hello,
I need some guidance on this possible misundestanding. I believe that
Reporting Services is mainly used for those kind of reports where you have
consolidated data and then you may drill-down to get details about it, but
for operational reports where you have letter style reports with a big part
of static info like an insurance policy or a contract where you you have a
lot of clauses which are static and some info which is dynamic. Is it
possible to do that kind of report in Reporting Services?
TIA
JorgeAs long as there is text, Reporting Services can display it. :)
If you have a lot of static content, you could do it two ways:
1) Create a table with all the static content in different rows, with
different IDs. Create a report with a data set that puts all the text
together, based on ids for static content and dynamic content.
2) Create reports with hard coded static content, and just create one or
more datasets that gets the dynamic data, and put it in where you need it.
I would go for the first solution. It's easier to updata data (text content)
in a database than in a report.
Kaisa M. Lindahl Lervik
"User" <jluzarra@.hotmail.com> wrote in message
news:%23Zh95RNvGHA.3552@.TK2MSFTNGP03.phx.gbl...
> Hello,
> I need some guidance on this possible misundestanding. I believe that
> Reporting Services is mainly used for those kind of reports where you have
> consolidated data and then you may drill-down to get details about it, but
> for operational reports where you have letter style reports with a big
> part of static info like an insurance policy or a contract where you you
> have a lot of clauses which are static and some info which is dynamic. Is
> it possible to do that kind of report in Reporting Services?
>
> TIA
>
> Jorge
>