Search results for query: *

Hi, We use CR10 and CE10. I want to accomplish that a customer can run a report by scheduling it to a fixed format (txt) and to a predetermined email address, but with the possibility to fill in the parameters of the report after selecting 'schedule' and before the report runs. Is this...

Hello, On one of our servers we store customer invoices in PDF format. I created a Crystal Report that shows the invoice numbers and by clicking on a field with a hyperlink to the specific file location of the invoice, the report picks up the file and shows the PDF. This works great. But now I...

Hello, - is there a possibility to unselect the Refresh option "Default Database Logon Information" in CE10 by default? So when I import a new report CE should not select the database option by default. - is there a way to unselect it for all imported reports at once (don't take this personal...

Hello, When I open reports in CR10 from the enterprise environment, change the reports and save them, CE wants me to enter the password in Crystal Enterprise afterwards. Is there a way to save changed reports without the need to do this? At the moment I evaluate a trial version of the .rpt...

Hello, I have a report I want to schedule from monday to friday (easy, 'weekly' and select all workingsdays) but also every 15 minutes but only from 8 AM to 6 PM. Is there any way to da that in 1 schedule usin CR10 and CE10? Thanks, Jeroen.

Hello, we use CR10 and CE10. Now I need a tool that can tell me in which reports a certain table, or a certain field is used. I can inagine I select a table or field name and the tool gives me the object names I need to know. What I also need is a way to select all objects that are scheduled to...

Hello, in one of my reports I print article information, including the EAN13 of the article. Now I also wat to print the barcode, so the articles can easily be scanned from the print. How do I do that? Thanks, Jeroen.

Hello, I want to suppress the groupfooter when the footer is printed on the next page. This must be simple, but I can't figure out how to do it myself. Jeroen.

Hello, I have a table with per track and trace number one or more records. Each record has a date and time. Now I want to select the most recent record per track and trace number. To do this, I use the following statement: SELECT TABLE1.TRACKTRACE, TABLE1.CODE...

Hello, I've made a report with CR10 based on a lotus notes database that runs locally on my PC. When I want to publish this report in CE10, I can't get i to work. After I fill in the parameters CE inmediately returns the message 'Failed to load database information'. I've tried different...

Hello, I hav the following problem: in a cross-tab I display number of shipments in three groups. In the fist column I display the distinct count of the shipping number (a shipment has multiple lines). In the second column I display the distinct count of the shipment numbers as a percentage of...

Hello, I have some reports that, when printed from the CE, want to be printed on Letter instead of A4. Everyhere in the report, or in the printer settings there is selected A4. Does anybody know how to solve this? Greetings, Jeroen.

Hello, CE10, CR10, Oracle database: I have a report that collects information from two different locations that communicate via a lan2lan. At the remote location I get some general order information and locally I get the orderdetails. When I run a query on the table on the remote location I get...

Hello, is it possible to restart failed schedules all at the same time? At this moment I check the schedules with the instance manager and after that I restart the failed schedules, one at the time, by browsing to its history and clicking the restart button. Greetings, Jeroen.

Hello, is it possible to rename a folder? would be much easier than creating a new folder with same rigths and moving the reports. Jeroen.

Hello, I have a 2 hour time difference between the {CMS_AUDITTABLE.timestamp} and my real time. Does anyone know where this difference can come from? (BTW: Schedules etc run exactly on time, CR10, CE10, Oracle) Thanks, Jeroen.

Hello, is there a way to export more than 1 report to different tabs within 1 excel file? at this moment I'm using CR10 and CE10, but I'm thinking of migrating to CR11 and CE11. Thanks, Jeroen.

Hello, We have a server with CE10. We notice that the PF usage of the server after a reboot is about 300,000K in total. But this figure grows and grows from that moment on. The most memory is used by the webcompserver.exe, followed by the pageserver. Why does this figure grow? Does it affect...

Hello, I have a report that produces a PDF scheduled on a daily bases. But some days there is nothing to report and the PDF is empty. Now I want to schedule the report only when there ara records to report, so the PDF would not be empty. I think I need to use an event, but how? I would like a...

Hello, is it possible to fill or update databasefields using Crystal Reports? (CR10, oracle DB). Jeroen.