Good afternoon Ladies and Gents,
I am new to Crystal Reports and I need to know 2 things
- first can you put formulas in formulas - i know how to write formulas to do exactly what I want in excel but when I try to do the same in crystal it won't let me. It seems to only want to do one formula at a time, which means I have a list of 60+ single IF statements.
- second, I want to know how to combine data from different spreadsheets. I have pulled multiple spreadsheets into the same crystal report, and linked them. But when I insert the data from 2 different sheets, it only gives me the data that is common in both, not the combined data
for instance, I have a list of all permanent employees and a list of casual employees. I would like to grab both and make a list of all employees. Instead, when I grab both lists, because there are no common people, it deletes everyone in the crystal report
Does any of that make sense? Please help! 
IP Logged
