Home Page link  

Adding multiple tables in one report

 

Point-Of-Sale Software - - MS Point Of Sale software discussed here 

get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
Adding multiple tables in one report Ed Whitbeck 02-23-2007
Posted by Ed Whitbeck on February 23, 2007, 2:45 pm
Please log in for more thread options
I am trying to customize the default report Daily Detailed Sales with Tax.
What i need to do is add the Tender Type (Credit card / cash / check) as
another column in the report.

So far i have found out:
i need to add a column
i need to import the TenderEntry table for the data

I need to find out:
How to import another table


I have tried to import the table using sql UNION function, but that wont
work for me either. any help would be greatly appriciated.

Thank You

Posted by Akber Alwani on February 24, 2007, 7:37 am
Please log in for more thread options
Hi ED,
The things make sense to me regarding the adding tables and fields which you
can do and customized the .grp file. but my doubt is why you wanted to add
another tables. what information you are looking for.

Let me know first do you know the customization in .grp (active reports)
file if not then i can help you. second what you r data is and what exactly
you want.

"Ed Whitbeck" wrote:

> I am trying to customize the default report Daily Detailed Sales with Tax.
> What i need to do is add the Tender Type (Credit card / cash / check) as
> another column in the report.
>
> So far i have found out:
> i need to add a column
> i need to import the TenderEntry table for the data
>
> I need to find out:
> How to import another table
>
>
> I have tried to import the table using sql UNION function, but that wont
> work for me either. any help would be greatly appriciated.
>
> Thank You

Posted by Ed Whitbeck on February 26, 2007, 10:07 am
Please log in for more thread options
I am trying to customize the default report Daily Detailed Sales with Tax.grp
What I need to do is add the Tender Type or Tender.Description (Credit card
/ cash / check) as another column in the report.

"Akber Alwani" wrote:

> Hi ED,
> The things make sense to me regarding the adding tables and fields which you
> can do and customized the .grp file. but my doubt is why you wanted to add
> another tables. what information you are looking for.
>
> Let me know first do you know the customization in .grp (active reports)
> file if not then i can help you. second what you r data is and what exactly
> you want.
>
> "Ed Whitbeck" wrote:
>
> > I am trying to customize the default report Daily Detailed Sales with Tax.
> > What i need to do is add the Tender Type (Credit card / cash / check) as
> > another column in the report.
> >
> > So far i have found out:
> > i need to add a column
> > i need to import the TenderEntry table for the data
> >
> > I need to find out:
> > How to import another table
> >
> >
> > I have tried to import the table using sql UNION function, but that wont
> > work for me either. any help would be greatly appriciated.
> >
> > Thank You

Posted by Akber Alwani on February 26, 2007, 2:48 pm
Please log in for more thread options
Hi ED, it is night here 11:00 I can do the customization for you i.e. add the
columns you requested by tommorow morning so you will get may be night. Okay
if you want any other columns feel free to say me.

"Ed Whitbeck" wrote:

> I am trying to customize the default report Daily Detailed Sales with Tax.grp
> What I need to do is add the Tender Type or Tender.Description (Credit card
> / cash / check) as another column in the report.
>
> "Akber Alwani" wrote:
>
> > Hi ED,
> > The things make sense to me regarding the adding tables and fields which you
> > can do and customized the .grp file. but my doubt is why you wanted to add
> > another tables. what information you are looking for.
> >
> > Let me know first do you know the customization in .grp (active reports)
> > file if not then i can help you. second what you r data is and what exactly
> > you want.
> >
> > "Ed Whitbeck" wrote:
> >
> > > I am trying to customize the default report Daily Detailed Sales with Tax.
> > > What i need to do is add the Tender Type (Credit card / cash / check) as
> > > another column in the report.
> > >
> > > So far i have found out:
> > > i need to add a column
> > > i need to import the TenderEntry table for the data
> > >
> > > I need to find out:
> > > How to import another table
> > >
> > >
> > > I have tried to import the table using sql UNION function, but that wont
> > > work for me either. any help would be greatly appriciated.
> > >
> > > Thank You

Posted by Akber Alwani on February 27, 2007, 2:31 am
Please log in for more thread options
Hi Ed,
I couldn't find this file in my system. please send the file so I can
customized and resent it to you at alwani89@hotmail.com

"Ed Whitbeck" wrote:

> I am trying to customize the default report Daily Detailed Sales with Tax.grp
> What I need to do is add the Tender Type or Tender.Description (Credit card
> / cash / check) as another column in the report.
>
> "Akber Alwani" wrote:
>
> > Hi ED,
> > The things make sense to me regarding the adding tables and fields which you
> > can do and customized the .grp file. but my doubt is why you wanted to add
> > another tables. what information you are looking for.
> >
> > Let me know first do you know the customization in .grp (active reports)
> > file if not then i can help you. second what you r data is and what exactly
> > you want.
> >
> > "Ed Whitbeck" wrote:
> >
> > > I am trying to customize the default report Daily Detailed Sales with Tax.
> > > What i need to do is add the Tender Type (Credit card / cash / check) as
> > > another column in the report.
> > >
> > > So far i have found out:
> > > i need to add a column
> > > i need to import the TenderEntry table for the data
> > >
> > > I need to find out:
> > > How to import another table
> > >
> > >
> > > I have tried to import the table using sql UNION function, but that wont
> > > work for me either. any help would be greatly appriciated.
> > >
> > > Thank You

Similar ThreadsPosted
Adding supplier info to multiple items? October 22, 2007, 7:43 pm
Adding multiple items to a discount schedule in HQ January 8, 2008, 1:35 pm
What tables does RMS use to get Department Totals in Z Report? January 26, 2006, 9:39 am
Custom_Tender_Summary_by_Cashier Report with multiple tenders December 11, 2006, 7:06 am
Report Sales Summary with Multiple periods April 8, 2006, 4:51 pm
Z Report for Multiple Days/weeks/months April 24, 2007, 9:24 am
Adding Total to Report December 31, 2006, 8:00 pm
Adding field to existing report August 15, 2008, 10:13 pm
Adding Sales Tax Analysis results to Z-report March 5, 2007, 10:58 am
report not printing again due to adding store logo December 22, 2008, 10:07 am

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap