Search results for query: *

Hi All , I am getting this error while trying to connect Analysis Server , anyone faced the same before. TITLE: SQL Server Management Studio ---------------------------------------- Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)...

Hi All, I have a particular situation where I need to set some column names dynamic (from another table) in my cube. The Scenario: 1.Fact table with column names "column1" , '"column2" 2. Column_name table with two fields "Identifier" and "Name" , the "Name" field values are changing time...

Thanks George , the example I have given is just the example where i just tried to give the concept of my problem, in my original query the size of the variables are declared arrording to the numbers of characters and the value is assigned here is just an example.

Hi, I have a user defined function which has 5 parametes to pass, now while running the UDF using hardcoded parametes value its taking only 10 seconds , but while running the UDF by declaring the parametes value and assigned them value its taking more than 3 minutes. here is the example...

Hi I have a column Chart with an X value(catagory Group) and a Y value (value), i am using value in Y axis which value sometime is NULL, When This vaue is NULL I am getting Legend for that value with the name SERIES ? Is there any way to remove that legend while my value is NULL?

Hi, I figured it out . Thanks Andrea for you valuable feedback. Virus

Yes , It is printing while I make it visible , but it must need to be invisible as i dont wnt to make font color white. Thanks Andrea.

Thanks Andrea, I am not imposing any condition to display in the footer, I am referencing the textbox which is in body of the report and made the textbox hidden.

Thanks George for the quick reply , The statistics are set to auto update. and the query is using two table valued function which are using another 3 table valued functions. and those are really lerge enough to post here.

Hi, I was running a query before and it was taking around 4-5 minutes to run, I changed index of one lerge table from non clustered to clustered(Primary key), the query took 15 minutes to run. after that I change the the index to non clustered again and its stil taking 15 minutes to run...

No, Its not appearing at all on PDF.

Hi, I am presenting some data fields value in the Page footer by using the referencing trick to textbox, exist in the body of the report. Now the problem is while running localy i am getting all the field values as I want, but while exporting into PDF I cant see those values in the footer...

Hi, I need to represent data in 11 X 8.5 landscape page where I have 13 columns and the values are large enogh sometimes to fit into textbo size. Is there any option in reporting service to accomodate lerge value according to textbox size! 2nd option I need to reduce the font size from 8...

Hi, I am tying to optize a stored procedure which is taking two function with 6 parameters and producing the output. The issue is ,when I am running only the query its taking around 2 and half minites but if I am taking the same query into a stored procedure the SP is taking more than 10...