Ah, I see now... thanks for your help so far!

I got the SQL looking like this now:

SELECT MAX(ttLocation.LOCATION) AS Expr2, ttSessions.START_TIME, ttSessions.END_TIME, ttSessions.LEVEL, ttSessions.COST, ttDayOfWeek.DAY,

...

You lost me there - MAX?

I've also got to admit I'm not a DBA by any means either!

Could you elaborate on your answer a little please?

SELECT ttLocation.LOCATION, ttDayOfWeek.DAY AS...

Found a workaround:

In the same report, create a new Dataset, using the same Data Source, and run the same query limiting it to only yesterday's date, and then reference that...

What error are you seeing?

🙂 I wish.. there's no option there for it unfortunately.

David

Would love to, as it makes sense.. however my background is network and web infrastructure and security, not DBA. So my skills here are limited to say the least!

Hi. Thanks for getting back to me. This makes sense, although there's no option to add a table footer as it's a Matrix as opposed to a normal table.

You were...

Thanks Wendy - that makes sense too.

I've also found another way - although it's cheating and is bit dirty too:

In the layout tab, between the items you would like to...

Hi Vandy.

Thanks for the reply, but I'm still really new to all of this so am not sure what you mean.. group, how?

Thanks,

David

I went back to basics, and the answer was staring at me in the face all time... very simple:

I created a new dataset, executing this query:

SELECT TRANSACTION_TYPE,

COUNT(*) as...

Thanks Jens.

Tried it and it kinda worked, but not for what i was looking for.

I went back to basics, and the answer was staring at me in the face all...

What type of graph is it? If you're talking about a Column Graph (where the results are vertical) then just change it (through the properties of the graph itself) into...

Hi Mal.

Thanks for the reply and I gave it a go... seems to throw some other errors at me though. Here's the actual original SQL Statement too.. maybe it'll throw...

I've followed some guidelines mentioned in these forums and one of them is setting up another dataset that you can use as default settings for the parameters. So I can...

Hiya.

What I'm basically trying to do is run a simple report (for yesterday's date in this case) that shows turnover.

It's querying an oracle DB (query pasted below) and the...