Good morning Everyone!
I've been struggling with creating a report with the following format.
Currently, our company has about 300 stores and need to report sales everday for each store.
We have a report serving that purpose, but it is a 300 pages reports since each page display
one store...
Thank you FireGeek for your reply.
I wasn't being very clear on the format of the report.
-----------Store1----------- --------Store2-----------------Store3--------------
Date ----- TY Sales Budget LY Sales TY-LY--------TY Sales Budget LY Sales TY-LY --------TY Sales Budget LY Sales...
Hi All,
I've been struggling with creating this report. Our company has 300 stores and we need to report sales everyday, WTD, MTD and Total (YTD).
Currently, we have similar reports but it display one store per page since we group by store. Therefore, it is a 300 pages report.
I need to...
Hi,
I have placed "print date" and "print time" fields in my page header to refresh the time and date.
Lately, these two fields acting different. Sometime it show after I refresh/re-run the report, sometimes
it went blank. I have to delete both of it and put it back, then it shows. I even...
Hi,
I have a accumulation running totals declare as:
whileprintingrecords;
NumberVar Per_total := 0 //@Order_Per_reset placing on Period group header, group 1
whileprintingrecords;
NumberVar Per_total := Per_total + @Qty_order_SKU //@Order_Per_Accum // placing on SKU group footer, group 2 for...
Hi All,
I got the 1stLastDay to work, but how can I get the traffic of the 1stLastDay? My gr
ouping is Store ->Period ->Weekofperiod ->Date. right now, all of my field is placing in Date group footer (because I have display the store and all the date that have problem under it)
Thanks,
Thank you all for your reply.
I tried to take the date and subtract 7 from it to get the first Last Friday, subtract 14 to get the second last Friday and subtract 21 to get the 3rd last Friday.
The problem I am having is that, records are in the Date group footer, I can't get my formula to work...
Hi All,
I am trying to display the store that have problem with conversion rate (Trasaction/traffic)( less than 20 and > 60%).
So far, this is what I got so far...
Store# WeekDay Date Trans Traffic Conv%
1 F 3/16/2012 446 87 19.5
1...
Hi lbass,
The problem I have is that I need to run my report for last year data. Therefore, I have to calculate my Qtr base on the FiscalPeriod parameter input.
Do you have any susgestion for this?
Thanks!
Hi All,
I am modifying this report to run as a parameter driven report.
I need to group by @Qtr. @Qtr is calculated from input parameter ?FiscalPeriod.I can't set my group to Quarter. It yield error message: Group speciying on a non-recurring field. Detail @Qtr
Here is my calculation
if...
Hi,
I need to modify this sale report that is running supper slow (25 mins). This report has a filter of Comp = "C" and trieve data for this fiscal period (march) and all the sales data for last year. This report read through 358,744 records.
Comparing to its sister report, which has the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.