Is it possible to group or arrange “Calculations†in the analysis services cubes in to different folders?
Satya, I am not sure with your question. This has to do with SQL Server and Agent. I am not sure where Excel is connected to do this ?
Mohammed, thanks for your reply, but I do not think that this has to do with the Escape macro of a token. If you observer in my code I am already...
Hello I have an alert which gets triggered on a Deadlock. This triggers a job which has the below code INSERT INTO DeadlockEvents(AlertTime,...
We have the same issue too. Upon research we found that this happens due to the width of the headers. In some case you will be able to correct this...
Can some one write a query for the below requirement. here is the code that you can use to create and populate the tables Create table XYZ (id int,...
This is not exactly a crosstab query because i do not need all columns for each rows. Can anyone think of another way for this type of query without...
Sorry, I did not realize that my output was not clear enough. I am sort of trying to turn the rows into columns. This is a kind of crosstab query but...
Hi, Can someone give me a detailled explanation of what is the difference between the below two in SQL Server 2005 1. Setting the Full Text index/...
We have a merge replicaiton with 5 subscriptions. 4 of those are 2 way and 1 subscriber is a 1 way replicaiton. All of a suddent one of those (1way)...
Thanks SMY, Tooltips option worked and that is exactly what I wanted. Now how can we change the font and color of the tooltip. Raj
Anil. All of the connection information is stored in Datasource table within Reportserver DB. But the connection information is stored in the form...
Smy, 1. Here is the scenario. There are 1000 user names in a table. Out of those only 5 very very frequently run the report. So, using a query...
smy, Parameters is already displayed as a drop down box (this is because the dataset for parameter returns more than one value). But the probelms is...
I have a column on my report which has an hyperlink. In the properties within navigation tab I have selected "Jump to URL" and the URL comes from the...
Hello, I would appreciate if some one could answer the following questions 1. Report Parameter: I have a report which has an input parameter....
SMY, I do have all the privilleges selected in the properties at the reports home page. But I am still not able to deploy the reports on the server....
I am using SQL Server Reporting Services 2005. RS is installed on a box which also has SQL Server 2005 on it. I have a windows account YYY with which...
Separate names with a comma.
