Thanks for the help, it works fine. However I did not insert the not onlast page formula, and now I cannot get back into it as it seems to be locked.
But at least I have the rest of it...
Thank You!
David
...I feel that I am missing something easy, but I have searched here and in a manual with no success.
I want to print timesheets. We are using an electronic timekeeper and it currently prints out all the timesheets in one group. The result is that one employee's timesheet might overlap onto...
Hello!
I tried a search, but no luck with the keywords...
I am using Crystal 8.5, pulling data from a relational database.
What I want to do is combine some of the data from two records into one line for my report. I am tracking movement of an item between multiple locations. For this...
I actually had to use both (maybe that was what you had intended). When I swapped the original code (isnull) with the trim command, the records that were blank now had the "N.A." inserted but the records that previously had "N.A." were now blank.
So now I have both commands in the formula and...
Thanks everyone! I used the...
IF isnull({field.name}) then "N.A." and put it before the rest of the options and it worked.
There is one odd thing though, about ten of the lines (out of 800) don't have the "N.A." displayed even though there is no end date. It works fine on all the other...
Hello,
I have tried the Keyword search and Osborne's Reference Guide with no luck...
I am working with a SQL database and using Crystal 8.5 to pull data for export into Excel. I have fields which are blank and I would like to autopopulate these fields with "N.A.". Any ideas?
Basically, what...
Forgive me if this has been addressed before, I performed a keyword search and had no success...
I am working with CR 8.5. I have minimal experience with the system, reporting out of a SQL database. The reports I am creating usually revolve around clients who are active. To do this, I use...
I work in an accounting department and am getting a bachelors in systems analysis. From my experience with my agency, there needs to be someone with an education involved on a project. There needs to be one team member who can understand the implications of what the program does and how it...
Hey Glen Johnson, I will be completing my BSIT degree from the University of Phoenix in December. Most of the time I was in a classroom and part of a "learning team". Each class lasts five weeks, with individual projects or papers due each week and a group project (and paper) due at...
Hello,
I am working on an annual payroll trend report - comparing monthly budgets numbers against the actuals as they are produced. There will be 24 columns of information: 12 with budgets which are predetermined and twelve that will develop with each month.
Is there a way I can set the...
Hey Sleipnir,
Basically, a Systems Analyst acts as a translator between users and programmers, two groups who tend not to understand what the other needs (or is saying).
A SA researches the job request, interviewing employees and studying how the job used to be done. They compile this...
Hello,
Currently, I am a Reporting Analyst in the accounting department for a large social service organization in Northern California.
Soon I will be graduating with a BSIT degree, specializing in Business Systems Analysis. I was curious to see what everyone thinks of having a BSA on their...
Hello,
I have been using Crystal for six months, pulling information out of a database my organization uses. Now I also need to also pull data out of our financial software - MAS200. I found a rather weak data dictionary in a PDF file, but the table and field descriptions are very limited...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.