Point of Success Roundtable Home
Home Search search Menu menu Not logged in - Login | Register
Point of Success Roundtable > All Forums > Report Customizations > Also interested in bar subtotal - basic code question

Also interested in bar subtotal - basic code question
 Moderated by: garyt
 New Topic   Reply   Printer Friendly 
 Rate Topic 
AuthorPost
 Posted: Mon Jun 13th, 2016 04:45 am
   PM  Quote  Reply 
1st Post
TheCoveMotel
Verified
 

Joined: Wed Feb 24th, 2016
Location:  
Posts: 1
Status: 
Offline

  back to top

I'm comfortable with VBA and SQL, but am struggling to find examples or help files to assist with learning the syntax for POS reports.

I have the fields I need in a modified Customer Receipt report (no issue with SQL).

I tried defining a bar_total variable at the report level and then accessing the variable at the detail level so that I could keep running sums of bar and food. (I would then print the running sum at the footer level) This wouldn't compile. Can you access report level variables from detail or footer?

I'm sure the bar and food subtotals can be done in other ways (subreport, etc.)(would be happy to see one!), but I'd like to learn my way around the code.

I know that you can fill out a custom report request, but I'd prefer to just learn the basics.

Thanks so much for any answers / resources / sample reports.



 Posted: Mon Jun 13th, 2016 03:13 pm
   PM  Quote  Reply 
2nd Post
garyt
Administrator


Joined: Fri Aug 6th, 2010
Location: Mesa, Arizona USA
Posts: 1615
Status: 
Offline

  back to top

We do not offer custom report training but do offer custom reporting services.  I've attached a custom report request for you convenience.

Attachment: POS Custom Reports.pdf (Downloaded 31 times)



 Posted: Tue Jun 14th, 2016 12:43 am
   PM  Quote  Reply 
3rd Post
Daddio
Verified


Joined: Thu May 24th, 2007
Location: Grande Prairie, Alberta Canada
Posts: 383
Status: 
Offline

  back to top

I think TheCoveMotel may have the idea that this forum still follows the pinned thread by Jeff Ward.

Jeff Ward wrote:The Report Customizations forum is for sharing report customizations you have done with other users. If you have created a custom report, tell the other forum users about it in a new topic, then zip the report template and attach it to your message.

You may on occasion get one of the other forum participants to help you with a report you're trying to change.



 Posted: Tue Jun 14th, 2016 03:22 pm
   PM  Quote  Reply 
4th Post
Jeff Ward
Administrator


Joined: Mon May 21st, 2007
Location: Mesa, Arizona USA
Posts: 2874
Status: 
Offline

  back to top

Point of Success is written in Delphi and the reporting module follows the same general form in its code.

The component is produced by Digital Metaphors. Go to their web site at http://www.digital-metaphors.com and you can find documentation there.



 Current time is 08:52 am
Point of Success Roundtable > All Forums > Report Customizations > Also interested in bar subtotal - basic code question
Top




UltraBB 1.172 Copyright © 2007-2011 Data 1 Systems