Z Report for Multiple Days/weeks/months

Does anyone know where I can get a report that will give me the daily Z 
report data but in column data by date?

Right now I have to manualy enter every Z report into a spreadsheet.  The 
data is obviously in the database but there is no obvious way of getting it 
out.

I DO NOT want to just REPRINT Z Reports.  I want a full month or quarters 
worth of data in a single report but still broken down by day.  This will 
allow me to save as a CSV file then import into Excel where I can then 
massage the data as necessary.

Please help, I get a lot of info from this data like the ability to analyze 
days of week business volumn across long period of time.  Example:  I can 
then see all the Saturdays or Sundays in a Pivot Table/Graph to see where 
the volumn is and when it is so staffing and hours are appropriate. This is 
just one example of the many reports I create from the spreadsheet data.

Thanks

David 


0
4/24/2007 1:24:18 PM
pos 14173 articles. 0 followers. Follow

2 Replies
499 Views

Similar Articles

[PageSpeed] 53

HI David,
There is one crystal report delivered with RMS is called RegAnaly.rpt is 
availble under Utilities> Crystal Report have you tried that, if not i have 
couple of reports for Z out but not sure which one help you send me your 
email I can send you the reports i have. 

"David Parrish" wrote:

> Does anyone know where I can get a report that will give me the daily Z 
> report data but in column data by date?
> 
> Right now I have to manualy enter every Z report into a spreadsheet.  The 
> data is obviously in the database but there is no obvious way of getting it 
> out.
> 
> I DO NOT want to just REPRINT Z Reports.  I want a full month or quarters 
> worth of data in a single report but still broken down by day.  This will 
> allow me to save as a CSV file then import into Excel where I can then 
> massage the data as necessary.
> 
> Please help, I get a lot of info from this data like the ability to analyze 
> days of week business volumn across long period of time.  Example:  I can 
> then see all the Saturdays or Sundays in a Pivot Table/Graph to see where 
> the volumn is and when it is so staffing and hours are appropriate. This is 
> just one example of the many reports I create from the spreadsheet data.
> 
> Thanks
> 
> David 
> 
> 
> 
0
AkberAlwani (916)
4/24/2007 1:46:03 PM
This is a multi-part message in MIME format.

------=_NextPart_000_03EF_01C78BF9.763A2C70
Content-Type: multipart/alternative;
	boundary="----=_NextPart_001_03F0_01C78BF9.763A2C70"


------=_NextPart_001_03F0_01C78BF9.763A2C70
Content-Type: text/plain;
	charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

David,

Try the one attached.  Not exactly what you asked for, but is real =
close.

--=20

Jeff=20
Check Point Software

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D

You must be using Outlook Express/Windows Mail or some other type of =
newsgroup reader to
see and download the file attachment(s).  If you are not using a reader, =
follow
the link below to setup Outlook Express.  Click on "Open with =
newsreader"
under the MS Retail Management System on the right.

http://tinyurl.com/75bgz
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D

  "David Parrish" <david.parrish@vino100-lakeway.com> wrote in message =
news:uC9MePnhHHA.3472@TK2MSFTNGP04.phx.gbl...
  Does anyone know where I can get a report that will give me the daily =
Z=20
  report data but in column data by date?

  Right now I have to manualy enter every Z report into a spreadsheet.  =
The=20
  data is obviously in the database but there is no obvious way of =
getting it=20
  out.

  I DO NOT want to just REPRINT Z Reports.  I want a full month or =
quarters=20
  worth of data in a single report but still broken down by day.  This =
will=20
  allow me to save as a CSV file then import into Excel where I can then =

  massage the data as necessary.

  Please help, I get a lot of info from this data like the ability to =
analyze=20
  days of week business volumn across long period of time.  Example:  I =
can=20
  then see all the Saturdays or Sundays in a Pivot Table/Graph to see =
where=20
  the volumn is and when it is so staffing and hours are appropriate. =
This is=20
  just one example of the many reports I create from the spreadsheet =
data.

  Thanks

  David=20


------=_NextPart_001_03F0_01C78BF9.763A2C70
Content-Type: text/html;
	charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dwindows-1252">
<META content=3D"MSHTML 6.00.6000.16414" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT color=3D#008000>David,</FONT></DIV>
<DIV><FONT color=3D#008000></FONT>&nbsp;</DIV>
<DIV><FONT color=3D#008000>Try the one attached.&nbsp; Not exactly what =
you asked=20
for, but is real close.</FONT></DIV>
<DIV><BR>-- <BR><BR>Jeff <BR>Check Point Software</DIV>
<DIV>&nbsp;</DIV>
<DIV>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D</DIV>
<DIV>&nbsp;</DIV>
<DIV>You must be using Outlook Express/Windows Mail or some other type =
of=20
newsgroup reader to<BR>see and download the file attachment(s).&nbsp; If =
you are=20
not using a reader, follow<BR>the link below to setup Outlook =
Express.&nbsp;=20
Click on "Open with newsreader"<BR>under the MS Retail Management System =
on the=20
right.</DIV>
<DIV>&nbsp;</DIV>
<DIV><A=20
href=3D"http://tinyurl.com/75bgz">http://tinyurl.com/75bgz</A><BR>=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
<BR></DIV>
<BLOCKQUOTE=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #008000 2px solid; MARGIN-RIGHT: 0px">
  <DIV>"David Parrish" &lt;<A=20
  =
href=3D"mailto:david.parrish@vino100-lakeway.com">david.parrish@vino100-l=
akeway.com</A>&gt;=20
  wrote in message <A=20
  =
href=3D"news:uC9MePnhHHA.3472@TK2MSFTNGP04.phx.gbl">news:uC9MePnhHHA.3472=
@TK2MSFTNGP04.phx.gbl</A>...</DIV>Does=20
  anyone know where I can get a report that will give me the daily Z =
<BR>report=20
  data but in column data by date?<BR><BR>Right now I have to manualy =
enter=20
  every Z report into a spreadsheet.&nbsp; The <BR>data is obviously in =
the=20
  database but there is no obvious way of getting it <BR>out.<BR><BR>I =
DO NOT=20
  want to just REPRINT Z Reports.&nbsp; I want a full month or quarters=20
  <BR>worth of data in a single report but still broken down by =
day.&nbsp; This=20
  will <BR>allow me to save as a CSV file then import into Excel where I =
can=20
  then <BR>massage the data as necessary.<BR><BR>Please help, I get a =
lot of=20
  info from this data like the ability to analyze <BR>days of week =
business=20
  volumn across long period of time.&nbsp; Example:&nbsp; I can <BR>then =
see all=20
  the Saturdays or Sundays in a Pivot Table/Graph to see where <BR>the =
volumn is=20
  and when it is so staffing and hours are appropriate. This is <BR>just =
one=20
  example of the many reports I create from the spreadsheet=20
  data.<BR><BR>Thanks<BR><BR>David <BR><BR></BLOCKQUOTE></BODY></HTML>

------=_NextPart_001_03F0_01C78BF9.763A2C70--

------=_NextPart_000_03EF_01C78BF9.763A2C70
Content-Type: application/octet-stream;
	name="Custom - Sales - Z Report All.qrp"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment;
	filename="Custom - Sales - Z Report All.qrp"

//--- Report Summary --- //

Begin ReportSummary
   ReportType =3D reporttypeCustom
   ReportTitle =3D "Z Report All"
   PageOrientation =3D pageorientationLandscape
   WordWrap =3D False
   ShowDateTimePicker =3D False
   OutLineMode =3D True
   Groups =3D 0
   GroupDescription =3D ""
   DisplayLogo =3D False
   LogoFileName =3D "MyLogo.bmp"

   ProcedureCall =3D ""
   PreQuery1 =3D "IF EXISTS (SELECT TABLE_NAME FROM =
INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME =3D 'ViewZT') DROP VIEW =
ViewZT"
   PreQuery2 =3D <BEGIN>

CREATE VIEW ViewZT AS

select Reg, Bch, BStat, BOp, BCl, BOTot, BSls, BRets, BTx, BShp, BDs, =
BCb, BLp, BPmt,
   BDepM, BPO, BDrop, BLc, BChg, BDepR, BCTot, BStx, BTT, BTErr, BTChg, =
BDisc, BCOGS,
   BComm, BCC, BNS, BAbort, TOrd, TDrpPay, TTrans, TPmt, TCsh, TCk, TCC, =
TDb, TAcct,
   TVou, TOth, TEC, TFS

from (

select=20
isnull(register.number, 0) as Reg,=20
isnull(batch.batchnumber, 0) as Bch,=20
isnull(batch.status, 0) as BStat,=20
batch.openingtime as BOp,=20
batch.closingtime as BCl, isnull(batch.openingtotal, 0) as BOTot, =20
isnull(batch.sales, 0) as BSls, isnull(batch.returns, 0 ) as BRets,=20
isnull(batch.tax, 0) as BTx,=20
isnull(batch.shipping, 0) as BShp,=20
isnull(batch.debitsurcharge, 0) as BDs,=20
isnull(batch.cashbacksurcharge, 0) as BCb,=20
isnull(batch.layawaypaid, 0) as BLp,=20
isnull(batch.paidtoaccount, 0) as BPmt,=20
isnull(batch.customerdepositmade, 0) as BDepM,=20
isnull(batch.paidout, 0) as BPO,=20
isnull(batch.dropped, 0) as BDrop,=20
isnull(batch.layawayclosed, 0) as BLc,=20
isnull(batch.paidonaccount, 0) as BChg,=20
isnull(batch.customerdepositredeemed, 0) as BDepR,=20
isnull(batch.closingtotal, 0 ) as BCTot,
isnull(batch.salesplustax, 0) as BStx,=20
isnull(batch.totaltendered, 0) as BTT,=20
isnull(batch.tenderroundingerror, 0) as BTErr,=20
isnull(batch.totalchange, 0) as BTChg,=20
isnull(batch.discounts, 0) as BDisc,=20
isnull(batch.costofgoods, 0) as BCOGS,=20
isnull(batch.commission, 0) as BComm,=20
isnull(batch.customercount, 0) as BCC,=20
isnull(batch.nosalescount, 0) as BNS,=20
isnull(batch.abortedtranscount, 0) as BAbort,=20
sum(case when tenderentry.orderhistoryid <> 0 and =
tenderentry.transactionnumber =3D 0 then tenderentry.amount else 0 end) =
as TOrd,=20
sum(case when tenderentry.droppayoutid <> 0 then tenderentry.amount else =
0 end) as TDrpPay, sum(case when tenderentry.transactionnumber <> 0 then =
tenderentry.amount else 0 end) as TTrans,=20
sum(case when tenderentry.paymentid <> 0 and =
tenderentry.transactionnumber =3D 0 then tenderentry.amount else 0 end) =
as TPmt,=20
sum(case when tender.additionaldetailtype =3D 1 then tenderentry.amount =
else 0 end) as TCsh, sum(case when tender.additionaldetailtype =3D 2 =
then tenderentry.amount else 0 end) as TCk, sum(case when =
tender.additionaldetailtype =3D 3 then tenderentry.amount else 0 end) as =
TCC, sum(case when tender.additionaldetailtype =3D 9 then =
tenderentry.amount else 0 end) as TDb, sum(case when =
tender.additionaldetailtype =3D 4 then tenderentry.amount else 0 end) as =
TAcct, sum(case when tender.additionaldetailtype =3D 8 then =
tenderentry.amount else 0 end) as TVou, sum(case when =
tender.additionaldetailtype =3D 0 then tenderentry.amount else 0 end) as =
TOth, sum(case when tender.additionaldetailtype =3D 7 then =
tenderentry.amount else 0 end) as TEC, sum(case when =
tender.additionaldetailtype =3D 6 then tenderentry.amount else 0 end) as =
TFS=20

from batch=20
LEFT JOIN Register ON Batch.RegisterID =3D Register.ID=20
left join tenderentry on tenderentry.batchnumber =3D batch.batchnumber=20
left join tender on tenderentry.tenderid =3D tender.id

Group By register.number, batch.batchnumber, batch.status, =
batch.openingtime, batch.closingtime, batch.openingtotal, batch.sales, =
batch.returns, batch.tax, batch.shipping, batch.debitsurcharge, =
batch.cashbacksurcharge, batch.layawaypaid, batch.paidtoaccount, =
batch.customerdepositmade, batch.paidout, batch.dropped, =
batch.layawayclosed, batch.paidonaccount, batch.customerdepositredeemed, =
batch.closingtotal, batch.salesplustax, batch.totaltendered, =
batch.tenderroundingerror, batch.totalchange, batch.discounts, =
batch.costofgoods, batch.commission, batch.customercount, =
batch.nosalescount, batch.abortedtranscount

 ) as A

<END>

   TablesQueried =3D "FROM ViewZT"
   SelCriteria =3D ""
   GroupBy =3D ""
   SortOrder =3D ""

End ReportSummary

=20

//--- Title Rows ---//

Begin TitleRow
   Text =3D "<Store Name>"
   Font =3D "Arial"
   FontBold =3D True
   FontSize =3D 16
   Color =3D "Blue"
End TitleRow

Begin TitleRow
   Text =3D "<Report Title>"
   Font =3D "Arial"
   FontBold =3D True
   FontSize =3D 12
   Color =3D "Black"
End TitleRow

Begin TitleRow
   Text =3D "As Of: <Report Date>"
   Font =3D "Arial"
   FontBold =3D True
   FontSize =3D 10
   Color =3D "Black"
End TitleRow

Begin TitleRow
   Text =3D "Designed and/or modified by Jean Holland Group and/or Check =
Point Software"
   Font =3D "Arial"
   FontBold =3D False
   FontSize =3D 8
   Color =3D "Black"
End TitleRow

//--- Filters ---//

//Begin Filter
//   FieldName =3D "ClosingTime"
//   FilterOp =3D reportfilteropGreaterEqual
//   FilterLoLim =3D "<Today>"
//   FilterHilim =3D "<Today>"
//   FilterNegated =3D False
//   FilterConnector =3D reportfilterbooleanconAND
//End Filter


//--- Columns ---//

Begin Column
   FieldName =3D "Bch"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   StoreIDFieldName =3D ""
   Title =3D "Batch"
   VBDataType =3D vbLong
   Formula =3D ""
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 750
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
End Column

Begin Column
   FieldName =3D "BatchStatus"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   StoreIDFieldName =3D ""
   Title =3D "Status"
   VBDataType =3D vbString
   Formula =3D "CASE BStat when 0 then 'Open' when 1 then 'Closed' when =
2 then 'Open' when 3 then 'Closed' when 4 then 'Closed' when 5 then =
'Closed' when 6 then 'Open' when 7 then 'Closed' when 8 then 'Blind =
Closed' when 9 then 'Closed' when 10 then 'Blind Closed' when 11 then =
'Closed' when 12 then 'Blind Closed' when 13 then 'Closed' when 14 then =
'Blind Closed' else 'Closed' END"
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 700
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
End Column

Begin Column
   FieldName =3D "Reg"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   StoreIDFieldName =3D ""
   Title =3D "Reg #"
   VBDataType =3D vbLong
   Formula =3D ""
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 600
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
End Column

Begin Column
   FieldName =3D "OpeningTime"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   StoreIDFieldName =3D ""
   Title =3D "Opening Time"
   VBDataType =3D vbString
   Formula =3D "CONVERT(datetime, CONVERT(nvarchar, BOp, 20), 20)"
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1680
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
End Column

Begin Column
   FieldName =3D "ClosingTime"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   StoreIDFieldName =3D ""
   Title =3D "Closing Time"
   VBDataType =3D vbString
   Formula =3D "CONVERT(datetime, CONVERT(nvarchar, BCl, 20), 20)"
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1680
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
End Column

Begin Column
   FieldName =3D "BOTot"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   StoreIDFieldName =3D ""
   Title =3D "Opening Total"
   VBDataType =3D vbCurrency
   Formula =3D ""
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1300
   GroupMethod =3D groupmethodSum
   ColFormat =3D "#.##"
End Column

Begin Column
   FieldName =3D "BSls"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   StoreIDFieldName =3D ""
   Title =3D "Sales"
   VBDataType =3D vbCurrency
   Formula =3D ""
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1000
   GroupMethod =3D groupmethodSum
   ColFormat =3D "#.##"
End Column

Begin Column
   FieldName =3D "BRets"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   StoreIDFieldName =3D ""
   Title =3D "Returns"
   VBDataType =3D vbCurrency
   Formula =3D ""
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1000
   GroupMethod =3D groupmethodSum
   ColFormat =3D "#.##"
End Column

Begin Column
   FieldName =3D "BTx"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   StoreIDFieldName =3D ""
   Title =3D "Tax"
   VBDataType =3D vbCurrency
   Formula =3D ""
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1000
   GroupMethod =3D groupmethodSum
   ColFormat =3D "#.##"
End Column

Begin Column
   FieldName =3D "BShp"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   StoreIDFieldName =3D ""
   Title =3D "Shipping"
   VBDataType =3D vbCurrency
   Formula =3D ""
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1000
   GroupMethod =3D groupmethodSum
   ColFormat =3D "#.##"
End Column

Begin Column
   FieldName =3D "BDS"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   StoreIDFieldName =3D ""
   Title =3D "Debit Surcharge"
   VBDataType =3D vbCurrency
   Formula =3D ""
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1200
   GroupMethod =3D groupmethodSum
   ColFormat =3D "#.##"
End Column

Begin Column
   FieldName =3D "BCB"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   StoreIDFieldName =3D ""
   Title =3D "CashBackSurcharge"
   VBDataType =3D vbCurrency
   Formula =3D ""
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1200
   GroupMethod =3D groupmethodSum
   ColFormat =3D "#.##"
End Column

Begin Column
   FieldName =3D "BLP"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   StoreIDFieldName =3D ""
   Title =3D "Layaway Paid"
   VBDataType =3D vbCurrency
   Formula =3D ""
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1200
   GroupMethod =3D groupmethodSum
   ColFormat =3D "#.##"
End Column

Begin Column
   FieldName =3D "BPmt"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   StoreIDFieldName =3D ""
   Title =3D "Paid To Acct"
   VBDataType =3D vbCurrency
   Formula =3D ""
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1200
   GroupMethod =3D groupmethodSum
   ColFormat =3D "#.##"
End Column

Begin Column
   FieldName =3D "BDepM"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   StoreIDFieldName =3D ""
   Title =3D "Deposits Made"
   VBDataType =3D vbCurrency
   Formula =3D ""
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1200
   GroupMethod =3D groupmethodSum
   ColFormat =3D "#.##"
End Column

Begin Column
   FieldName =3D "BPO"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   StoreIDFieldName =3D ""
   Title =3D "Paid Out"
   VBDataType =3D vbCurrency
   Formula =3D ""
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1000
   GroupMethod =3D groupmethodSum
   ColFormat =3D "#.##"
End Column

Begin Column
   FieldName =3D "BDrop"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   StoreIDFieldName =3D ""
   Title =3D "Dropped"
   VBDataType =3D vbCurrency
   Formula =3D ""
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1000
   GroupMethod =3D groupmethodSum
   ColFormat =3D "#.##"
End Column

Begin Column
   FieldName =3D "BLC"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   StoreIDFieldName =3D ""
   Title =3D "Layaway Closed"
   VBDataType =3D vbCurrency
   Formula =3D ""
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1200
   GroupMethod =3D groupmethodSum
   ColFormat =3D "#.##"
End Column


Begin Column
   FieldName =3D "BChg"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   StoreIDFieldName =3D ""
   Title =3D "Charges"
   VBDataType =3D vbCurrency
   Formula =3D ""
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1000
   GroupMethod =3D groupmethodSum
   ColFormat =3D "#.##"
End Column


Begin Column
   FieldName =3D "BDepR"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   StoreIDFieldName =3D ""
   Title =3D "Deposits Redeemed"
   VBDataType =3D vbCurrency
   Formula =3D ""
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1200
   GroupMethod =3D groupmethodSum
   ColFormat =3D "#.##"
End Column

Begin Column
   FieldName =3D "BCTot"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   StoreIDFieldName =3D ""
   Title =3D "Closing Total"
   VBDataType =3D vbCurrency
   Formula =3D ""
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1200
   GroupMethod =3D groupmethodSum
   ColFormat =3D "#.##"
End Column

Begin Column
   FieldName =3D "OverShort"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   StoreIDFieldName =3D ""
   Title =3D "Over/Short"
   VBDataType =3D vbCurrency
   Formula =3D "(BPO + BDrop + BLC + BChg + BDepR + BCTot) - (BOTot + =
BSls + BRets + BTx + BShp + BLP + BPmt + BDepM + BDS + BCB)"
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1200
   GroupMethod =3D groupmethodSum
   ColFormat =3D "#.##"
End Column

Begin Column
   FieldName =3D "BSTx"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   StoreIDFieldName =3D ""
   Title =3D "Sales Plus Tax"
   VBDataType =3D vbCurrency
   Formula =3D ""
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1200
   GroupMethod =3D groupmethodSum
   ColFormat =3D "#.##"
End Column

Begin Column
   FieldName =3D "BRetTx"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   StoreIDFieldName =3D ""
   Title =3D "Returns Plus Tax"
   VBDataType =3D vbCurrency
   Formula =3D "(((BSTx - BSls) - BTx) * -1) + BRets"
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1200
   GroupMethod =3D groupmethodSum
   ColFormat =3D "#.##"
End Column

Begin Column
   FieldName =3D "BTT"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   StoreIDFieldName =3D ""
   Title =3D "Total Tendered"
   VBDataType =3D vbCurrency
   Formula =3D ""
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1200
   GroupMethod =3D groupmethodSum
   ColFormat =3D "#.##"
End Column

Begin Column
   FieldName =3D "BTErr"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   StoreIDFieldName =3D ""
   Title =3D "Tender Rounding Error"
   VBDataType =3D vbCurrency
   Formula =3D ""
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1200
   GroupMethod =3D groupmethodSum
   ColFormat =3D "#.##"
End Column

Begin Column
   FieldName =3D "BTChg"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   StoreIDFieldName =3D ""
   Title =3D "Total Change"
   VBDataType =3D vbCurrency
   Formula =3D ""
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1200
   GroupMethod =3D groupmethodSum
   ColFormat =3D "#.##"
End Column

Begin Column
   FieldName =3D "BDisc"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   StoreIDFieldName =3D ""
   Title =3D "Discounts"
   VBDataType =3D vbCurrency
   Formula =3D ""
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1200
   GroupMethod =3D groupmethodSum
   ColFormat =3D "#.##"
End Column

Begin Column
   FieldName =3D "BCOGS"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   StoreIDFieldName =3D ""
   Title =3D "Cost of Goods"
   VBDataType =3D vbCurrency
   Formula =3D ""
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1200
   GroupMethod =3D groupmethodSum
   ColFormat =3D "#.##"
End Column

Begin Column
   FieldName =3D "BComm"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   StoreIDFieldName =3D ""
   Title =3D "Commission"
   VBDataType =3D vbCurrency
   Formula =3D ""
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1200
   GroupMethod =3D groupmethodSum
   ColFormat =3D "#.##"
End Column

Begin Column
   FieldName =3D "BCC"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   StoreIDFieldName =3D ""
   Title =3D "Customer Count"
   VBDataType =3D vbLong
   Formula =3D ""
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1200
   GroupMethod =3D groupmethodSum
   ColFormat =3D ""
End Column

Begin Column
   FieldName =3D "BNS"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   StoreIDFieldName =3D ""
   Title =3D "No Sales"
   VBDataType =3D vbLong
   Formula =3D ""
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1000
   GroupMethod =3D groupmethodSum
   ColFormat =3D ""
End Column

Begin Column
   FieldName =3D "BAbort"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   StoreIDFieldName =3D ""
   Title =3D "Aborted"
   VBDataType =3D vbLong
   Formula =3D ""
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1000
   GroupMethod =3D groupmethodSum
   ColFormat =3D ""
End Column





------=_NextPart_000_03EF_01C78BF9.763A2C70--

0
cptsoft (1247)
5/1/2007 9:03:14 PM
Reply:

Similar Artilces:

Access 2003 export report into Word then edit file
Hi, I've spent a good few hours searching and trying to work this out but so far no joy. I need to export an MS Access report with borders, colouring and detail in it's exact format, into Word, then I need to be able to edit text in the word file. Also I have a grouping levels in my report. I downloaded and tested the A2K2ReportUtilitiesver2 from lebans.com, and can see it keeps the formatting when exporting to word which is great, but exports the report as a picture into the Word file, whereas I need to be able to edit the text. I know very little about programming in VBA, and copie...

Parameter query in Access 2003 report
I want to create a parameter query that asks the user to select one, many, or all values from a field when opening a report. I would like the selection to be available from a list, radio box, or pull down menu to minimize spelling errors, etc. Unfortunately the list is of names which number about 100. Can this be done? If so, could someone please point me to the help pages that describe this process? My solution seems clunky but it is the only way I can see how to do it. Any suggestions as to how else might I best approach this? Thanks in advance Debbie See my sample database that shows ...

MPQ on a Store or HQ Report
I need to be able to make up order sheets for staff to use on the shop floor when doing orders, i cant find any reports which have MPQ availalbe which i really need.... any ideas? This is a multi-part message in MIME format. ------=_NextPart_000_0662_01C6F88C.112F4BE0 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Philip, What report are you looking for it to be on? --=20 * Get Secure! - www.microsoft.com/security You must be using Outlook Express or some other type of newsgroup reader = to see and download the file attachment. If you ...

FA Reports
When I print FA Inventory List report, or for that matter any report from fixed asset module to cannon printers, the font on the report seem to overlap each other but the same report would print fine on HP printers!. Also, all other reports in GL/AP/AR module print fine even to cannon printer. Is this a printer setting issue or FA report issue and how to fix it. thanks in advance ...

Installing Issue "application error reporting"
When installing the CRM on an SBS I am getting this alert as a required component: "Microsoft application error reporting" Version 11.0.5510 I am not sure where to download this... Larry Hello CRM-Larry, when you run the Setup and yo get this message: Microsoft application error reporting" Version 11.0.5510 You should find an install button on the lower right side of this window. When you click on this, the setup should install this component. I hope this might help you. Thomas CRM-Larry wrote: > When installing the CRM on an SBS I am getting this alert as a > re...

Multiple Address List
I'm the Mail Administrator for two seperately run companies who use the same Exchange 2003 organisation, but who each have their own SMTP domain. What I'd like to do is setup separate default GALs for each company based on email addresses (ie one GAL shows all @company1.com addresses and the other displays all @company2.com addresses). The problem I've found so far is that when creating the address list I can only setup a filter to display the email addresses which end in @company1.com for Users, OR Public Folders, OR Distribution Groups....but I can't use the filter to...

Can't filter report by custom field
I am trying to filter account records by a custom date field. However, when I apply the filter I get a crystal error saying that the field cannot be found. Is there some limitation on reporting using custom fields? -Jason Yes Jason you need the crystal reports 9.2.2 and modify the reports (*.rpt) with custom fields. do... < verify database> i hope this help to you Carlos consultoria CRM Axxonconsulting Argentia "Jason Beckett" <jasonb@fredericksbenefits.com> escribi� en el mensaje news:eiB2Fi8qEHA.3940@tk2msftngp13.phx.gbl... > I am trying to filter account reco...

"Z Report" Report
We would like to monitor when our stores close out for the day. Is there a way for us to generate a report that shows when the Z's were created by register? Rick, This should probably be fairly simple to create as an RMS report. -- Thank you, Ryan Sakry Program Manager Retail Information Technology Enterprises (RITE) rsakry@rite.us http://www.rite.us 320-230-2282 ext. 4002 (Office) 320-230-1796 (Fax) "Rick@ASP" <RickASP@discussions.microsoft.com> wrote in message news:F0CAFB96-AA6D-4F76-86FE-99518E4E4AA1@microsoft.com... > We would like to monitor when our stor...

Reporting Services not installed
Hi all, I have installed crm and reporting services but when I go into a report, display it and then hit print I get an popup box saying.... "Do you want to install this software? Name: Microsoft SQL Server Reporting Services" Can anyone help please Thanks Jools There's an ActiveX control each client machine needs in order to print SQL Reports from CRM. It's a one-time 5-second install. -- Matt Wittemann, CRM MVP http://icu-mscrm.blogspot.com "Jools" wrote: > Hi all, > > I have installed crm and reporting services but when I go into a report, ...

Reports.dic file
I have just upgraded from Dynamics 7.0 to Great Plains 8.0 and when I login I keep getting an error message "Reports.dic needs to be upgraded using Great Plains Utilities". I attempted that and point to the dynamics.set dictionary but when I log back into Great Plains, I still get the same message. Any idea how to get rid of that error message? Also, I'm not sure if that is why I cannot see a particular window for Analytical Accounting. The setup instructions said to go Transactions>>Financial>>Analytical Accounting>>Edit Analysis but I don't see Ana...

date-based fields changing depending on the time of day
Hello: I created a view that will show inventory item shipments due to customers within different time "buckets", such as Past Due, 0 - 3 Days, etc. as shown by my T-SQL programming below. A client claims that when he runs this view, he gets different data in the afternoon versus in the morning. As you can tell, there are a lot of date-based fields such as DATEADD. Do these date-based fields behave differently in SQL, depending on the time of day that they are run? SELECT ITMCLSCD AS [TYPE], IsNull(ITMCLSDC,'') AS [TYPE DESCRIPTION], ITEMNMBR AS [ITEM #], ITEMDES...

A-Z, Z-A, buttons
The A-Z, Z-A buttons are a very useful feature, that I use to sor columns within blocks of data without having to go through the dat sort menu. I have a large block of data, with no gaps, which I have used for ove 5 years, so it's well tried and tested. Now for some reason when I use the A-Z buttons it won't include the to three rows in the sort. This has happened a couple of times before with just the top row and m solution has been to delete it completely and insert it lower dow within the block. What is the cause of this problem. I'm sure there is a simple solution. Thanks...

populate an unbound control in a report
I have been round and round with this and think I've exhausted this site or at least myself with this; I am trying to populate 3 controls using vba (will expand to five sets of three but once I get these three the rest should be easy I hope) the recordset is based on a query used to compile original data from multiple tables and also generate a ranking within subgroups - end goal to populate the fields for each subgroup on a subreport via vba. All of the fields referenced are either in the subreport or the query and are long integer except the pilotvolt and pilottemp fields w...

Money 2007
I just noticed that Money 2007 will only allow viewing of the last 12 months of Monthly reports. In Money 2003 one could select a monthly report as far back as there was information in the file. When did they eliminate that, starting in 2007? Mark Actually I think it was before M07. Why was it eliminated? One theory is that it avoids support calls about how to eliminate old reports that the caller insists simply must be taking up precious disk space. One workaround may be playing with system time temporarily. Haven't tried it, though. "Mark Fields" <mark_no_spam_...

Report on related messages
Hi There We use our email response times as a service performance indicator. At the moment it is a manual process where we check the date/time we receive an email and then when we respond. If there is more than one set of to'ing and fro'ing with the email, we report on the date/time of the first email and the date/time of the last email where the issue was resolved. I notice that there must be a mechanism linking all related messages in a string of messages and was wondering if there was any way of reporting on this? I would appreciate any help on this if anyone else had done...

Cannot Access Reports. CRM 3.0 and SQL 2005 on Separated Servers
I have CRM 3.0 and MS SQL 2005 64 bits on separated servers. When i access the Reports in My Activities, appears: Error. Please contact the system administrator. -- Allan Machado Microsoft Certified Professional Hi Alan, Are you accessing your CRM using an IP address or name, if it's IP address, it will not work. It only works with name because IP don't work with Kerbero. If it's still not working, follow the white paper from Microsoft to check your SPN, etc... Hope this will help. Darren Liu Crowe Chizek and Company http://www.crowecrm.com On Apr 14, 1:06 pm, Allan Macha...

Deleting Reports in 1.2
I once received a toolkit to delete reports for the 1.0 system, and it worked fine. But now after upgrading to 1.2, I can't seem to delete reports using this same utility. Anyone know if there is a new tool we need to get for 1.2? thx, Gary Hi Gary, CRM 1.2 uses Crystal 9, not 8.5. Maybe you need a new tool. I'm deleting/updating/adding reports on CRM 1.2 in a few days, so if you don't find an answer, I'll post more info as I find out what's needed. Mike "Gary" <gary.rey@virtium.com> wrote in message news:%23x%23mPvE4DHA.2528@TK2MSFTNGP09.phx.gbl....

Enterprise Reporter
Is anyone a Guru with Enterprise Reporter? or know of any good websites with support information etc. Thanks Adam Try http://www.solverusa.com/ Or Microsoft Technical Support -- This posting is provided "AS IS" with no warranties, and confers no rights. "Adam" wrote: > Is anyone a Guru with Enterprise Reporter? or know of any good websites with > support information etc. > > Thanks > > Adam ...

Moved Mailboxes
Exchange 2003 Standard \ Server 2003 \ 2003AD native/native \ Outlook 2003 OK, here we go. While working on a test environment I built a new Exchange server and moved the user's mailboxes over. I dropped the original Exchange server and rebuilt it as something else. Everything seems to work, but when you hit send/receive in Outlook it reports an error message of 0x8004010f. My guess is that I was supposed to do alot more work before dropping the original server. Probably something like move the public store (which didn't have anything in it anyway) and the address lists somehow....

Outlook 2003
My Outlook 2003 (with Business Manager) is sending multiple copies of emails to receipients. In other words, instead of sending one copy of the email to each receipient, it somes sends as many as 16 copies of the same email to the receipient. I am using the latest versions of McAfee VirusScan and Firewall with automatic updates. My system has been scanned for viruses by McAfee online with negative results. Can anyone clue me in? Is this a virus missed by McAfee or have I done something in the files to cause this problem? Chris I am having the same problem, except the thing i...

How do I set up a payroll spreadsheet will update weekly?
I am not familiar with Excel and need to know how to set up a payroll spreadsheet that uses a formula to update payroll weekly Try this Microsoft link. I think that it is probably what you need. http://office.microsoft.com/en-us/excel/HA010843671033.aspx -- Regards, OssieMac "torit" wrote: > I am not familiar with Excel and need to know how to set up a payroll > spreadsheet that uses a formula to update payroll weekly "torit" wrote: > I am not familiar with Excel and need to know how > to set up a payroll spreadsheet that uses a formula > to updat...

BUDGET REPORTS CONFUSING
I just noticed that under the Budget Planner there is a View Reports option. The two reports listed are: (1) Monthly Budget and (2) Annual Budget. If you click on Monthly Budget you get your total year annual budget. If you click on Annual Budget you get your total year annual budget in the first three columns and then each month follows in the columns that follow. My natural instinct would indicate that the naming of the two reports were opposite to what they show. Anyone pick up on this before? (Shows how little I have relied on the Buget planner and all its bugs thru the years). Steve ...

Net Worth Report on Money 2002
I have added a new liability account named "Home Equity Loan Account". It has a balance of approximately $15,000. Even though I have cleared and rechecked the account names in the reports section making sure that this new account has been marked for inclusion, it doesn't appear on the report. What corrective action should I investigate? ...

Multiple DBs sharing tables
Can we set up multiple databases to share information like customers or items. We have five companies setup in five dbs and the item list is similar enough that we could use one list and customers may be repeated across companies as well. if I could "point" all dbs to a single customer and item table we would only have to enter info 1 time. When we moved over to GP we loaded all of the information from each company into an excel workbook and then that was loaded into G/P. That gave us the ability to clean things up!! "S Meyer" wrote: > Can we set up multiple data...

automation of PDF's for reports
I have Office 2007 and downloaded the pdf plugin for it. What I would like to do is setup an automated Access report function that would programatticaly create a .pdf from a filtered report using the name on the report as the file name, and then email the file to the person using his email addess in the database. I can find NOTHING about this anywhere and I'm not even sure where to start. Anyone got any advice? Hi, You can try using Stephan Lebans module on ReportToPdf on his website www.lebans.com I have it working great with Office 2003. What it does is take your report, conver...