problems exporting to excel

I have 2 levels of drill down. The first level does expand/collapse. The
second level, the details, do not get exported unless that section was
already open in the report. I am using Excel XP.
Any ideas?
Thanks.Normally, even the drill down isn´t checked the data will be exported to
excel. perhpas you disabled the function in excel for drilling down into the
data (on the left side there are + and - signs if you have something to
drill down)
Unfortunately my Excel on my machine and is asking for the corp.CD which is
sure don´t have, because I am on the move, so I can´t give you the exact
menu item to search for, but I gues google and the help file form Excel
should be your friend.
--
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"scraejtp" <scraejtp@.discussions.microsoft.com> schrieb im Newsbeitrag
news:10F795EE-7C5C-4A80-9492-607216270F8D@.microsoft.com...
>I have 2 levels of drill down. The first level does expand/collapse. The
> second level, the details, do not get exported unless that section was
> already open in the report. I am using Excel XP.
> Any ideas?
> Thanks.|||If I expand one of the drill downs and then export it then it works fine. I
can use the +/- sign in excel on the second drill down, but if I leave both
collapsed when I export it then I can't.
"Jens Sü�meyer" wrote:
> Normally, even the drill down isn´t checked the data will be exported to
> excel. perhpas you disabled the function in excel for drilling down into the
> data (on the left side there are + and - signs if you have something to
> drill down)
> Unfortunately my Excel on my machine and is asking for the corp.CD which is
> sure don´t have, because I am on the move, so I can´t give you the exact
> menu item to search for, but I gues google and the help file form Excel
> should be your friend.
> --
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "scraejtp" <scraejtp@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:10F795EE-7C5C-4A80-9492-607216270F8D@.microsoft.com...
> >I have 2 levels of drill down. The first level does expand/collapse. The
> > second level, the details, do not get exported unless that section was
> > already open in the report. I am using Excel XP.
> > Any ideas?
> > Thanks.
>
>|||I have the same issue and brought it up a month ago, but didn't receive any
responses. I'm not sure what to do about it. I did create a copy of the
report with everything expanded and may link that from my web page, but this
a kludge at best.
Neil
"scraejtp" wrote:
> I have 2 levels of drill down. The first level does expand/collapse. The
> second level, the details, do not get exported unless that section was
> already open in the report. I am using Excel XP.
> Any ideas?
> Thanks.|||Yes, I saw that thread. I actually did a copy/paste of your question because
I am having the exact same problem.
"Neil Gould" wrote:
> I have the same issue and brought it up a month ago, but didn't receive any
> responses. I'm not sure what to do about it. I did create a copy of the
> report with everything expanded and may link that from my web page, but this
> a kludge at best.
> Neil
> "scraejtp" wrote:
> > I have 2 levels of drill down. The first level does expand/collapse. The
> > second level, the details, do not get exported unless that section was
> > already open in the report. I am using Excel XP.
> > Any ideas?
> > Thanks.

Problems creating second relationship to the same table

I have two tables: ads and categories. I have an existing relationship: categories.id (PK) and ads.categoryid (FK). Now I want to create additional relationship with categories.id (PK) on ads.SecondCategoryID (FK). When I try to save it in SQL Manager I get the following error:

- Unable to create relationship 'FK_classifieds_Ads_classifieds_Categories2'.
The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_classifieds_Ads_classifieds_Categories2". The conflict occurred in database "mydb", table "dbo.classifieds_Categories", column 'Id'.

Hi. Maybe the SecondCategoryId field has data that not exists in the categories table|||

mariop77 is probably right.

Try doing a SELECT DISTINCT SecondCategoryID FROM ADS

Make sure all FKs really do exist.

|||It has Nulls someties. How can I allow nulls? The reason is sometimes there will be no second category...|||

Hi,

Actually, null is allowed here. But you need to make sure that Allow Null has been checked in the design view of the table.

|||Yes, it is allowed on the column level of course, yet can not create relationship...|||

Seems to me like this is a limitation not allowing more than one join to the same table... Do I need to create alias for the existing table?

1 Category (alias 1) many Ads on Ads.CategoryID

1 Category (Alias 2) many Ads on Ads.SecondCategoryID

I used to be able to do this in MS Access, but maybe SQL does not allow...

sql

Problems activating a second Report server using rsactivate (Web f

1. I cannot get rsactivate to activate a second RS node on a web farm.
rsactivate -c "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\RSReportServer.config"
Failure starting the web service:
The local NT Service is not activated
2. rskeymgmt on the Original RS node 1 does not work either.
rskeymgmt -e -fc:\rsdbkey.txt -pxxxxx
Are you sure you want to extract the key from the report server (Y/N)? y
The local NT Service is disabled 0x80090005
Environment -
The two RS Servers are both Windows 2003 Servers.
SQL Server is on a third computer: SQL 2000 Server Enterprise Edition.
RS Node1: Works fine.
RS Node 2: Activation fails.
ReportServer service login account for both nodes: "NT
Authority\NetworkService"
SQL Server access - using a "sql admin" account.
IIS (W3Svc) on both RS nodes - "LocalSystemAccount".
Web Servers on both RS nodes are working fine and the ReportServer service
starts as well.To activate a web farm, you will need to run rsactivate -m <name of node 2>
from node 1.
--
This posting is provided "AS IS" with no warranties, and confers no rights
"VChandy" <VChandy@.discussions.microsoft.com> wrote in message
news:539D88F5-35FE-44E7-B2A5-79AC74E363D9@.microsoft.com...
> 1. I cannot get rsactivate to activate a second RS node on a web farm.
> rsactivate -c "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportServer\RSReportServer.config"
> Failure starting the web service:
> The local NT Service is not activated
> 2. rskeymgmt on the Original RS node 1 does not work either.
> rskeymgmt -e -fc:\rsdbkey.txt -pxxxxx
> Are you sure you want to extract the key from the report server (Y/N)? y
> The local NT Service is disabled 0x80090005
> Environment -
> The two RS Servers are both Windows 2003 Servers.
> SQL Server is on a third computer: SQL 2000 Server Enterprise Edition.
> RS Node1: Works fine.
> RS Node 2: Activation fails.
> ReportServer service login account for both nodes: "NT
> Authority\NetworkService"
> SQL Server access - using a "sql admin" account.
> IIS (W3Svc) on both RS nodes - "LocalSystemAccount".
> Web Servers on both RS nodes are working fine and the ReportServer service
> starts as well.
>|||Figured it out from an earlier post on 8/17 from Brian Hartman [MSFT]
Did the following -
1. rskeymgmt -d on the orignal RS Node 1.
2. Stopped W3Svs and RS Service on Node 2. (** important)
3. From Node1 ran: rsactivate -mNode2 -c "C:\Program Files\Microsoft SQL
Server\MSSQL\Reporting Services\ReportServer\RSReportServer.config"
4. Re-started W3Svc and RS Service on Node 2.
5. Deleted and re-deployed all my RDLs to RS Node 1 as the security
information for the Data sources & other stuff got clobbered by rskeymgmt -d
6. Both RS nodes 1 & 2 can access all reports.
7. SSL works fine as well - next need to upgrade both nodes to RS Service
pack 1 and work on an NLB cluster solution ...
"VChandy" wrote:
> 1. I cannot get rsactivate to activate a second RS node on a web farm.
> rsactivate -c "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportServer\RSReportServer.config"
> Failure starting the web service:
> The local NT Service is not activated
> 2. rskeymgmt on the Original RS node 1 does not work either.
> rskeymgmt -e -fc:\rsdbkey.txt -pxxxxx
> Are you sure you want to extract the key from the report server (Y/N)? y
> The local NT Service is disabled 0x80090005
> Environment -
> The two RS Servers are both Windows 2003 Servers.
> SQL Server is on a third computer: SQL 2000 Server Enterprise Edition.
> RS Node1: Works fine.
> RS Node 2: Activation fails.
> ReportServer service login account for both nodes: "NT
> Authority\NetworkService"
> SQL Server access - using a "sql admin" account.
> IIS (W3Svc) on both RS nodes - "LocalSystemAccount".
> Web Servers on both RS nodes are working fine and the ReportServer service
> starts as well.
>

Problem with WHERE AND OR

I have a query that is mostly working, but the second or isn't coming into play.

SELECTSUM(SLPTRANS.TimeSpent) / 3600AS Hours, CLIINFOF.AddressLine1FROM CLIINFOFINNERJOIN SLPTRANSON CLIINFOF.RecordID = SLPTRANS.ClientIDINNERJOIN CUSTOMCON CLIINFOF.RecordID = CUSTOMC.RecordIDQWHERE (SLPTRANS.ActyExpID ='417')OR (SLPTRANS.ActyExpID ='418')AND (CUSTOMC.Service_Cont ='YES')GROUP BY CLIINFOF.AddressLine1

It is taking into account the 417 and the Customc.service_cont = yes, but not the 418. Any assistance would be greatly appreciated.

Thanks!

What about this:

WHERE (SLPTRANS.ActyExpID ='417' OR SLPTRANS.ActyExpID ='418')AND CUSTOMC.Service_Cont ='YES'