http://forums.method.me/cs/forums/30.aspxAsk technical support questions, how do I?...or anything else you want to know from the Method Team.enCommunityServer 2007.1 SP2 (Build: 31113.47)http://forums.method.me/cs/forums/thread/31977.aspxFri, 15 Apr 2016 17:44:43 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:31977Gpeak0http://forums.method.me/cs/forums/thread/31977.aspxhttp://forums.method.me/cs/forums/commentrss.aspx?SectionID=30&PostID=31977<p><span id="mce_0_start" style="overflow:hidden;">I&#39;m trying to create a report that shows all invoices that are paid for a specific time period - example all invoices paid from 03/01/2016 to 03/31/2016. &nbsp;We calculate commissions based on a/r, so this is in essence a report that sales reps could pull at any given moment to see their status for commissions.&nbsp;</span></p> <p>As my Master table I&#39;m using Customer, and attempting to use the Detail Tables of Invoice.CustomerRef and Transaction.CustomerRef. &nbsp;</p> <p>My report shows the transaction number, the date of the payment transaction, invoice number, po, rep, paid status and paid amount.&nbsp;</p> <p>My issue is filtering the report to the correct date range and paid status. &nbsp;I have a Detail Band that&#39;s using &quot;Customer.Transaction.Customer&quot; as it&#39;s Data Member. &nbsp;When I attempt to create a formatting rule, I cannot find the appropriate fields (transaction date, transaction number). &nbsp;</p> <p>In the Formatting Rules Editor, if I change the Data Member to Customer.Invoice.Customer I get the following error: &nbsp;&quot;Index and Count must refer to a location within the buffer.&quot; &nbsp; I have no idea what that means or how to fix it and be able to filter on the fields I need to filter on.</p> <p>Thank you!</p> <p><span id="mce_1_start" style="overflow:hidden;"></span></p>