What table reference is your report layout using? In other words when you enter layout mode and examine the layout set up, what table is listed?
I have tried in both Item and Estate. It should be Item correct?
I would start by finding the items of the current estate - this is easy by calling the Go to Related Record [Show related only] script step. Sort the items by the parent_room field, and include a sub-summary part by the same field. Place the estate details (fields from the Estate table) in the header part, and the room details in the sub-summary part.
Yes! we needed to resolve that potential problem first. So if I understand the issue, your report lists in proper format with the desired Estate, room and item information, but you have all the estates instead of just one Estate.
If that's correct, you simply need to manipulate the found set to only contain the records for a given estate. There are multiple methods for doing this. Here's the most straight forward approach that I can think of.
With your report layout as the current layout, simply enter find mode, enter whatever information that uniquely identifies one Estate record in your estates table and perform the find.
This works if the needed fields are visible on your layout.
This find mode works, but ideally i would like to have a button on my "estate entry" layout that simply generates the report.
I'd rather not have to reexplain to people that they need to search everytime the need a report.
You can create find requests in scripts and perform them.
Your script looks like this:
Set Variable $Estate, Estate:: parent_Estate
Go To layout ItemsReport
Enter Find Mode
Set Field Estate:: Parent_Estate, $Estate
Attach this script to your button.
ill have to try later, but this seems like what i am looking for. I am used to access/mysql and would have used a query (maybe should have said that earlier)
I'm bilingual, been using both systems for years. Using a script to set up a found set is roughly the same as using a SQL query as your form's record source.
OK! Great! Its working the way i want.
now.. can i make the body height dynamic? Like if i have a description for one item that is 6 lines, i would wnt it to be 6 lines tall, but if its only 1 line, i dont want wasted space.
You know how you can set things to "grow" or "Shrink" in MS Access right? Well in Filemaker, we call it "sliding up." This is the same as "shrink" but we can't "grow".
Size your field to the maximum possible field height, then select "Set sliding/printing" from the Format menu. Choose your sliding up option and then select "Also reduce the size of the enclosing part." This feature is not visible in browse or find mode, but will be visible in Preview mode and when you print the report.
the field in question is my description field. I was hoping to have it grow to fit, thus bumping records down, if a description was long. previously, i was not limiting the length of the description
is the way around this to make my description field have a limit on its length in the table? then, size the field in the report to fit the max entry?
You can specify the maximum number of characters permitted in your field definition (Look on the validation tab after pulling up field options). Unfortunately, this only gives you a rough approximation of how many lines of text this will work out to as the proportional fonts we use today take up varying amounts of space depending on the letter used. If you can size your field to be enough larger than the max character count you specify, this might work.
If you need tighter control, search the other threads or maybe start a new thread on this subject. I thought I spotted another thread where someone had a way to use a design function for this.