Hi Richard,

You could go along the lines of users have access to the spreadsheets, and therefore, you'll have poor/no control over the data they capture. Perhaps you could suggest the...

Hello,

Please if anyone has any thoughts or suggestions I would really appreciate it. If the post isn't clear enough, let me know and I'll try put my question accross...

John is absolutely right on this one. I don't know Oracle, but perhaps it is possible to setup replication to push\pull the records from Oracle to SQL as they get...

I think I get it now, are you wanting SSRS to generate an individual web page per customer? Wow, well if anybody has managed to do that I would like...

Could you be a bit more specific please? I just want to understand what it is exactly that you are asking before I contemplate an answer.

Hello, when you say "Arrows" could you be a bit more specific? I mean, are you using the back and forward buttons in internet explorer or is it something else?

Hi

I haven't tried this before, but I think you can do this. Let's say you want the column to be visible if there is data. You could set the visibility...

Hi Ben,

We had exactly the same issue. You can use this technet article to get you through it:

http://technet.microsoft.com/en-us/library/dd335966.aspx

You will need to install sp2.

Regards,

William

Hi Al,

Not really sure exactly what it is you are looking for. If you are looking to display a report that shows details of one customer, then, you could create...

As Steve said, use isnull() for your first question. As for your second question, I don't think that your sql query will have any effect on the column width or...

I think you can use the join() function to link the parameters. e.g.: =join(Parameters!ParameterName.Value, " ") - should join the values together with a space.

Hi,

In AS your dimension table has to account for all the foreign keys in the fact table. How can you have a foreign key value in a transactional(FACT) table that...

You can use the query I supplied for exactly that purpose. Just drop the last 2 columns...

Hi sql_prodigy,

You could try:

select PublicIdentifier

, Currency = case when isnull(CurrencyOld) = 1 then CurrencyNew else CurrencyOld

, Balance = case when isnull(BalanceOld) = 1 then BalanceNew else BalanceOld

, IsNewCurrency = case...

Hi All,

I am really interested to know why using MONEY data type in calculations can return incorrect results? Is there a sql legend out there who can give us all...