Search results for query: *

I have a list of dates work was done. The dates (A) fall within a pay period (B). How do I compare the date to the list of dates in a column, determine if the input value is within the pay period & if true, insert the pay day (C) for which that work day will be pay? There is 14 days within the...

I would like to remove the 0(zero) values in my Array if the entry is not filled from the iterations of the For loop. I've tryed using the [i]as the subscript for the ToText which would (I think) make the number of entries variable. I coded ToText(NewIDs[i],"#") + ', ' but versiion 8.5 of...

I have formual field called child_allergy in conditionaly place the DB field in the formual field or insert another value if a condition is not meet. WhilePrintingRecords; if isNull({ChildUserDefined.Allergy}) or Trim({ChildUserDefined.Allergy}) ="" then "None On File " else...

I'am having trouble getting related data to print. I figured if I could see the records being fed to the print routine I could figure out what I'm doing wrong. I'm told there we can veiw Crystal Report report dataset of the records. How is this done? We have Crystal Report ver. 10(Sandard).

My table (MS/ACCESS) is in accending date order. I need to create a report accessing the latest data(current date). The read begin at the start of the table. There are 76k records before the data to report on is selected. I spoke the vendor who creates the Access table and explained that their...

I have batted this report around all week w/o getting it to work. What I have is a DB table w/ IDCODES (string). The IDCODES can be 1000 - 9999. However the assignment numbers are randomly made and are not in the field called "IDCODE" until entered. Thus, there are missing numbers in the...

WhilePrintingRecords; Global NumberVar Nxt_IDCODE02; Global NumberVar Old_IDCODE01; ToNumber next({IDCodes.IDCode}); ({@Nxt_IDCODE02} = Next ({IDCodes.IDCode})); ToNumber ({IDCodes.IDCode}); ({@Old_IDCODE01} = ({IDCodes.IDCode})); ({@Nxt_IDCODE02}) - ({@Old_IDCODE01}); I need to...

I need to read the {file.idcode)that is a number string. Read NEXT (file.idcode}. Make both numeric. Subtact the 1st. {file.idcode} fromt the NEXT file.idcode). My array are field1 - field10 Use the differance as the counter and as an increment in a loop. Here is my suedo code for the loop: Do...

In the report the parameter allows for multiple single entries. However if I want select all the records how can I default? Example: parameter accepts: AZ MO WI DE SD ND. This will give me all the records for these states. What would I code to get default for all 50 states?

I'm learning Crystal report on my own because the non-profit organiztion which needs applications using Crystal Report can not afford to send me to the $800+ classes and I'm not position either. So I have to come to a place where the knowledge is. Now, in a report I have copied and changing has...

I have created a report and it is ready for the user to use. But, I don't know how to run it without it opening up in the design mode. This report has a parameter screen where the user select from a list to select the desired records. What I think should be happening whent program is started...

I would like to get a manual that list the format and show examples for the formulas used in Crystal Report. We are using Release 8 and the reference book by Osborne, but I need to see better examples that work.

I have a DB that has immunization shot dates. There are 1 - 12 rows with 1 - 8 columns each. The rows are filled left to right with the name of the immuniztion and the columns value being a date the shot was given. Not all row (immunizinations)entries or columns (dates shot given) are filled. I...

We just purchased Crystal Report 8.0. Yes it is an older version, but we are using ProcCare's Child Care Manager application. Their system will not support ver. 9 or 10. We need to create a report using data from ProCare's Access data base. Crystal Report is used by ProCare to create reports...

We have a report that is a 1-3 columns (depending on number of students)table in WordPerfect. We would like to designed the report crystal report. The variable data will comes from a dBase 5. Has anyone created a report table where the table could/would extend to the next column and/or page as...

I have 3 tables each primary key is SPONSORKEY. SPONSORS table CHILDREN table CONTACT table sponsorkey sponsorkey sponsorkey last name childrenkey contact first name last_name conttype mi...