report model project problem - entity not showing up

I have a client table and a clientdoctors table.
In the data source view i see all the needed tables in the diagram organizer
pane. I also see the relationship between the clientdoctors table (which
holds clientid and doctorid), as well as client table and doctor table.
That all looks fine. The problem however is that when in my report model i
do not see those relationships at all between the client - client doctor -
doctor tables. There are a few situations just like this that i cannot
explain.
I am new to the report model project but i dont know why i dont see these
relationships inthe report model or while using report builder.
Any ideas please'Have you deployed properly? I mean you didn;t get any error. After deploying
you get to see in Report Builder. Just check.
Amarnath
"dave" wrote:
> I have a client table and a clientdoctors table.
> In the data source view i see all the needed tables in the diagram organizer
> pane. I also see the relationship between the clientdoctors table (which
> holds clientid and doctorid), as well as client table and doctor table.
> That all looks fine. The problem however is that when in my report model i
> do not see those relationships at all between the client - client doctor -
> doctor tables. There are a few situations just like this that i cannot
> explain.
> I am new to the report model project but i dont know why i dont see these
> relationships inthe report model or while using report builder.
> Any ideas please'|||Yes everything deployed properly. It seems like the problem was related to
keys on the tables. i.e. i had to place keys on the middle table.
"Amarnath" wrote:
> Have you deployed properly? I mean you didn;t get any error. After deploying
> you get to see in Report Builder. Just check.
> Amarnath
>
> "dave" wrote:
> > I have a client table and a clientdoctors table.
> >
> > In the data source view i see all the needed tables in the diagram organizer
> > pane. I also see the relationship between the clientdoctors table (which
> > holds clientid and doctorid), as well as client table and doctor table.
> >
> > That all looks fine. The problem however is that when in my report model i
> > do not see those relationships at all between the client - client doctor -
> > doctor tables. There are a few situations just like this that i cannot
> > explain.
> >
> > I am new to the report model project but i dont know why i dont see these
> > relationships inthe report model or while using report builder.
> >
> > Any ideas please'|||You need to have key relationship otherwise it wont select tables in the
report model itself. If you have completed the wizard of creating report
model. then it would have asked for keys when you select tables for
relations. So just check if all the keys are in place and deploy.
Amarnath
"dave" wrote:
> Yes everything deployed properly. It seems like the problem was related to
> keys on the tables. i.e. i had to place keys on the middle table.
>
> "Amarnath" wrote:
> > Have you deployed properly? I mean you didn;t get any error. After deploying
> > you get to see in Report Builder. Just check.
> >
> > Amarnath
> >
> >
> > "dave" wrote:
> >
> > > I have a client table and a clientdoctors table.
> > >
> > > In the data source view i see all the needed tables in the diagram organizer
> > > pane. I also see the relationship between the clientdoctors table (which
> > > holds clientid and doctorid), as well as client table and doctor table.
> > >
> > > That all looks fine. The problem however is that when in my report model i
> > > do not see those relationships at all between the client - client doctor -
> > > doctor tables. There are a few situations just like this that i cannot
> > > explain.
> > >
> > > I am new to the report model project but i dont know why i dont see these
> > > relationships inthe report model or while using report builder.
> > >
> > > Any ideas please'

Report Manager Web Client Security Error

I am attempting to access an Access database file located on one of our
servers on the network through Reporting Services Report Manager and am
receiving the error below. I have already setup our Report Server
Service account to a domain account that has full Access to the file. I
am able to run the report from Visual Studio.Net on my local machine. I
have setup and successfully deployed numerous SQL Server based reports
and am able to run an Access based report as long as it's located on my
report server. Any help anyone could provide is extremely appreciated.
============================================== Reporting Services Error
----
An error has occurred during report processing. (rsProcessingAborted)
Get Online Help
Cannot create a connection to data source 'DataSource1'.
(rsErrorOpeningConnection) Get Online Help
The Microsoft Jet database engine cannot open the file
'\\Server02\PhoneBook\PhoneBook.mdb'. It is already opened exclusively
by another user, or you need permission to view its data.
----
Microsoft Reporting Services
==============================================Have you tried running it with Vis Studio closed?
I have not done this with RS, but I did have many problems connecting
asp pages to access using a DSN.
I ended up using a DSN-Less connection and it worked. I am not sure if
that is an option in RS though.
"Leo" <leo_olden@.yahoo.com> wrote in message news:leo_olden@.yahoo.com:
> I am attempting to access an Access database file located on one of our
> servers on the network through Reporting Services Report Manager and am
> receiving the error below. I have already setup our Report Server
> Service account to a domain account that has full Access to the file. I
> am able to run the report from Visual Studio.Net on my local machine. I
> have setup and successfully deployed numerous SQL Server based reports
> and am able to run an Access based report as long as it's located on my
> report server. Any help anyone could provide is extremely appreciated.
> ==============================================> Reporting Services Error
> ----
> --
> An error has occurred during report processing. (rsProcessingAborted)
> Get Online Help
> Cannot create a connection to data source 'DataSource1'.
> (rsErrorOpeningConnection) Get Online Help
> The Microsoft Jet database engine cannot open the file
> '\\Server02\PhoneBook\PhoneBook.mdb'. It is already opened exclusively
> by another user, or you need permission to view its data.
> ----
> --
> Microsoft Reporting Services
> ==============================================|||Thanks for your reply John. I actually did some further research and
found that the problem I'm experiencing is a known problem with Access
and the Microsoft Jet database engine. My workaround was to create a
batch file on my report server that copies in the original Access
database file to the report server every hour. My datasource now
resides on my report server and is therefore accessible.

Report generation is consuming 100% of CPU client side.

Hi,

I have a problem while rendering a report which returns around 5000 rows. At first the server is busy to process the request, when the server is done the rendering client side takes 100% of CPU and never displays the result ("IE is not responding"). It seems that the ReportViewer has trouble to handle the server response.

Do you have any idea why ?

Sbastien.

It appeared that the problem is a paging issue. The report contains groups and by default the top level is collapsed, when we try to expand a level that contains many rows thoses rows are all displayed on a single page. That's why IE is consuming 100% of the CPU to display all the rows.

How can I change that the paging is working for the sub groups displayed ?

|||

I found the answer in BOL:

"The HTML and Excel rendering extensions are not oriented to physical pages. Furthermore, the HTML rendering extension is interactive, meaning that user actions in a report can trigger additional processing that causes a report to expand horizontally or vertically to accommodate additional content. You cannot precisely control how reports viewed through these rendering extensions will paginate if the report contains interactive features."

Report generation is consuming 100% of CPU client side.

Hi,

I have a problem while rendering a report which returns around 5000 rows. At first the server is busy to process the request, when the server is done the rendering client side takes 100% of CPU and never displays the result ("IE is not responding"). It seems that the ReportViewer has trouble to handle the server response.

Do you have any idea why ?

Sbastien.

It appeared that the problem is a paging issue. The report contains groups and by default the top level is collapsed, when we try to expand a level that contains many rows thoses rows are all displayed on a single page. That's why IE is consuming 100% of the CPU to display all the rows.

How can I change that the paging is working for the sub groups displayed ?

|||

I found the answer in BOL:

"The HTML and Excel rendering extensions are not oriented to physical pages. Furthermore, the HTML rendering extension is interactive, meaning that user actions in a report can trigger additional processing that causes a report to expand horizontally or vertically to accommodate additional content. You cannot precisely control how reports viewed through these rendering extensions will paginate if the report contains interactive features."