Search results for query: *

Good Morning. I have run across the most frustrating situation. I have written a Crystal Report (V XI) and then save it to my folder. When I reopen it, the grouping has changed and the fields have changed. Example: when saved, column 1 was check# but when I reopen it, column 1 is now check...

Good Morning - I would like to recalculate a double last name field to return a new value based on special characters and spaces. For example: Diaz-Garcia would return Diaz, Abel Smith would return Abel. Not sure how to go about this. Thank you for all the help.

Good Morning and TGIF. I have a report that I want to use multiple columns in the detail section. The catch is, I only want to print 2 across and 5 down, for a total of 10. The data can run beyond 10 elements. I need to limit the data elements since I have additional data that prints after the...

Good Morning All. I have run across a problem with an export to an outside vendor. I execute a fairly simple Crystal report and FTP it to their site using the automatic scheduler. When I open the file in either Notepad or EXCEL, the file looks great. But this company says that there are (3)...

Morning All. I have set up an automatic download from crystal to a text file that needs to run every night. The problem is that the record line is being truncated. I have played around with exort settings with no luck. Any thoughts? Below is a sample of a record I am exporting. Thank you all...

Good Morning. I have a report that prints at detail time a student name and their disciplinary actions. I need to print a total for each action at the end of the report. My dilemia is that currently their are a possible 60 different actions and that can be added to at any time. I only want to...

Hello All. I need to create an automated report that produces a .csv file that contains one header record. After the export, when I look at the file in notepad, the header record is on each line. I have to export this to an outside vendor that is unbending on file type and the one header...

I have a field that needs to output either a checkmark or a plus sign. I know to get a checkmark, the font is wingdings, chr(252). For the plus sign, I need font arial. Not sure how to do accomplish this. I am using Crystal XI. Can you all point me in the right direction? Thanks for the help.

In section expert, I am defining the following criteria under the common tab for the supress function... fld1numeric = 0 and fld2numeric = 0 and fld3alpha = ' ' The report runs without error but.. when trying to export this file to EXCEL, the fld3alpha = ' ' comes back highlighted and will not...

I would just like to clarify my programming. In my report, I have (1)primary file that I would like to link with (3) additional files. All links would be left-outer joined. This is OK as long as I don't use a filter in my record selection. Correct? Thank you for the help.

Good Morning All. Quick question - I have several reports that I have scheduled that run once a month. As you know, as programmers we are constantly asked to make changes to reports. Do I need to reschedule a report that has been modified? Or are the changes automatically reflected and no...

I have created a Crystal report listing based on three education courses and the students enrolled in those courses. The report exports to EXCEL with no problem into one worksheet. Is there a way I can export that list into three worksheets based on the course? Thanks for the help.

I have created a report that produces one line of data per customer. The last three fields are generated through a subreport. When I export to EXCEL the main report data is on one line and the subreport data is beneath it on another line. Is there a way to export so that it remains on one...

Good Morning All. I am having brain freeze this morning. I need to read multiple customer records and output a field from each records on one line. TABLE: Customer Id Slot Designation (multiple for each customer) IE: John Jones ADMPRN John Jones DEDCT John Jones EXTCUR I need the output to...

Hi Everyone. I am soooo baffled. I am using Crystal Reports XI and trying to create a report of missing teacher attendance for a specific day. I have two tables; (1) containing the course data and (2) containing if the teacher DID take attendance by date and course. Example of table data...

Good Morning All. I have a file by room and course - some rooms have one record and others two. I want to read the file and move the first course to variable field 1 and if there is a second course, move that field to the variable field 2. The subreport is grouped by room and I am outputting...

Can a Crystal report be exported to EXCEL and retain it's field color charactistics? Right now, all data exports to EXCEL in black even though certain fields are color in the report. Thanks.

I have created a simple report that calls on a subreport to display one addtional formula field at the end of the record. I can export this report to adobe with no problem but when I try to export to either a CSV or EXCEL, the subreport field drops off. The record lenght is less than 80...