I had a similar problem. After googling it seems that the problem is using windows integrated security, it seems the server doesn't know who the user is if the data...

yep. you just righ click on the field(s) you want to make primary key and select the 'make logical primary key' option. Then it works.

I've seen this in a prev post. Try this link

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=150&messageid=285031

yes you can definately write reports against 2005 cubes.. possible 2000 not sure... I'd check the MS SQL Server website.

i know analysis services 2005 can be setup so that it will display data in the local language. might be worth checking if reports can also be setup in this...

My assumption is that this is security related.

Initially you need to be an administrator to be able to grant permissions in Report Manager. This is because the only security group...

don't think you can do a DISTINCT SUM. Try a DISTINCT COUNT on one of your duplicated fields that should give you a count of the rows, you'll also have...

My sugggestions below:

1. I think that you might be able to use a free app supplied by MS to do what you want take a look at this link. You...

I'd use the sproc to build a permanent table in your database over night. ie pre process the data, then use the report to query the results.

we're using RS2000 herenot sure what version you have... but I would try this...

Declare your date params STRING, this what you need to hold a date format of dd/mm/yyyy....

i'd try a table object and see if this runs faster?! maybe the rendering to a matrix is the slow part as opposed to the query. How quickly does the...

just a thought but is the report server SS2005 or SS2000? I seem to recall that VS2005 editted reports don't work properly on SS2000.

htp

wouldn't count() have worked equally as well? Or maybe i'm not understanding the situation...

there are also virtual labs provided free by Microsoft. You run up a virtual server session which you use to do the lab excercises, this gets blown after you logoff.

You...

If you are using a data warehouse / mart can you simplify your query by building tables overnight. Then you can use the server to process your calculations when business...