Search results for query: *

Ken, The tables to which I am linking are in an Informix database. This database recently received a patch in which two of the tables received one new field each. I went to do my montly export to CSV files and the vendor to whom I send these files reported that these new fields were not in...

To all, I have a macro to automatically export thirteen linked tables in Access 2003. The database to which these tables are linked was recently updated and new fields were added to two of the tables. In order to have these new tables appear in my linked tables I deleted them and created new...

SkipVought, While that code did bypass the display of the window, that gave me the Update Values message and forced me to open the spreadsheet once for every reference to it in the VBA, it did not solve my problem. Now all of the references to the cells in the other spreadsheet just show the...

I have written a macro in Excel 2003, Windows XP, that takes a spreadsheet exported from Crystal Reports so that I can add more data from another spreadsheet and perform some calculations. I have written VBA to do all of this but when I open the exported Excel spreadsheet and launch the macro...

PH, I can't thank you enough for the help. It worked like a charm! I will also consider your suggestion of just using the date for when the VBA is run instead of asking for the input. I guess that I am just so used to creating the folder with the date I didn't consider any other way. I had...

I have an Access database that has 13 tables which I need to export into 13 .csv files with the same name as the tables. I am attempting to do this with VBA in Access 2003. So far I have used DoCmd.TransferText and hard coded the file names into the VBA code. I would like to use an "InputBox"...

I am creating a report using CR8.5 on WinXP. Most of the data is in an Informix database. I have some contract plan numbers that are not stored in this database. I have them in an Excel spreadsheet, but that format can be changed if need be. I have a crosstab that has three formulas as rows...

OS: Windows XP Crystal Version: 8.5 DB: Informix Is it possible to print the computer user ID in a report field? TIA, Paul

I have been asked (does your boss ask?) to create a report that checks 3 conditions for each client. The first two conditions were easy because they just checked conditions in one record, the third condition and the difficult part (for me anyway) is that each client can have multiple client...

To all that helped, I got it to work. I don't understand why but when I changed the order of the IF statements it worked. I moved the {@older_younger_youth} = "Younger" line to the top and that solved the problem. This is how it looked when it worked... IF {@older_younger_youth} =...

synapsevampire, That formula is in my report. It returns what I expect. I cannot figure out why I cannot exclude those records that return "Older" from being higlighted. lbass, I get the same results with your formula. I just can't figure it out. Paul

I am about ready to give up on this report. I included an IF statement to exclude those records with no goal set date Here is the formula I am using.. If IsDate(ToText({youth_goal.dt_set})) And {youth_goal.dt_set} + 365 < CurrentDate And IsNull({youth_goal.result_cd}) And...

Turkbear, That's it! If they Older youth didn't have a goal set then the first IF statement is null also. The test formula that you suggested which was my highlighting formula changed a little and all older clients where null and younger clients with overdue goals where true and all others...

synapsevampire, I apologize for not making my post clear enough. Actually the highlighting formula works fine without the And {@older_younger_youth} = &quot;Younger&quot; line. That is all clients whose youth_goal.dt_set is over one year old and who youth_goal.result_cd is null are...

I am using CR 8.5 and I am attempting to higlight certain records in a report that meet certain criteria. The report is composed of clients who fall into two catergories &quot;Older&quot; and &quot;Younger&quot;. The younger clients need to have a goal set while the older clients do not. I...

Nevermind! I was messing around and entered this formula below and received the results which I was wanting. If isnull({wia_actvy.wia_cmpltn_cd}) And {wia_actvy.end_dt} - 90 < CurrentDate And {wia_actvy.end_dt} > CurrentDate Then 5 This caused the formatting in the dropdown to be applied...

synapsevampire, Thanks for the reply. Do I just have to apply this same formula to each field that I want to have the formatting when the end_dt field meets the condition? I know in the Section Expert I can change the background color on conditions set forth in a formula. Is it possible to...

I need to modify a report so that the font on rows that meet certain conditions is bold italic. I need to use this in combination with a highlight that I created with the section expert that highlights on another condition. This is what I am thinking of for the bold italic If...

MJRBIM, Thank you! That solution worked perfectly and was very informative as to how to create formulas in Crystal. I will make sure to keep it handy for future reference. Paul

I am starting to work on slightly more complicated formulas now so I need the experts help. I need a formula that checks a field in a table and prints 'In' or 'Out' depending on the contents. Version: Crystal Reports 8.5 table name: app If app.educ_stat is equal to '1' or '5' then the field...