Search results for query: *

Thank you.

YES THIS IS A CRYSTAL GENERATED SQL MY DATABASE IS A PROGRAM CALLED MAXIMO(IS THAT WHAT YOU MEAN) NOT SURE WHAT YOU MEAN - i DID BRING 1 TABLE IN TWICE TO THE REPORT TO GET THE DATA IN THE HEADER i HAVE TRIED THE LEFT OUTER JOIN FROM PO.LDKEY TO POLINEDESCRIPTION.LDKEY. (MAKE = AND ENFORCE...

sorry i posted a similar reports sql statement the 2nd time- here is the ORIGINAL - as you can see I tried the join but I still get a failure..... SELECT "PO"."PONUM", "PO"."STATUS", "PO"."VENDOR", "COMPANIES"."NAME", "COMPANIES"."ADDRESS1", "COMPANIES"."ADDRESS2", "COMPANIES"."ADDRESS3"...

see thread: thread149-1537153

sorry this is a repost of the last reply of my previous thread which somehow has messed up. SELECT "PR"."PRNUM", "PR"."ISSUEDATE", "PR"."REQUIREDDATE", "COMPANIES"."COMPANY", "COMPANIES"."ADDRESS1", "COMPANIES"."ADDRESS2", "COMPANIES"."ADDRESS3", "COMPANIES"."ADDRESS4"...

Here are the only statements I have for the report: {PO.PONUM} = {?PO number} and the 1st one I posted above I wrote as a formula but also works as a select statement: if not isnull(({LONGDESCRIPTION.LDTEXT })) then {POLINE.DESCRIPTION}+{LONGDESCRIPTION.LDTEXT} else {POLINE.DESCRIPTION}...

using version: crystal 2008 -version 12 i think it is

the field im using to populate my data does NOT show on the Table(under the linking section) but does show up as a feild when the table is on my report. As far as the left outer join- is it set = , <= not sure which one to use?

I have a field that has a long description in it. My problem is when i plug in my formula all data in the long description populates fine. But the fields that does not have long descriptions will not even show up on the report because there is not a long description. When I take out my formula...

my table that represents the number of lables i want to print only has a value of 1-20

I think there is a issue with the formula pertaining to the database If i just enter 1 xitem and 1 xlabelnumber. The data populates instantly. If enter anything more than 1item in either parameter field I have to have the report seach 150000 plus records. Not sure why that is

ok still same problem- for prompt in parameter 1 I enter:xitem1, xitem2, xitem3 (3 different numbers) for parameter prompt 2 i enter ONLY - 1 number because I want all of the above printed the same amount of times. I get the failure ( a subscript must be between 1 and the size of the array)...

i found my mistake I added a "n" to ubound....lol - by the way I appreciate you help on this. I will give you a update after i test.

after entering the above formula to my report - i get a error asking for a ) after the very 1st unbound, even after i enter it, the program keeps asking for more (unbound({?Control ID:})>=1 and {INVENTORY.ITEMNUM}={?Control ID:}[1] and {?Labels}[1]>={Table1.Field1})or (unbound({?Control...

ok for the most part i have it working. I have a few questions 1. When the report runs instead of putting the data on the preview it is searching for records and I have to let it go through 150000 records before I stop it or my data will not populate. Not sure what is wrong here 2.not sure how...

are the [1] in the formula a suggested input or is it part of the formula? do i need to delete the select statement that I already have and use the suggested one or keep it and just add the suggested one behind it? Pls forgive rather new at this.

my "select distinct records" is greyed out? How do i correct this?

anyone have any ideas on this

OK- the most any 1 item will be printed is 24 times( i used 24 becasue If i just get that one item in I wanted to be able to print 24 lables - not 3 prints of 10, 10 and 4) example 1. xxx qty 4 2. xxx qty 3 3. xxx qty 2 4. xxx qty 1 5. xxx qty 7 6. xxx qty 5 7. xxx qty 2 8. xxx...

by field numbers if you mean my 1st parameter there is total of around 10000+ control (or xitems) that may come into my inventory. Since there is are so many I want the user to just input the number themselves rather than using a cascading list in parameter 2- the most labels I will ever have...