Liveware Publishing Support Forum

Is there a way to choose unmatched records with INNER and OUTER JOINS using Report Writer 12 for SQL and MS SQL Server 9.0+? I know *= and =* no longer work...____Thanks,__Pat

I figured this out... Thanks...

We have to use UPC-A, UPC-B, etc. data and print the barcode using an associated UPC-A, etc. font at the desired height and then adjust the line to the height of the barcode. The fonts we use are third party that we bought from Rivers Edge (MSI Plessey, specifically) and works wonderfully. Hope that...

I have a report that filters out data based on a couple of variables but then, based on that information I need to go back and check if there are multiple occurances of a piece of this data in what was already filtered out. I have set up accumulators and they work perfectly if the first filter is tu...

The view table will not work in this case because the table links change at every run. We run through a list of external database links, pull in what we need, run the report on that specific data set and then move on to the next database link in the list. Do you have any other suggestions? This is r...

I will work on running the command line SQL script that would create the table in the interum. The issue here is that is has to be able to run from our software that loops through the list.____Thanks!

Alright. I got the SQL script running correctly in our software that creates the table view as suggested. I have also editted the Report Writer report so that it uses the view instead of the raw tables. The results, while being correct, show no appreciable difference in speed. I can manually run the...

I believe it is a user report. Not sure why half the query dropped but here is the same one with "." replaced with "^".____select distinct __ cast([previous]^productupc as char(15)) UPC,__ cast([print]^name as char(8)) Name,__ cast([item]^productdesc6 as char(60)) Desc6,__ cast([...

OK. The posting is still messing with the brackets. I have now replaced "[" and "]" with "{" and "}", respectively.____select distinct __ cast({previous}.productupc as char(15)) UPC,__ cast({print}.name as char(8)) Name,__ cast({item}.productdesc6 as char(60))...

select distinct __ cast([previous].productupc as char(15)) UPC,__ cast([print].planogramname as char(8)) PLNName,__ cast([item].productdesc6 as char(60)) Desc6,__ cast([item].productdesc3 as char(12)) Desc3,__ cast([item].productdesc7 as char(12)) Desc7,__ [item].productprice__from previous,__ curre...