Have you tried creating three seperate Excel data sources?

yudy.varma (10/11/2012)

---

i have to sort the data based on the condition "stock level < re order level" ,stock level < re order level rows must come first. can anybody tell...

That's a pretty broad question, so a "it depends" is probably appropriate. But a user defined function has to execute on each individual row. I'd go with the...

davdam8 (10/11/2012)

---

While clicking in a textbox, wich is suppose to redirect me to another report, I get this error message:

'The value of the top property for the textbox 'textbox1' is...

I'm not sure why you wouldn't...

If it's relatively simple math, you could just create an expression for the percent change fields. Something like:

=FormatPercent((Fields!2002.Value) / (Fields!2001.Value), 2)

Note: the math above is probably not what you...

In your cube, how do you know if something is open or closed? You must have a dimension that describes the status. Where is that? That's what...

Have you tried it? What did you find? Go to your test environment and try some test examples in SSRS.

Rob

One thought is that you could do an OPENROWSET...

mubarak.a (10/8/2012)

---

Hi,

I'm new in SQL Server, i want the working process of STUFF & ISNULL. How it works & how it concatenate the row level data into a single data?...

REMOVED

Report Builder 3.0 can use a SSAS cube for its datasource. What makes you think it can't?

Create a new Data Source. Choose the 'Microsoft SQL Server Analysis Services'...

In SSRS you would use the CDate() function to change from varchar() to datetime; but the issue is that you have non-date values (Amber) mixed into that column. Check...

Are you trying to use SSRS to connect to a SSAS cube? or SSRS to connect to an DB2 OLAP source?

Either way, you should be able to create...

Rather than using the Lookup() function, can you join the tables in your SELECT?

Rob

I still think you have data that isn't a date. Can you take the SQL out of your dataset and manually run it in SMSS? What does that...