Showing posts with label schema. Show all posts
Showing posts with label schema. Show all posts

Wednesday, March 28, 2012

Report Pack for Reporting Services

Has anyone seen report-pack for Reporting Services? Similar to one that is
available for IIS, GPS etc.
Or other option is there any database schema description of the "ReportDB"
for Reporting Services 2005?
--
Thanks in advance - Sunil.The closest thing to a report pack for reporting services is the Report
Execution log reports. The package includes a SSIS package, DB and several
reports.
The reports included will tell you about report execution times, parameters
used, etc, etc
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/RSMnRptExPf.asp
--
Andy Potter
blog : http://sqlreportingservices.spaces.live.com
info@.(NOSPAM)lakeclaireenterprises.com
"Sunil K" <SunilK@.discussions.microsoft.com> wrote in message
news:8650684C-FBBD-4D94-A662-CAC937654801@.microsoft.com...
> Has anyone seen report-pack for Reporting Services? Similar to one that is
> available for IIS, GPS etc.
> Or other option is there any database schema description of the "ReportDB"
> for Reporting Services 2005?
> --
> Thanks in advance - Sunil.
>

Friday, March 23, 2012

report model project question

I am having a problem trying to get the correct data on the report.
It is a typical schema where we have clients, doctors and both of those have
doctors. I am unable to show clients, client addresses and doctors on the
same report builder report. I can get 2 of those not 3.
any ideas? (is this a limitation of the product?)It all depends on the relation you set to be visible in the report model. So
you need to select the proper table and the keys.
Amarnath
"dave" wrote:
> I am having a problem trying to get the correct data on the report.
> It is a typical schema where we have clients, doctors and both of those have
> doctors. I am unable to show clients, client addresses and doctors on the
> same report builder report. I can get 2 of those not 3.
> any ideas? (is this a limitation of the product?)|||What do you mean "the relation you set to be visible"? How and where do you
specify visible options?
Sorry new to this.
thank you
dave
"Amarnath" wrote:
> It all depends on the relation you set to be visible in the report model. So
> you need to select the proper table and the keys.
> Amarnath
>
> "dave" wrote:
> > I am having a problem trying to get the correct data on the report.
> >
> > It is a typical schema where we have clients, doctors and both of those have
> > doctors. I am unable to show clients, client addresses and doctors on the
> > same report builder report. I can get 2 of those not 3.
> >
> > any ideas? (is this a limitation of the product?)|||Ok, Visible means nothing like enabling or disabling. but what I meant was,
setting the right relation, so that it can be selected for your reports from
report builder. If you dont have the relation or if the PK or FK is not
present in the tables, then that can't be selected, which you will come to
know when you go for setting the relation using the wizard.
Amarnath
"dave" wrote:
> What do you mean "the relation you set to be visible"? How and where do you
> specify visible options?
> Sorry new to this.
> thank you
> dave
> "Amarnath" wrote:
> > It all depends on the relation you set to be visible in the report model. So
> > you need to select the proper table and the keys.
> >
> > Amarnath
> >
> >
> > "dave" wrote:
> >
> > > I am having a problem trying to get the correct data on the report.
> > >
> > > It is a typical schema where we have clients, doctors and both of those have
> > > doctors. I am unable to show clients, client addresses and doctors on the
> > > same report builder report. I can get 2 of those not 3.
> > >
> > > any ideas? (is this a limitation of the product?)