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

    Exporting to PDF formatting issues

    Thanks for the response. The Java Reporting Component will only export to PDF or RTF. RTFs seem to be fine. Am using Adobe Reader 7.0, and the exported reports are brought up in a browser window using an Adobe plugin. Exporting directly out of Crystal does not give me these problems, so...
  2. plarson3

    Exporting to PDF formatting issues

    We use the Crystal 11 and the Java Reporting Component to run our reports and then export them to PDF. The generated PDFs are dropping many of the dollar signs, adding commas to number fields, and turning non-currency numbers into two decimal place currency type fields. Anyone have any...
  3. plarson3

    Counting Occurences of Values

    Thanks to both of you. Both good options. I am especially loving the crosstab. Had never played with them for that purpose before. Will solve many other issues as well.
  4. plarson3

    Counting Occurences of Values

    Is there any way to count the occurrence of each value in a certain field in a report, when you don't know what the values are going to be? And then show the total count for each of those values at the end of the report? Lets say its a Name field, and the values pulled into the report could be...
  5. plarson3

    Showing multiple groups subtotals all at end of report

    Is there a way to show subtotals from subgroups (Group #2 or #3) together at the end of the report instead in their respective group footer throughout the report?
  6. plarson3

    Crystal Version 11 (XI) - Java Bean as Data Source

    Currently, in versions 10 and prior, in order to access a Java Bean as a data source, it requires the manipulation of a PC's registry, which we are reluctant to do. Does anyone know if that is still the case in version 11?
  7. plarson3

    Locking Down Reports

    We use Crystal and the JRC embeddeded as part of a larger application that we deliver to outside clients. The application itself does in fact export the reports to PDF once they are run. But what I want to prevent though is ability for our clients to pull the report files themselves (.rpt)...
  8. plarson3

    Locking Down Reports

    Would the Java Reporting Component of Crystal, which is what we use, recognize and run your .RPZ files? You probably know this, but the JRC is the web component of CR10, which will run an existing .RPT file and then display in a web brower format.
  9. plarson3

    Locking Down Reports

    Using CR 10 Advanced Developer, but not using Crystal Enterprise. Want to be able to secure/lock down/password protect my .rpt files. Any way to do this? I see the READ ONLY options, but those options can be turned back off by the user.
  10. plarson3

    Integrating Crystal into Java app

    We have Crystal reports integrated into our Java application. Crystal report connects to the database via JNDI datasource. So far we got it all working on Oracle but now we would like to run same reports on MS SQL Server. After pointing JNDI datasource to MS SQL Server we received error...
  11. plarson3

    Integrating Crystal into Java app

    We have Crystal reports integrated into our Java application. Crystal report connects to the database via JNDI datasource. So far we got it all working on Oracle but now we would like to run same reports on MS SQL Server. After pointing JNDI datasource to MS SQL Server we started getting an...
  12. plarson3

    Can you incorporate Parameter into Command SQL Query?

    The other side of that question is: If I use the standard parameter fields within Crystal, outside of the query itself, does it bring back all rows first, and then filter by the parameter after the fact?
  13. plarson3

    Reports Converted to PDF - font 'bad /BBox' error

    Anyone run into the issue of, once converting reports to Adobe PDFs, when attempting to view reports, getting a wierd error saying font contains a bad BBox? Report still views fine (it appears), but at the very least this is a very annoying error, especially if these reports are to be...
  14. plarson3

    Can you incorporate Parameter into Command SQL Query?

    That works. Thank you again. Could be a life saver (assuming it is working the way I had hoped). Is it your understanding that putting the parameter fields in the query itself allow for the filtering at that point instead of after the fact, improving the efficiency of the report?
  15. plarson3

    Can you incorporate Parameter into Command SQL Query?

    Thanks very much for the quick response. Always wondered what that was for. I tried it, and can't seem to get it to work. I can set up this Command Parameter, but the query doesn't seem affected good or bad when I add it, and I am not prompted for the value upon refreshing. When I go...
  16. plarson3

    Can you incorporate Parameter into Command SQL Query?

    We write all our own report SQL queries in order to avoid having the DB schema being appended to the table names. We also use Crystal Parameters quite a bit. Is there any way to incorporate the Parameters into the WHERE portion of the query, in order to improve its efficiency? Otherwise, we...
  17. plarson3

    Java Reporting Component and PDF's

    We are using Java Reporting Component. Current implementation utilizes CrystalReportViewer and allows users to see reports online. However, we need to execute a number of reports programmatically and present the user with links to PDFs. So, in general, we need to implement the following logic...
  18. plarson3

    Keeping DB Schema name out of Report query?

    I have learned that if you write your own SQL query using the Command function under Database Expert, you have complete control over the query, and therefore can leave out or remove the table schema. To me, that is a workaround, and will require me to redo a number of reports. I am still...
  19. plarson3

    Remove Schema Name from Crystal 10

    I actually did already submit a new post, earlier today, with a similar title. If you can help, please do so. Thanks.
  20. plarson3

    Remove Schema Name from Crystal 10

    IanWaterman, GJparker, or PJtek: How did the link to http://support.businessobjects.com/library/kbase/articles/c2014706.asp above help solve his schema issue? I have the same question.

Part and Inventory Search

Back
Top