Forum post
Question on Preview Mode lack of support
Forum post posted July 20, 2010 by amfca, last edited February 9, 2012
534 Views, 7 Comments
Title:
Question on Preview Mode lack of support
Post:
First off, I am so happy to see FM on Ipad. Thank you FMI.
With the lack of preview mode support in FM Go, I am not able to do much in the way of sub summarized data reports with grouping and totals on data. How do you experienced FM developers see this limitation effecting you?
Trying a layout report on the Ipad with 3 sub summary levels and a trailing grand total area, I get one page for each individual record. This is a pretty big limitation I think. Am I missing something here? I need the ability to have preview reports that are useful on grouped levels with subtotals and grand totals.
Thanks
Answer
amf:
Thank you for your post.
In the bottom left corner of the screen, tap the Layout icon and select the Layout used for the Sub-summarized report. Then, tap the icon in the lower right corner (horizontal lines with a magnifying glass) and select "Sort Records...". Select the 3 sub-summary fields you want to sort by and click Apply. You should now see the data presented with the Sub-summary information.
Let me know if you need clarification for any of the above steps.
TSGal
FileMaker, Inc.
Be the first to like this
|
Sign in to "Like"
TSGal
Thanks for your reply. Sorry for the delay reply, but I have been on vacation.
When trying to use the sort records icon as you posted about, it appears that the available fields to choose from are only those listed on the current layout and not necessarily the current table. This seems to be different than FM Pro. My layout preview report in FM Pro uses a sort field that does not appear on the report layout. I can not choose this field.
p.s. I would have responded sooner on vacation, but I only had my Ipad with me. The FM Forum does not allow an Ipad user to enter text into the reply field when trying to reply to a post. Have you tried this?
Thanks again
Alan
Be the first to like this
|
Sign in to "Like"
amf:
Thank you for the clarification.
Yes, it appears you cannot sort by a field that is not on the layout. I have reported this to our Development and Software Quality Assurance (Testing) departments for review and confirmation. I will keep you posted as information becomes available to me.
As a possible workaround, put that field on the layout and make it hidden. That way, the field will then be included in the sort. Or, if you are connecting as a guest to a FileMaker Pro file, include a script that sorts by that field and then execute that script in FileMaker Go.
TSGal
FileMaker, Inc.
Be the first to like this
|
Sign in to "Like"
TSGal:
Yes, I do have a script that sets the sort field from the other table, and that provides the functionality of correct sort. But my report does not work as intended due to sub summary limitations without preview mode.
Be the first to like this
|
Sign in to "Like"
amf:
I have set up a report with no Body part and the report displays the Sub-Summary and Grand Summary. The 178 records now display 6 lines of data; both on the Mac and FileMaker Go.
Can you describe your layout in more detail? Do you have some screenshots? Perhaps it would be easier to send in your database file so I can see the problem. Check your Inbox at the top of this page for instructions where to send the file.
TSGal
FileMaker, Inc.
Be the first to like this
|
Sign in to "Like"
amf:
I received your file. Thank you.
You don't need Preview support. The file displays the same in List View. To verify, open the file in FileMaker Go, perform the same steps, but select the "Sales by Model Report" layout, and turn on List View. This shows me exactly what is displayed in Preview mode on the Mac. Let me know if you are unable to reproduce.
TSGal
FileMaker, Inc.
Be the first to like this
|
Sign in to "Like"
TSGal:
Thanks so much. I feel a bit silly about missing that. Guess since my non iPad app is all in preview mode for displaying report data, I never use list mode! Indeed this does show same results, but will lack "sliding" features found in preview mode. I can live with that for the meantime.
Thanks again for your support!
Alan
Be the first to like this
|
Sign in to "Like"