Search results for query: *

LB, The last one, I got it resolved. Thanks much for your help.

On page header, I have a formula field @SalesTaxExempt. If OnFirstRecord then //First record If {tpoPrintPOLineWrk.ItemID} = "800" OR Next({tpoPrintPOLineWrk.ItemID}) = "800" Then "NO" Else "YES" Else If OnLastRecord Then //Last record If...

LB, It worked great. Thanks much for your help. I have another simple question. On page header, I have a formula field @SalesTaxExempt. If OnFirstRecord then //First record If {tpoPrintPOLineWrk.ItemID} = "800" OR Next({tpoPrintPOLineWrk.ItemID}) = "800" Then...

Madawc Williams, It worked great. Thanks much. I have another simple question. On page header, I have a formula field @SalesTaxExempt. If OnFirstRecord then //First record If {tpoPrintPOLineWrk.ItemID} = "800" OR Next({tpoPrintPOLineWrk.ItemID}) = "800" Then...

LB, Thanks for your suggestions. I tried implementing your suggestion by putting sub-report in group_header_a and the main report in group_header_b. Linked sub-report to the main report by Sales Order. It did not work correctly. It displays just one Sales Order report even if there are...

Madawc, Thanks for your suggestions. I tried implementing your suggestion by putting the subreport in detail section and linked the sub-report by Sales Order to the main report. It works perfectly and displays the zero qty item by sales order as I wanted. However, there's one glitch still...

I have a sub-report on the group header that displays zero quantity items. eg. Sales Order Item Qty ---------- ------ ----- 1 T-Shirt 0 5 Poster 0 18 Pen 0 The main report...

I have a sub-report on the group header that displays zero quantity items. eg. Sales Order Item Qty ---------- ------ ----- 1 T-Shirt 0 5 Poster 0 18 Pen 0 The main report...

I made a sub-report to display data from table B. The main report shows the report from table A. When the sub-report is placed in the page footer, the report displays data from both table A & B which is what I wanted. I want sub-report to be displayed below main report. The page footer is way...

I made a sub-report to display data from table B. The main report shows the report from table A. When the sub-report is placed in the page footer, the report displays data from both table A & B which is what I wanted. I want sub-report to be displayed below main report. The page footer is way...

Now I can get records from both tables using LEFT outer join. The problem now is there are duplicates from table B for each record in Table A. For example: tableA.itemID_1 tableB.itemID_1 tableB.itemID_2 tableB.itemID_3 tableB.itemID_4...

I tried using UNION, gives me the same result. i.e. for each record in Table A, shows all records from table B. for example: table A has 2 records and table B has 3 records, it displays tableA_item.1 tableB_item.1 tableB_item.2 tableB_item.3 tableA_item.2 tableB_item.1...

I got two tables, Table A & Table B I want to put all items from Table A and Table B into the report. Both tables has session ID field which will have same value, rest of the fields are different. I did a EQUAL join on Table A with Table B to get all the records from Table A and from table B...

The above example was just an example. Here's the SQL for the report. It was grouped by POKey when the vendor delivered the report. I tried grouping by ItemID or tglAccount.glAccountNO, it doesn't group at all. Any other way to check if the a/c no is same? Thanks for the help. SELECT...

Jim, I am not able to use group by/order by clause for this report since the report engine of the original vendor who wrote the report overwrites the group by/order by setting that I use otherwise it would have been great. I am trying to customize their report. Any help appreciated. Thanks.

If there are multiple lines with same a/c number on half of the page and then diferent a/c number for the rest of the page, then I would display the a/c number on the detail line as above like: T Shirt a/c: 6587-36580-9873-0000-0000 Poster a/c: 6587-36580-9873-0000-0000...

If there are multiple lines with same a/c number on half of the page and then diferent a/c number for the rest of the page, then I would display the a/c number on the detail line as above like: T Shirt a/c: 6587-36580-9873-0000-0000 Poster a/c: 6587-36580-9873-0000-0000...

Thanks LB for the info. I am customizing this report which was originally written by different vendor. The vendor's report engine overrides my settings and doesn't allow me to group/sort on any field on this particular report. The solution you mention requires grouping on a/c otherwise it...

I have a a/c No. field for each item in the detail section. For example: Item --------------------------------------- T Shirt a/c: 6587-36580-9873-0000-0000 Poster a/c: 6587-36580-9873-0000-0000 Brochure a/c: 6587-36580-9873-0000-0000 Pens a/c...

Issue 1 --------- Also, I have a a/c No. field for each line item in the detail section. For example: T Shirt a/c: 6587-36580-9873-0000-0000 Poster a/c: 6587-36580-9873-0000-0000 Brochure a/c: 6587-36580-9873-0000-0000 Pens a/c: 6587-36580-9873-0000-0000...