JKG above hit the nail on the head. But to add to that, if you are using a third party tool that uses extended procedures (e.g. Redgate SQL Backup -...

1. Connect to your analysis server

2. Right-click on trhe {server name} and select Reports -> Standard Reports -> General

This should show you the info you need. Good luck :hehe:

Check the version og Oracle you are using in both systems - that is whether it is 32-bit oracle client and a 32-bit SQL server or both systems are 64-bit.

I...

After doing some recheck and online research, we found that adding the TYPE syntax in the SQL script that creates the xml column and that did it.

Thanks:-D

Hi there, if you are trying to hide the entire table if some field on the report is blank, then what you do is

1. Right-Click on the table and go...

Hi there,

The length of the report parameter should increase based on the longest parameter value in your list. It seems a bit weird that it doesnt; giving us some...

sc2techie (5/8/2009)

---

I have a simple report that includes two tables, one that contains data relating to sales by dept. & the other contains data relating to labor by dept. ...

Chris Gierlack (5/4/2009)

---

What do you mean delete the 'field' and re-add it to the report. This is in the main nav bar for paging through any report. It...

Syed Mehroz Alam (4/29/2009)

---

Hi all,

I want to add a horizontal line that spans the whole page in a page header. I am using a matrix inside the body so the...

This does seem weird. Try deleting the field and re-adding it to the report.

Below is the script that generates the summary report

*******************************************************

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_NULLS ON

GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[apus_sp_rpt_FSARefunds]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)

drop procedure...

Luke L (2/13/2009)

---

Where is the timeout occurring, on the report server or at the source database?

Have you looked at a trace of this query to see what is happening at...

suresh,

Try this: -

select OrderFormNo

,ClientName

,OrderDate

,Product

,sum(Value)

,InvoiceQuantity

,PendingQuantity

from AOM_Tbl_PendingOrders

group by OrderFormNo, ClientName,OrderDate,Product,InvoiceQuantity,PendingQuantity

In your case, remember that whenever you use the group by clause you need to add all the other colums...

Okay. Thank you. I will try a couple of scenarios. I appreciate all your help.

Hello CrazyMan,

This is something that we just started incorporating into most of our linked server scripts. We have not really looked into it that much to check for any...