Search results

Hello, I am wondering if anyone knows if it is possible to lock or bind cells together in a row to prevent mixing them if an improper sort is done? I have a couple of spreadsheets built that have quite a bit of data and formulas on them that other people in my organization also use. I keep...

Thanks, That did the trick.

Hello all, I am trying to figure out how to add a second grand total column in a pivot. I need one grand total column to show the sum of the columns and another to show the percent of total. I have attached an example of what I would like to do. I manually added the column in red. Can anyone...

Thanks Yes, files are tables. The left outer join on the link options was what I was missing. Thanks a lot.

ok, let me clarify, I originally wrote the report using the wizard and connected the three tables by SKU#. The issue that I am having is that unless the SKU# exists in all three files, no data is brought back to the report. I want to print all the items in the item master file (primary file)...

I can't find a similar question answered already. What I need to do is report that lists every item in the item master (file 1) and lists quantity on hand (2nd file)and quantity on open orders (file 3). File 1 has all sku's. File 2 has Sku's that have a quantity on hand (if there is 0 on hand...

I have created some reports in Crystal 8.5 that I need to distribute to users. First question is do I have to install Crystal on their machines in order for them to call the report? If the answer is yes, then my second question is how to I allow them to run the report on their own in crystal...

Thanks a bunch, that did the trick.

I am not sure. I am very new to this. I found this formula on another help page for converting dates in a mmddyy format to a crytal date format. This is the exact formulat I have used when there are no 0 dates and it has worked every time. stringvar x :=...

wow, that file data did not print right let me try again. Sku# Date ODQTY 202005 0 700 202008 60908 25 202008 0 25 202231 60908 100...

Thanks for the quick reply. I am still having a problem though. if not isnull({SUMPNPOD.ODSDAT}) then "" else stringvar x := totext({SUMPNPOD.ODSDAT},"000000");date(2000 + val(right(x,2)),val(left(x,2)),val(mid(x,3,2))) this is what I put in. when I tell it to check the formula it says no...

Hi, I'm new to crystal reports and I am having trouble with a if then statement. here is what I am entering if ({SUMPNPOD.ODSDAT} = 0) then ({SUMPNPOD.ODSDAT}) else stringvar x := totext({SUMPNPOD.ODSDAT},"000000");date(2000 + val(right(x,2)),val(left(x,2)),val(mid(x,3,2))) Crystal is telling me...