Newbie - Getting a basic report 'Body' to work

Classic Servoy
1

Hi,

I hope this is simple. I have a report I am trying to build based on a quotes table which has a 1 to many link to an items table (items in the quote). My user forms all work great with either portals or tab panels.

What I want to do now, is have a report for ONE Quote and list the items related to this quote line by line. I thought this would be easy??? I have created the report based on the quotes table and have tried adding the items fields into the body Part using a relation

eg items_to_quotes.description - this prints only the first item

And I have tried using a portal with PrintSliding enabled - this does not grow vertically and only shows the records limited to it’s size in Designer mode.

Do I have to run an SQL statement to get the right foundset or should this be working.

Dave

2

Hi Dave,

In this situation, the general rulke of thumb would be to run the ‘report’ from the items table

Create a list form in the items table with the body showing each of the line item records in list view.

The header contains the related data from the Quote header record and the footer contains whatever totalling fields etc that you want to show.

The list view will grow and shrink based upon the number of line item records which exist !

Hope this helps
Cheers
Harry

3

Harry,

Thanks again.

You know, it is amazing what simple things you can miss when you’ve been staring at a solution for 14 hours and it’s 1AM…

Thanks again for you help.

Dave. :)

4

Harry,

You wouldn’t happen to know how I can setup a form so that it graphically represents A4? Otherwise, I need to keep running the report and then adjusting the fields layout to make it fit?

Also - I assume iso-a4 is = A4??

Finally, I imported a JPEG of a clients logo and it just shows up as vertical lines (like a barcode). What image formats do Servoy support?

Sorry to bombard you but I figured you may know all of this and be bale to answer in one question. My deadline is looming…

Thanks in advance

Dave.

5

Hi Dave,

Perhaps a quick way for you to get a good format for the layout would be to look through the CRM solution which comes as a standard install with Servoy.

There are A4 forms for Orders and Faxes where you may be able to take those settings from those forms and reuse them in your own !?

How did you import the logo ?

Did you bring it into the image media library or import straight into a blob field ?

Servoy supports most, if not all !, types of image - gif, jpg, png

Harry

6

Harry,

Thanks again. I was using the import into the library. I tried a PNG and it worked fine. I think it may have been a Photoshop issue.

I will look at the CRM. I have been using that for a lot of tips but did not realise the reports were A4 in that. Thanks again.

I am a lot closer to getting this first solution out now.

Dave.