Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: dninus
  • Order by date
  1. dninus

    How to display multiple grouping fields on one page

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

    Display multiple group fields across page

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

    Display multiple group fields across page

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

    Print Date and Print Time not working properly

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

    How to stop my running totals to reset at new page

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

    Find the 3 mondays within 30 days

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

    Find the 3 mondays within 30 days

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

    Find the 3 mondays within 30 days

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

    Grouping by a variable driven by parameter

    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!
  10. dninus

    Grouping by a variable driven by parameter

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

    Report running too slow

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

Part and Inventory Search

Back
Top