Important Notice from AspDotNetStorefront
It is with dismay that we report that we have been forced, through the action of hackers, to shut off write-access to this forum. We are keen to leave the wealth of material available to you for research. We have opened a new forum from which our community of users can seek help, support and advice from us and from each other. To post a new question to our community, please visit: http://forums.vortx.com
Results 1 to 3 of 3

Thread: Create Custom Report for a Range of Products

  1. 07-22-2011, 07:06 AM #1
    Strabell is offline Junior Member
    Join Date
    Mar 2011
    Posts
    7

    Default Create Custom Report for a Range of Products

    How can I create a custom report that will list all products with a certain word in the title and total price for all of the items (in this list) combined?
    Thanks in advance!!
  2. 07-22-2011, 09:03 AM #2
    webopius is offline Senior Member
    Join Date
    Nov 2008
    Location
    London, UK
    Posts
    440

    Default

    Hi

    If it's a one off requirement, just write a SQL query to retrieve the data you need.

    Alternatively if it's an ongoing requirement, and you are a programmer(!), take one of the existing admin reports (such as rpt_orders.aspx) as a guide and modify it.
    Webopius.com: ASPDotNetStorefront web development and ecommerce project management
    Webopius is now a Sage Pay Approved Partner
  3. 07-22-2011, 09:41 AM #3
    Strabell is offline Junior Member
    Join Date
    Mar 2011
    Posts
    7

    Default

    How can I view an already created report? (the sql for it)
    I could play around a lot better if I knew what the field names are.
    Last edited by Strabell; 07-22-2011 at 09:55 AM.