Jump to content
Sign in to follow this  
SmithTM

Row per Layout Object

Recommended Posts

Thanks for looking at my question. I'm new to FileMaker, having been in other environments since the mid '80s.

We have a need to make a report that shows somewhat complex engineering data. We have the data in a table that is keyed by QuoteID and DataTag and DataTagSequence. The QuoteID would be related to other tables. The DataTag identifies the a particular piece of data (like a field name). The DataTagSequence allows for the nature of the data - unpredicatable number of entries in any particular DataTag. That is the sticky point - without that consideration we could pivot or crossTab the data into a single row by QuoteID.

Anyway, I can't figure out a way to report the various dataTags on a single page type report.

If I was using some of the Reporting tools with which I am familiar, I would add an object to the layout and type simple SQL to grab the data. Such as (SELECT value FROM table WHERE QuoteID = variable AND DataTag = "F208") This would return all rows related to the F208 DataTag to the layout object. This would allow me to place the various DataTags in appropriate locations on the form.

Is there a comparable object in FileMaker?

Share this post


Link to post
Share on other sites

I am not sure what you are trying to do. Maybe you could post a sample file or some pictures of what you are trying to report.

Edited by Guest

Share this post


Link to post
Share on other sites

Here are 2 mockups of data with an associated basic mockup of a form layout.

Note that the data can change: there may be varying numbers of sequences. This makes it difficult to change the data structure (schema) to a single row. Also note that there are more than 500 DataTags per quote.

Sample1.JPG

Sample2.JPG

Share this post


Link to post
Share on other sites

Thank You, this helps. I will look at it in detail latter today. I have an appoint this morning.

Share this post


Link to post
Share on other sites

Based on the information you provided, I put together a sample database for the 2 Quotes you showed. This database has a report that displays the data you what to show in a different form. Take a look at it and then we answer questions.

FMF20081230.fp7.zip

Edited by Guest

Share this post


Link to post
Share on other sites

Thanks Ralph!

With your example and some more reading in the Help system, I was able to at least get the report with breaks idea working.

I deeply appreciate your expertise.

Thanks again

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.