Forums › Cached › Customization › Reporting › Report Builder

This topic contains 4 replies, has 0 voices, and was last updated by WalterM 13 years, 9 months ago.

  • Author
    Posts
  • February 3, 2011 at 11:07 am #8039

    NatalieLynn

    We have a report that pulls the invoice, the item description column, the reason not covered column and the total revenue. The issue we have is that it pulls all the information for each column except on the invoices where the charge of the line item is zero and the revenue comes from the shipping total. Does this make sense? I cannot pull the description and reason not covered information from the invoices that have a Zero dollar line item and only a cost on the shipping.

    Thanks,

    Natalie
    This is a cached copy. Click here to see the original post.

  • February 3, 2011 at 11:15 am #8040

    NatalieLynn

    RE: Columns not pulling from report

    Basically it is not pulling the information on the line items that have a zero cost…how do I modify that so it does?

  • February 3, 2011 at 1:20 pm #8041

    Olivier Gagnon NC

    RE: Columns not pulling from report

    Try going in the report options and tick in “Show Zeroes”

  • February 3, 2011 at 1:27 pm #8042

    NatalieLynn

    RE: Columns not pulling from report

    Yes I clicked show zeros and I think that did it….Can I get rid of the main line like you do in a search or no for reports?

  • February 3, 2011 at 8:33 pm #8043

    WalterM

    RE: Columns not pulling from report

    sounds like it could be an account issue. Depending on what type of account the shipping is set up with, it may not show in a sales report? you many need to create a report that allows you to pull the shipping info in it…

    give that a try and post if it doesn’t work.

  • Author
    Posts

You must be logged in to reply to this topic.