Search results for query: *

I am working on customizing a build-in report that came with our software. The report has 1 Grouping, Data.DefaultStudentSort, and 13 Details sections. The data cannot be seen through Crystal; the report has to be uploaded into the software for any data to show. I am trying to keep the...

Hi, I have a report that came with our Student Management Software. This report has a field {Data.Comment}. The field, {Data.Comment} returns comments one on top of another. Example... Great progress A pleasure to have in class Demonstrates positive attitude I changed the report so the...

Hi all, I am working with a report that has Attendance Values printing at the bottom of each student's record. I have been asked to move the Attendance Values up to the Page Header. I created a Variable and I get either 1 of 2 results depending on if I use WhilePrintingRecords or...

I have been tasked to create a Mailing Label for our school that only pulls the youngest student from each family (based on each student's address) and sort the results by homeroom. I had already created the Youngest in the Family Mailing Label before I found out about the homeroom sort. I...

Is there a good way to remove all formatting tags off of a RTF field so they don't display on the report? The RTF field I am using, I need to cut apart and only display part of it, when I use the InStr command the tag "/PAR" shows on the report. I used the "Replace" command but if the user...

I have the following formula in a query... DateOfEntryGrade9: IIf([Current Grade Level] In (["09","10',"11","12"]) And IsNull([Date of Entry Grade 9]),"Date of Entry Grade 9 - Null Error",IIf([Current Grade Level]<>["09","10","11","12"] And Not (IsNull([Date of Entry Grade 9])),"Date of Entry...

I have a report which has fours parameters; School, Grade, Gender and Ethnicity. If a user does not select any criteria for the parameters, the report will automatically pick the first School(304), the first Grade(Kindergarten), the first Gender(female) and the first Ethnicity(Asian) and return...

We have a SQL based proprietary database as a Student Management System. On the address table, the street address (ie 123 Main st) is all stored in one field. I have been asked to create a report by Street Name. Is there a formula that will pick up an address after the first break? For...

I have a Main Form (frmProject), a subform (frmPO) and a nested subform (frmPO Line). There is also a table tblItems. My nested subform has a combo box that picks up the Item ID and I am trying to set the Item Description (and Unit Cost - that will be another field) in the nested subform so I...

I have a simple parameter that works fine for Discrete or Range values. However, when I select Allow Multiple Values, and run the report, an error occurs, This array must be subscripted. For example: Array[i] The Select Expert is {CSL_STD_DEMO_SCHOOL.ACTIVE_STATUS} = "Y" and...

I inherited a label report where the Names and Addresses were put in the Details section instead of Group 1. I moved the data to Group 1 but now I can't get the report to print multiple columns. In the Section Expert, Details section, Format with Multiple Columns is check but greyed out. In...

This is the nesting structure of the forms... Main Form: Projects Subform of Projects: PO Subform of PO: PO Line (datasheet view) When I enter data into PO Line, a new line item does not appear so I can not enter in any more than one record at a time. I have to either click on the next PO or...

I have the following variable in a formula... Global StringVar DentalCredit4111; DentalCredit4111 := If {deditems.dedcode} like "8760" then "$ 41.11" else Global StringVar DentalCredit9961; DentalCredit9961 := If {deditems.dedcode} like "8761" then "$ 99.61" Group 2 is {deditems.dedcode}...

The following formula is in the Suppress section (in Format Editor) of my subreport field on the main report. GroupName ({dbo_CSL_SET_SUBTEST_CODE.SUBTEST_CODE_DESC})<> "NYS ELA" and GroupName ({dbo_CSL_SET_SUBTEST_CODE.SUBTEST_CODE_DESC})<> "Total Reading" or...

I have a subreport with a width of about 1". How do I make this wider??? Thanks, Hillary

Someone was kind enough to share a Crystal Report with me. Her database name is CSL_SALINE_DA and ours is CSL_WCSD_DA. Is there anyway to update the Crystal Report or do I actually have to rewrite the report? I'm on CR 9.0 Attached is the SQL SELECT "DA_SchoolStudent"."LastName"...

I have a database which is linked to our main student database via ODBC. We have used this database to report students with low test scores for 2 years. I have been asked to include report card grades for students who are already on this report. Because the report card grades were from last...

I have a database which is linked to our main student database via ODBC. We have used this database to report students with low test scores for 2 years. I have been asked to include report card grades for students who are already on this report. Because the report card grades were from last...

I have an Access Database linked to our main student databse. We are attempting to print Emergency Conact Forms from the Access Database. The data reports and prints fine from my PC, however they are having problems printing the data at the school. At one school, they are able to print the...

I have a subreport which brings in courses and grades for a student. Groups 1 and 2 are two different Student ID's, Group 3 is the Course ID and Group 4 is the Bin (Bin are basically like Quarters - Quarter 1 = Bin 1, Quarter 2 = Bin 2, Quarter 3 = Bin 3, Quarter 4 = Bin 4, Class Exam = Bin 5...