amontague Posted August 31, 2005 Share Posted August 31, 2005 I'm working on a (supposedly) simple invoicing database and I've made good progress thanks to the help I've had in this forum. I have an Invoices table and a lineitems table. I have a portal on the invoices table showing quantity, description and price from the lineitems table. In browse mode, everything is showing up in the right places. However, if I try to print or if I view in Preview mode, none of the portal rows show up. I've looked at Sliding/Printing but the items aren't checked to stop them printing. Any ideas? Regards Andrew Link to comment Share on other sites More sharing options...
RalphL Posted September 1, 2005 Share Posted September 1, 2005 I don't know what is causing your problem, but portals aren't designed fro printing. I suggest that you print the invoice from the lineitems table. Use the list/report layout. You will get a better report. Link to comment Share on other sites More sharing options...
amontague Posted September 1, 2005 Author Share Posted September 1, 2005 I realise that the list/report layout is the way to go, but I'd still be interested in finding out why I can't get a quick and dirty printout from the portals. Thanks Andrew Link to comment Share on other sites More sharing options...
SlimJim Posted September 1, 2005 Share Posted September 1, 2005 This is strange. Despite it not being the recommended way I always print my invoices with a line-items portal in the body and have had no problem. Is it possible that your portal is overlapping a summary part - although I'm not sure that would cause this problem. Link to comment Share on other sites More sharing options...
amontague Posted September 1, 2005 Author Share Posted September 1, 2005 No, there's no summary part in the layout. The weird thing is that all the portal fields are displaying as they should in browse mode, but all portal fields are empty in preview mode. Andrew Link to comment Share on other sites More sharing options...
RalphL Posted September 1, 2005 Share Posted September 1, 2005 When you go to the preview mode you go to the first page. Is it posible that the first page has no related records. Try this little procedure: Show all records Omit current record Show omitted Enter preview mode Now you should only see the current record in the preview mode. Link to comment Share on other sites More sharing options...
Sanjai Posted September 1, 2005 Share Posted September 1, 2005 Ralph is right. The records in portal are not reflected in preview mode unless the current record is the only record in the foundset. If the portal contains a scroll bar and the number of records could be more then the number of portal rows displayed or if you don't want to do show all records then I would advise to print the records from the child file directly which would help you to see all the records with header information from the primary file. Link to comment Share on other sites More sharing options...
amontague Posted September 2, 2005 Author Share Posted September 2, 2005 Hi Ralph, You were right. Great catch. It works when I follow your instructions. That's certainly not something that's intuitive. Thanks Andrew Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6669 days old. Please don't post here. Open a new topic instead.
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 accountSign in
Already have an account? Sign in here.
Sign In Now