Recent content by BROWNIE56

I need to build a data map. Our software program has around 300 tables. I plan to break my info up into a Financial Section, Patient, Employer, Guarantor Sections, etc. Does anyone know of any resources on the Internet to get an idea of how I am going to go about this?

The field is a 50 character varchar Our users type in the name such as: Brown, Sharon Brown Sharon BrownSharon What I have to do it print, on a dot matrix form, the last name then the first name. There is room for 20 characters for the last name and a few blank spaces then room for 15...

Our name field prints the lastnamefirst name in one field. How would I print the first 20 characters of the last name followed by 5 spaces then print the first 15 characters of the first name? Thanks, Sharon

How would I make the following ToText work corrctly ToText({EMPLOYER.emp_rep_start_date}), "DD MM YYYY") I want my date to print like: 03/28/02 Thank you

I need to be able to display an account number that will always disply "zero's" before the account number, up to six digits. Example: 000056 001112 023433 000001 Thank you, Sharon

Our SQL database has a notes field (varchar). This prints notes in a report. In our program you can type and enter tabs using alt-tab (same as in notepad or in excel). When the data is passed to SQL the tabs are displayed as little boxes. Crytsal does not recognize the tabs that are stored in...

Yes, it represents 3:15

varchar

I need to show a total time of two visits (example in a doctors off, time in and time out, then show the total time of the visit) Visit time in: case_vis_in (varchar) 1515 (time in table) Visit time out: case_vis_out (varchar) 1600 (time in table) I need to be able to display the total...

I need to show a total time of two visits (example in a doctors off, time in and time out, then show the total time of the visit) Visit time in: case_vis_in (varchar) 1515 (time in table) Visit time out: case_vis_out (varchar) 1600 (time in table) I need to be able to display the total...

I need to show a total time of two visits (example in a doctors off, time in and time out, then show the total time of the visit) Visit time in: case_vis_in (varchar) 1515 (time in table) Visit time out: case_vis_out (varchar) 1600 (time in table) I need to be able to display the total...

How do you get just the system Year to show? What I want to place in a report is The word "Year" a space followed by the system year. This is used on a OSHA report. At the top of the form it reads Year 20__. If this form was used manually, the user would will in the last two digits...

I have a method I use to convert our time from a database from military time to "civilian time." I just ran across one field in a table that has the time stored as: 12:15 instead of 1215 (like the rest of our tables with time). How can I remove the ":" to make the...

How would I write a formula to display a message such as, "Your bill is over 60 days old" when the follwoing is met: WhilePrintingRecords; NumberVar over2month; if(over2month=0) then 0 else over2month/100

Thank you. But, we have to stay with Crystal 5. Crystal 8 runs are reports way to slow.