Jump to content
Sign in to follow this  
sal88

Repetitions leaving blank sections

Recommended Posts

Hi, I have set up an invoice layout, with each record having a few fields that repeat 12 times. However, often the number of fields doesn't reach this number, so i am left with a lot of blank space between each record. Is there any way to solve this problem ie so that the body section shrinks if the repetitions do not reach the max.

The closest I've come is to just make multiple reports with different numbers of repetitions and then when it comes to printing the script can choose the best one.

any ideas?

many thanks

Share this post


Link to post
Share on other sites

It's best to avoid repeating fields, in general. I would think many would agree.

Instead, you can create an Invoice Line Item table that relates to an invoice record.

Then, you can have one record per invoice line item. If you need an example, let me know!

Martha

Share this post


Link to post
Share on other sites

An example would be great thanks, Im getting a bit confused, as currently each record/product is separated by a line, using your method that one record will become X records (as each record has fields repeating X number of times). But will i still be able to show it the same way as before, with a line separating each set of records that have the same product number. if that makes any sense.

yeah an example would be perfect lol.

Share this post


Link to post
Share on other sites

Attached!

It's a bit crude but I hope it makes the point.

You'll see that the portal is connected to a Line Item table. So when you add stuff to the line item table related on an invoice and then click on the button, you'll be taken to the Line Item table and the header can be data from the related invoice!

Martha

Test.fp7.zip

Share this post


Link to post
Share on other sites

cheers, that has made the record structuring clearer. I'm still not sure though on how to set out the records exactly as i want though.

Using the record structure in your example my records will look like this:

med_1176977737-1.GIF

Here is how i would like it to show on the invoice layout:

med_1176977965-2.GIF

with it being grouped firstly by invoice number and then product ID

I seem to remember it could be done in access with grouping or something like that.

many thanks

1.GIF

2.GIF

Edited by Guest

Share this post


Link to post
Share on other sites

You can do those types of summaries with Summary Parts.

I've changed the script that takes you to the invoice. Check it out....

:)

Test.zip

Share this post


Link to post
Share on other sites

thats spot on thankyou sooo much!!!!! was a bit confused when it came to making my own, but it was the "allow creation of new record" in the relationship setting that i was missing.

thanku

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.