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

Thank you everyone. As always, you guys are terrific!

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

Thanks a bunch Carliy. That worked perfectly. To be honest, I was decreasing the the characters per inch, thinking smaller was better. Duh.

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

Thank you all. I had never created a cross tab report and now I'm hooked.

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

Thank You Thank You Thank You. I had most of the calcs right but just learned a new one. I wasn't aware of the "inrepeatedgroupheader".

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