bdam

Unless I'm missing something, that doesn't solve the problem. I am looking to to perform a find in the parent table using fields from one or more child tables. So I can't find the parent and then go to the child tables because without the child tables I can't find the correct records in the parent table.

Unfortunatly no; in troubleshooting I whittled down the problem to be simple. Ultimately we need to create a find that uses fields from the parent and possibly multiple child tables.

I am looking to export data from a layout called webdata in a database called Books from our FM Server 11 Advanced using the XML functionality of the Web Publishing Engine. I have a layout which is based on the main Books table with all of the fields I need. What I'm looking to do is to get a list of in print book records. We have a seperate table which has mutliple records for each book to track when the statuses were active. This table includes a field to indicate that this is the current status and have verification set up to ensure that only one record per book is marked current. Using a table occurance of the status table I am able to filter down to just the current status for each book. The filtering is not based on global fields. The problem I am having is that when I use the related field (Current_Status::print_status_code) in an XML query to find in print (IP) books it returns every record in the Books table. If I do this query using the FileMaker client it works just fine and returns the correct set of records. If I do a query based on fields in the Books table it works as expected. Here is the query with the server info removed: .../fmi/xml/fmresultset.xml?-db=Books&-lay=webdata&Current_Status::print_status_code=IP&-find I also tried using a pre-find script that would peform the find in the script but again that gave me every record. I assume that's because the script has no relevance for the XML query. Any ideas? Bryan

So we recently moved from Server 8.5 to Server 11. I have a bit of an odd import process that I would like to schedule but can't quite figure out how to do it. At the first of each month we run a bunch of queries on our iSeries and need to import that into offline FileMaker files. So I have an offline FileMaker file that is a template. On the first of each month I need to run the import script in the template and then copy that template out to another directory. From what I can tell, you cannot run a script in an offline file using the FileMaker Server scheduler. The schedule wizard only shows hosted databases and if I try running a script which in turn tries to run a script in the offline file it errors out at that script step. Any ideas?

I'll send a bug report. I hope you don't mind me using your example file to create a screen shot to better describe the problem.

Actually, you understood the problem perfectly, and solved it at the same time. To see what I mean, in your example change the chart style to curve fitting. You'll see that your partial line takes a nose dive to zero.

All four.

The chart type is Current Record (Delimited Data). I have four calculation fields that create this delimited data, 12 values in each that correspond to the months of the year. I then add these fields to the Y axis. So the field that creates data for the current year won't have 12 values and I'm trying to figure out how to make that a partial line instead of a line that bottoms out at zero. If I only state 9 data points it still maps the remaining ones to zero to fill out the line.

I have a chart that lists the sales by months. There is a data set for the current and last 3 years. I am accomplishing this with calculation fields that create a delimited set of data. The current year's data obviously isn't complete so the graph just nose dives to zero for future months. Is there a way to have the current year's line be partial and not plot future months? The sales guys always jump a little inside when they see that initially.

Excellent, thanks for explaining that. I wouldn't have thought the radio buttons would interact like that across field instances.

You have the right idea, but I should have mentioned that they are horizontal, not vertical. The best solution I have come up with is to make some funky value list(s) of spaces and manually put the labels in similar to what you suggest.

This is one of those things that might be staring me right in the face but I can't figure out nor can I find any threads here discussing it. By default radio and checkbox selections always show the button/checkbox to the left of the value it represents. Is there a way to align them to the right? I am mimicking some vendor supplied form in a layout and they are right aligned. I can think of a couple ways to hack it but I thought I would see if there's a 'correct' way to do it.

This being the first go around with charts I'm not expecting much but has anyone tried extending the horizontal bar charts to get a Gantt-like appearance? I've played around with it for a bit and I couldn't do it. And again, it wouldn't surprise me if this isn't possible yet.

If using group by fields to calculate totals when exporting to Excel it adds the totals in a new column for the first record in the group. Is there anyway to control and change this behavior? For instance, put the totals at the bottom or ideally in a new row? My intuition is to say no but I thought I would throw it out there.

YES! That's the ticket. Thanks for catching that.