Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. onebigscot

    Printing records on separate pages...

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

    Printing records on separate pages...

    Thanks Paul, I haven't been able to get back to this and try it, but I will next week. David
  3. onebigscot

    Printing records on separate pages...

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

    Combining data from multiple records

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

    Display blank field as "N.A."?

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

    Display blank field as "N.A."?

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

    Display blank field as "N.A."?

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

    Data Omission

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

    Masters Degree?

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

    Online Degrees - Any one doing 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...
  11. onebigscot

    Annual Trend Report - multiple parameters

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

    Opinion on Business Systems Analysts

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

    Opinion on Business Systems Analysts

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

    MAS90/200 Data Dictionary search

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

Part and Inventory Search

Back
Top