Viewing 15 posts - 16 through 30 (of 74 total)
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...
November 27, 2006 at 7:34 pm
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.
November 19, 2006 at 5:09 pm
I've seen this in a prev post. Try this link
http://qa.sqlservercentral.com/forums/shwmessage.aspx?forumid=150&messageid=285031
November 16, 2006 at 3:57 pm
yes you can definately write reports against 2005 cubes.. possible 2000 not sure... I'd check the MS SQL Server website.
November 5, 2006 at 4:37 pm
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...
November 2, 2006 at 7:54 pm
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...
October 30, 2006 at 1:39 pm
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...
October 4, 2006 at 3:57 pm
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...
October 4, 2006 at 3:54 pm
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.
September 27, 2006 at 4:00 pm
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....
September 21, 2006 at 7:21 pm
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...
September 10, 2006 at 3:54 pm
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
September 10, 2006 at 3:47 pm
wouldn't count() have worked equally as well? Or maybe i'm not understanding the situation...
September 7, 2006 at 2:51 am
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...
September 7, 2006 at 2:40 am
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...
September 7, 2006 at 2:29 am
Viewing 15 posts - 16 through 30 (of 74 total)