Search results by user ID 4977

Re: report designer issues

Hannah — Wed, 23 Mar 2011 23:59:38 GMT

Michael,

I took the basic estimate report and started editing off of that format. The summarization is of line item prices, it is a subtotal. The

tables that the original estimate work off of are the Company, Estimate, and EstimateLine, so those are that ones that I am using. It

seems like everything should be set up correctly to begin with since I am just editing a pre-made format.

Thanks,

Hannah

Re: report designer issues

Hannah — Wed, 23 Mar 2011 16:58:41 GMT

Hi Michael,

Thank you for your advice, but...

I set the format string to {0:$0.00} a couple of times, and it wouldn't change the four decimal points. I tried to 'ignor null values' also and that didn't change it either.

I also tried the 'ShipAddr2' and it kept inputting the first line of the address, not the second. I tried all the other 'ShipAddr' 3, 4 & 5 and they did the same thing.

Any other ideas?

Thanks, Hannah

report designer issues

Hannah — Wed, 23 Mar 2011 00:12:28 GMT

I am customizing an estimate with the report designer and am having some issues. First, when I add a subtotal field it calculates correctly except for adding four decimal spaces, even if there is no change there will be four zeros. Second, the sales tax percent field does not automatically populate. When I choose a sales tax from the sales tax drop down menu it seems like the percent field should pull that information from quickbooks or somewhere, right? And finally, when I add a "ship to address 1" field it will put in the name on the address but not the address itself. I tried all the other numbered "ship to" fields but they all just insert the name and not the physical address. There are also fields for the city state zip etc. but not for just the address.

Whew! That's all for now. Am I just not using the report designer correctly?