the tables were the problem.... i guess i was trying too many different things at once last night...:-)
i thought they worked separately, but once i added the holdords table, it broke the status D query....
i ended up making a separate report and inserting it as a subreport, and now all is...
i am trying to select all records that have an "order status " of "D", OR have a hold_reason of "DECLINED"...
ie,
({sysoent.order_status} = "D") Or ({holdords.hold_reason} = "DECLINED")
the only records returned from the above are the...
i have a report, grouped by customer type that has
customertype, customer #, name, total of this year's sales(YTD)
i want to add a column that is a summary of last year's sales for the same time period...ie, LastYearYTD....
is it possible to do that with insert - field object - and a new sql...
you bet, the result table/output comes out like this:
Source code Break Even # Sales .........
PIM-1F 20.5 5 etc........
PIM-1F 20.5 10 etc.........
but it should be like this......(there are two different source codes in the first recordset...)
Source...
Hi!
I have a page that selects one or more "sourcecodes" from one table, then uses that recordset in another select ....
the queries are working, but when there is more than one sourcecode, my output is just the last one repeated ....
can anyone see what i might be doing wrong with...
i am using an invoice that lists the individual (lineitems) in a detail section...
i want to add a single line after all the lineitems have been printed that says "FREE Report with every order"
i added a formula in a new detail section directly below the lineitem detail section, and...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.