(UTC)
  Lantica User Forum › Archived Topics › Archived Topics › Reports using subforms
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 Send Topic Send Topic Print Print
Normal Topic Reports using subforms (Read 2716 times)
beagle
Junior Member
**
Offline


No personal text

Posts: 80
Location: australia
Joined: May 28th, 2004
Reports using subforms
Jan 15th, 2005 at 2:06am
Print Post Print Post  
Just after some thoughts on this

I have an application that is similar to an invoicing system with a parent record containing a customers detail & a subform with item details.

I can generate a report sorted by customer - showing the items that a customer has been offered.

However i'm having problems generating a report which shows what customers have been offered a particular item (sorted by item).

Is this possible with Sesame or am I better off exporting the data to a spreadsheet (excel) & using its functionality ?

Many thanks in advance
  
Back to top
 
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: Reports using subforms
Reply #1 - Jan 15th, 2005 at 5:09am
Print Post Print Post  
Add a bound element to the sub form (child) that gets the Customer name from the Parent form when sub record is added.  Element can be invisible.

But use the child forms (Item) to retrieve records for that report vs. using the Parent form.  Can now sort by Customer and Item... or sort by Item and Customer.
« Last Edit: Jan 15th, 2005 at 10:25pm by Bob_Hansen »  


Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
WWW WWW Skype/VoIP Skype/VoIP  
IP Logged
 
beagle
Junior Member
**
Offline


No personal text

Posts: 80
Location: australia
Joined: May 28th, 2004
Re: Reports using subforms
Reply #2 - Jan 15th, 2005 at 10:05pm
Print Post Print Post  
BRILLIANT!

Hi Bob,
Thanks heaps, having a mental block on that one Grin.
  
Back to top
 
IP Logged
 
Steve_in_Texas
Senior Member
*****
Offline


No personal text

Posts: 893
Location: San Antonio
Joined: Feb 21st, 2004
Re: Reports using subforms
Reply #3 - Jan 16th, 2005 at 5:55pm
Print Post Print Post  
Could you get the same results by running an Xlookup during the printing of the report?

I just posted a similar issue and Bob's technique would work for me, but I don't want to 'weigh down' my app with duplicate fields just for the sake of reports.

I guess I'm wondering how much Sbasic can be used  during the "On Print" event.

Thanks,
Steve
  
Back to top
WWW WWW  
IP Logged
 
Page Index Toggle Pages: 1
Send Topic Send Topic Print Print
‹ Previous Topic | Next Topic ›
 
  « Board Index ‹ Board Top  

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid RSS Valid XHTML Valid CSS Powered by Perl Source Forge