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...

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...

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...

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...