Report writing questions

CalD

I have a few questions with reports - first time coming to write a report...

Firstly is there a good guide to reports and the report designer, I am struggling to find it, either as a video or in the docs/help? there seems to be plenty about working with word but this is not what I want...

1) Can I write a report with multiple sections from different bo's? i.e could I have a list of Revenue Items followed by a list of expense items followed by a list of Dog breeds? seems to me it all needs to be related to one query?

2) Excel, do I need excel installed to make excel docs work on my dev server? currently have aware installed on rdp server it looks like I need excel? which is troublesome without the correct MS license for it

3) when working with excel docs or other types can I do as per number one above, I'd like to produce an excel sheet but it does need to be able to have multiple sections which are only really related by their date - they are completely different bo's/data

Anything else that can help with reporting/excel?

Thanks
Callum
v7 build 2171

kklosson

1) You can use embedded reports. The embedded report can be based on any query. I've pushed reports to the limit so look me up if you get stuck.

2) You need Excel installed on your server, same for Word if you use it.

3) Can't help on that one.

CalD

Thanks for the reply,

Just to be clear as I am new to aware and I may be missing something.

When using embedded reports/queries I can have one bo, linked into other bo's by way of shortcut attributes but that is all?

So if I want to print all orders for a week and have it formatted as order header, then multiple lines of info I can't do that?
I Must be mistaken...

CalD

Searching the forum again, seems Jasper is the answer?

BLOMASKY

Like a few others here, I have chosen to use JasperReports for my reporting needs. It is like the built in report writer on STEROIDS. (lucky they have not outlawed steroids for software... yet..)

It has a much more powerful report designer!
Layout, (color, fonts position, sub reports) is much more extensive
It can seamlessly be integrated into your Aware solution
It's Free!

Bruce

BenHayat

BLOMASKY wrote
Like a few others here, I have chosen to use JasperReports for my reporting needs. It is like the built in report writer on STEROIDS. (lucky they have not outlawed steroids for software... yet..)

It has a much more powerful report designer!
Layout, (color, fonts position, sub reports) is much more extensive
It can seamlessly be integrated into your Aware solution
It's Free!

Bruce

Hey Bruce Lee, I need to watch your recent session.