We collect maintenance data on aircraft. Each aircraft is assigned a serial number called BUNO. When receiving maintenance it goes through different phases, we refer to as 1 PMI, 2 PMI, 3 PMI and Baseline. The query I am developing only wants to look at BUNO's that have gone through maintenance...
I am using CR 8.5 and want to create a line chart ploting standard deviation of task manhours. I am having a terrible time trying to create this chart. I have 4 fields as follows:
Location
Phase
Task Number
Standard Deviation Manhours
I want to group by location then phase. I want my x axis to...
Our database has a SQL backend and a Visual Basic Frontend for data entry. I often create reports via Microsoft Project. My question, in a query I am summing two integer fields, if their are no manhours for one of the fields it is left null. However, when I try to sum them it will not sum unless...
I am new the CR, am running CR 8.5. I have created a report that stores the data with the report which makes the report almost 1 meg. My question is can i store the report without storing the data with it and will query the database upon opening.
I am creating a report and each record for that report is numbered starting with one. I used the special field "record count", however, I need it to start over every time their is a change in Aircraft. Could someone please tell me how to do this? Thanks so much.
Thank you both so much. I did later realize that they must remain in the same order as the field list. So I suppose if I alter the view for the report it must go in the end of the view. Thanks again.
Hi, I am brand new to Crytal Reporting. I have created a report via an ADO connection to the SQL Server. I clicked refresh to update the data and although my text fields in design view still read the same, the data displayed is from another field in the SQL view. It seemed to scramble my fields...
I currently have a form (Form1) with a subform (Form2). After entering criteria in Form1 the results set is displayed in datasheet view on Form2. I would like to create a button when pushed will open a new Excel workbook and then send the results set from Form2 to a worksheet. Any help with...
Right now in the "no data" property there is a message box that says there are no records for this aircraft, however, I want to replace that with a blub the says "no defects" in the discrepancy field.
I have developed a report based off a select query, the user must enter an aircraft number at the prompt, my problem is I need the query to return a "no discrepancies" statement in the discrepancy field is no records are returned. Can this be done, if so was wondering how to do it...
I am creating a report based on a query of which I have enclosed the following SQL code. What I need to accomplish is if their are no records returned based on buno_no, it returns "No Discrepancies" in the discrepancy field. Thank you in advance for your help.
SELECT...
I am developing a series of reports for maintenance on aircraft and if no maintenance has been performed for a particular aircraft the query will obviously return nothing. However, at the report level I need to display in one of my text fields (discrepancy), "No Discrepancies". If...
What I was actually trying to do is find a way to return only the top 6 part numbers grouped by task number. It was suggested that I create a form with a counter that resets everytime the task number changes, running the entire table through this form. This would allow me to untilize this...
Thank you both with your help. Tigi1, your proposal seems to be what I am looking for. Could you possibly give me more direction on how to increment and reset counter on form. Have never done this before.
Thanks
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.