NickFaraday4

Ok I have a summary report that groups a bunch of records in various sizes and have a summary count field to let me know how many records are in each grouping. Is there a way to set conditional formatting when I breach a total number of records ceiling, but only format the group at which the breach occurred? So right now I have a field that shows a "running total" and I can set the conditional format to trip for all the records after a record number ceiling has been breached, but what I want to do is only highlight the group where the ceiling was passed not all groups after. Any Ideas?

I'm having some issues with a calculated field.... I have a bunch of invoices with line items each line items has a number of boxes the items come in. I have a summary field that gives me total number of boxes in an invoice. Next I have a calcualted field that determines the number of pallets a given invoice will require based on the summary field. When I put these fields into a sub-summary based on Invoice ID the summary of boxes field works correctly, but my pallet calculation gives me the total pallets for every invocie in the review. (IE its calculating based on the total boxes in the found set) Not sure what going on here... An example of my report (where you can get 4 boxes per pallet) What I get: Invoice Boxes Pallets 123 16 9 232 8 9 838 12 9 What I want: Invoice Boxes Pallets 123 16 4 232 8 2 838 12 3

LMAO ok, so a portal with 1000 rows... looks like that works. Thanks

I'm having an issue creating a report, hope someone can help. Ok so here's what I'm trying to do: I have a List of Records (say list A), then I have records in another table (: that are related to list A. I want to display of list of records (list A) and under each record, that records related info. Example. LIST A TREE BOAT FISH CAR Related Records in Table B TREE BARN TREE SKY TREE WATER BOAT BARN BOAT SKY CAR PAINT SO I want to build a report that shows TREE - BARN - SKY - WATER BOAT - BARN - SKY FISH CAR - PAIN If I use Table B as the layout source I wont get record "FISH" in the final report because there is no related "FISH" record in table B. Thanks in advance

I'm trying to export a layout that has 2nd generation calculated fields on it and I'm having some issues. IE: My calculated field is two levels deep, the first field preforms a list() to get a string of related data, then the second (the display calculation) is a parse of that string. The calculation works fine in both standard view and preview modes, but when exporting to CVS, excel, tab, etc the calculations are all 0? What am I missing here?

LOL, thats what I love about the FM community! There's always some kind of horrible hack to get something done. When I say horizontal portal row, I'm was discussing an actual layout object, which FM currently does not have. Speak of... how do you get portals to start on different rows? Some kind of filter I'd guess?

Ahh that might just work... Thanks I'll give "list" a look! err, exactly, but they were quite adamant about everything being on one "row" limited to the first few item records! go figure.

I have a DB with shippers and shipping items. Shipper is a table, shipping items is a related table. The client wants to have a shippers summary page that shows all the shippers in oneline list type layout layout, which is easy enough, but they also want to see/be able to search the first 3 items in the shipper all in one line. (so columns line up) I know we can't to horizontal portal rows, is there a way to get around this? maybe via calculated fields? IE: Shipper ID, Date, Number of Items, [color:red]Item 1, Item 2, Item 3 Shipper ID, Date, Number of Items, [color:red]Item 1, Item 2, Item 3 Shipper ID, Date, Number of Items, [color:red]Item 1, Item 2, Item 3 Shipper ID, Date, Number of Items, [color:red]Item 1, Item 2, Item 3