Search results for query: *

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...

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...

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...

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 "Older" and "Younger". The younger clients need to have a goal set while the older clients do not. I...

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...

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...

I am creating a report based off an answer provided by lbass to my colleague in this forum thread767-622321. I am stuck on another portion of the report. The report needs to show clients whose follow up results are equal to '8' or '9' in any one of four follow-ups. The Details section is...