Search results for query: *

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...

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 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 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...