Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. JeroenBoon

    dynamic parameters in schedule, CR10, CE10

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

    CE10: link to PDF from report

    Hello Groggle, The problem is that CE places 'http://<servername>/crystal/enterprise10/admin/en/' in fron of my calculated location of the file. This calculation alone would do the trick. I only need to know how to tell CE not to place anything in front of my calculation.
  3. JeroenBoon

    Emailing Reports

    (actually, if you don't want the schedule to run directly after you reset is, you must make sure that not only the schedule date=today, but also the schedule time>now. otherwise the schedule will start immediately. So if you want to reschedule a schedule that usually runs earlier than that...
  4. JeroenBoon

    Emailing Reports

    This has been discussed in some earlier threads... (don't know which ones) Jeroen.
  5. JeroenBoon

    Emailing Reports

    Hello Simon, maybe you should set the schedule again? In CE some changes to the report don't immediately have affect on the output of the schedule. After setting the schedule again, all changes take place. Jeroen.
  6. JeroenBoon

    CE10: link to PDF from report

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

    Refresh option &quot;Default Database Logon Information&quot; CE10

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

    saving changed reports without re-entering password? CE10/CR10

    Hi Turkbear, thanks for your answer. But: is this a setting I have to change for every report, or can I change this for all reports at once? And can I uncheck 'Default Database Logon Information' as default for all future reports? Jeroen.
  9. JeroenBoon

    saving changed reports without re-entering password? CE10/CR10

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

    schedule from mon-fri from 8 AM to 6 PM (CE10)

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

    analyzing tool for tabels used in reports, mailaddressen in schedules

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

    printing barcode in CR10

    Hi oneilltnc, thanks for your response. We already have the font I would have to use. But the problem is that just printing the EAN13 in the right font doesn't result in a scanable barcode. F.I. ean '2560100000518' has to be transformed to a sting and that string has to be printed in the right...
  13. JeroenBoon

    printing barcode in CR10

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

    suppressing footer when on new page

    thanks Durango122, but I think I wasn't clear enough. I want to suppress the groupfooter every time that the header and details are on one page and the footer on the next. I don't want a page to start with the footer that belong to the group that starts on the former page. (So my report has more...
  15. JeroenBoon

    suppressing footer when on new page

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

    change made to reports

    read the post 'Do I need to reschedule a report when it's modified???' first, it's a good explenation.
  17. JeroenBoon

    change made to reports

    When you open a report in CR using the address as displayed on the properties tab, just below the report name (e.g.: frs://Input/a_141/219/001/121741/151445c05087b26.rpt) you can modify almost everything you want and save the changed report without having to reset the database logon information...
  18. JeroenBoon

    selecting the most recent record

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

    can't get report on lotus notes DB work in CE10

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

    Cross-tab 'show as percentage' sum&lt;&gt;100%

    Thanks Ido! youre suggestion made me figure out an even simpeler solution: shipmentlines have linenumbers, so I created a counter that gives a 1 when linnumber = minimum linenumber of the shipment or else a 0. In the cross-tab I sum the counter and in the second column I show the summed counter...

Part and Inventory Search

Back
Top