Search results for query: *

Brian, Thanks that what I thought but, I wanted to be sure.

I have a sql statement that I need to either sub select or concat to create the select field. When I do this it returns the value of the concat ex. Select concat('Hel','lo') from world It would return Hello instead of the value for the column HELLO. It does the same thing if I subselect from...

Crystal reports is a good alternative.

Try >0<0 in the QBE

Make sure the print Queue is set up to save

Is there a way to grab the users that are logged onto JDE HTML server so that I can create a report? I can see the user list in SAW but, right now the olny way I can capture the data is with a screen shot. Thanks

OK I figured out a work around. You can create a calc field and do a adddate with add days of 0. You can then use this field to compare your dates

I am having a simular problem with dates. I am only using a single date prompt but the compares do not seem to work.

Go to project tab and click on verify model. If you get an orphin message you need a join. I don't know of any reason why a join(relationship) will not work unless the fields are not compatible ie. char and int.

Go into Framework. Open your project Click on object explorer Double click on your join Click on relationship SQL tab Click test button. You will get the same errors here that you get from your report.

There could be a problem with your join. Go into Framework manager and test your joins from there.

Hi, Is there any way to change the color in one field of a column when it does not equal a certain value? I am trying to compare to columns and change the color when they are not equal. ex. name1 name2 bob bob sam john mike mike I need to make the center column a different color...

You can FTP the file in csv format to the 400 then run: CPYFRMIMPF FROMFILE(imported file) TOFILE(OW file) RCDDLM(*EOR)

Does anyone know how to call a OW report from a CL program? Thanks

What side is it deleting the pdf on FormScape or JDE. If it is FormScape it is probably a cache issue.

Does anyone know how to create a new sheet in excel through an UBE? I am running a report with output in csv format but, I need the different sections of the report on different sheets. Tried 2 seperate reports called from within one ube but that kicked off two instances of Excel. Thanks for...