Hello...
I have a parent table called Tickets (tech-support tickets) and a related child table named Tasks, related via TicketID. One ticket can be made up of one or more tasks. Each ticket has a status of open or closed. Each task has a status of completed, waiting, etc.
I'm trying to...
Hi. I have a form called RFP Entry. On it is a subform (RFP Expenses subform).
In the continuous subform for a new expense record, I choose a doctor from a combo box (Doctor_ID), select an account from a combo box(Account), and fill in an amount of the expense in a text box (Amount). Each...
Hi. I have a form that does not display either the horizontal or vertical scroll bar. The Scrollbars property in the form's property sheet is set to both, so I was curious if there was something else I'm missing that would cause this. Not sure what other information to provide. The form is...
I have a combo box named Account on a subform named RFP Expenses subform. That subform is on a main form named RFP Entry. There is a text box on RFP Entry named Account_To_Be_Charged. The main form and subform are linked via a field named RFP_Number. For each record created in the subform, I...
Hi...
I have a field named RFP_Number in a table named RFP_General_Info. I would like to have something like a parameter query that can prompt a user to enter a range of new RFP numbers (e.g., from 5001 to 5500). I would then like those numbers used to create as many new records in the...
Hello!
I have a Projects table with 11 project records. I have an Employees table with 25 records. Each project has an ID (Project ID) and each employee is assigned to work on one project (Project_ID Number). The tables are related from Project ID in Projects to Project_ID Number in...
I have 2 parameter fields that ask for dates and customer name when the report is refreshed. The dates will accept multiple values (discrete & range values). The customer name accepts multiple values as well using a drop down list on the parameter box.
So, we're wanting to print in the header...
It seems that unless I hide or suppress all group sections in my report, the turquoise magnifying glass symbols do not appear in the group tree. I'd like to have the symbol display next to all groups in the group tree when doing a summary report so that the symbol gives some visual cue that...
Once several parameter fields have already been created in Crystal, they appear to show in the list at the top of the "Enter Parameter Values" box in the order that they were created. Is there any way to change the order without removing and then recreating the paramter fields in the...
A student would like to print the report so that the first page prints to one tray in the printer (with company letterhead) and the remaining pages print to a different tray in the printer (with regular paper). The student mentioned the old DOS printing codes or something like that as an option...
In Crystal 8.5 Pro (and perhaps earlier versions), you can open a *.rpt file in Windows Notepad, and in all of the jibberish that displays, you can find the field names used in the report, the directory path used to locate your database file or database server, login information (username &...
In Crystal 8.5 Pro (and perhaps earlier versions), you can open a *.rpt file in Windows Notepad, and in all of the jibberish that displays, you can find the field names used in the report, the directory path used to locate your database file or database server, login information (username &...
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.