Search results for query: *

Hi there, I am in a real fix as to how-to solve this problem. If u cld point me in th eright direction or help me wld appreciate it very much. I have this humungous form with over 400 questions. the previous developer has split this questionaire into 2 seperate tables with one table being the...

Hi there, I certainly can use some help here. Pls let me know if any of you had this problem and how u solved it.. a big thanks comes your way. We have this huge questionaire of containing over 400 questions and the answers for some depend on cumultive totals of afew and likewise. I have this...

Hi there, I have a problem where i cld use some help. Scenario: There is a questionnaire that has over 400 fields. a composite of a few fields , lets say from Q1 to Q10 may be used to get a total field. there is code attached to this calc.. and it goes on for all the questionaire. Many...

HI there, The person who designed the db, I am currently working with, has a table that comes up with this message when I try to save it "Errors encountered while saving". She had added some fields to the existing table and kept working on it.. and now when i try to save it, it comes...

Hi there, Is there a way to selectively display fields based on one table based on choice of assessment? This is what i am working with . I have this psychological assessment that has 3 diff versions. some of the staff use an older version for their testing and some work with an internediate...

HI there, I have this client master with a whole nuch of information. Most importantly client names, ( last name, first name) etc.. with MasternO as the master key. I have an activity file with activity no as the master key. it also contains the master no and the 2 master numbers are linked to...

Hi there, I have read all the stuff on autonumber but cant understand where i am going wrong.. . this is my problem.. i have a table already created with 1000 over records by the user.. the data is coming in from another system where random numbers are generated. i wld like to have a...

HI, I have a table that capture many dates.. I have set it in my table as Medium format with this as input mask 99\->L<LL\-00;0;* So it is supposed to be data entry of dd-mmm-yy, right?? well the system for some reason does not allow me to enter it as dd-mmm-yy instead it changes to yy-mmm-dd...

Hi there, I have a little problem.. I have prepared a face sheet FORM and then when i go to FORM VIEW , ofcourse all of the records present in my client master is there.. i know i can print a filtered client by filtering the form by a ** given Client**. But there are times when the manager...

Hi there, I am looking at the site that was suggested to me for the password. I need to find time to secure it.. i have a simple question. the system I am installing is in another region. I have to access the latest master tables on a bi-weekly basis. Right now I am goign to ask them to zip the...

HI there, I have been working on a fairly simple database - and it is tested and ready for implementation. I have followed a lot of the postings on security etc. MY question is , Is there a simple, straightforward way to password protect the db. The system will be used by two of the staff...

Hi there, I love this forum as one learns a lot without leaving ** the seat. Thanks so much for all of you who help so selflessly.. I have a question which might be easy, but requires a wee bit of explaining. I have three check boxes, which are the various statuses a client can go through. IF...

Hi there, Would appreciate any help given for this. I have a few dates but what i want is a field called TERMINATION Date that is calculated by the system with the dates i provide it with from a query that i run against my db. I am using cr 8.5. THis is my case scenario. I need the report to...

HI, Is there a way that i can run a report based a date range by using the parameter field values.? Right now I have to go into the SELECT EXPERT to keep changing the dates every month - i.e. start date of activity and end date of activity.. I wld like the parameter box to come up and for...

Hi there, I have a crosstab with lots of data in it and ROW1 has the functional regions. I wld like to print each region on a seperate page. Right now what i do is use the Select Expert to show each region and print them off separately. For reports they have throw page ( new page after) , am...

Hi there, If anyone can point me in the right direction wld appreciate it immensely. I am working with Cr 8.5. This is what I am trying to display on the report. Let's say I have 10 clients. Each of them have a start date and an end date for their resp. treatment. I want the report to display...

Hi there, I wld like to name the summarized column data in a crosstab . I do not mean TOTALS. here is what the crosstab looks like Columns Activity date(grouped by week) Rows Summarixed columns By Region Sum...

Hi there, I develop crystal reports and am using the 8.5 version of it. I wld appreciate any help if you can point me in the direction of how to get my report to display only the first and last records in the detail section for each client within a specified group. Scenario: The data is grouped...

I find all of the information u provide so useful and sure use it whenever necessary. Esp. date formatting. I have crystal 8.5 and design reports all day long. I have a little problem you might find silly, but nevertheless any help is welcome. This is the scenario. I have client listing...

Hi there, I am having some difficulty with the above mentioned problem. I have to obtain the no of days between a clients birthdate and the current date and then convert that information to how old the client is in Yrs. and mths. Example: Clients birthdate: Feb 8, 2000 Current date: Jan 8...