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

    Setting params for subreport (based on Oracle stored procedure)

    Hi, I'd like to know if there's a solution for the following problem I'm dealing with since quite some time without success: I have an ordinary report that's retrieving data from a table. I've written an oracle stored procedure / function with two parameters that inserts the values of its...
  2. crystalvictim

    modifying scheduled report's/event's attributes

    Hi, using CE8.5 is it possible to change a scheduled report's attributes? To be more precise, we are in need to replace the unmanaged disk's path specification in a bunch of more than hundred reports. As this attribute seems to be 'hidden' within the CE-database's BLOB-field, we're looking for...
  3. crystalvictim

    running reports based on R/3 data in batch mode (scheduled from CE)

    Hi, just being curious: is there anybody out there who happens to have already succeeded in scheduling reports on Crystal Enterprise that use SAP tables or infosets as datasource and have them running successfully in SAP in batch mode ? Regards
  4. crystalvictim

    creating and viewing a report in multiple languages

    Hi! Just being curious: we`re using CR8.5/CE8.5. Is there any possibility to create multi-language-report? The only solution we know about would be creating a language-parameter, replacing all textfields by formula fields and displaying text dependant from the parameter's value. But this way...
  5. crystalvictim

    sql commands for excel data

    Hi, does anybody happen to have expierence using sql commands in CR10 in combination with accessing data that is stored in an excel sheet? What I'd like to do is to create an sql command that not only selects certain columns from the excel sheet but also does some initial conversion (i.e...
  6. crystalvictim

    cross-tab: multidimensional sorting

    Hi. Does anybody out there happen to know if it is possible (using either CR8.5 or CR10) to sort both rows AND columns of a cross-tab based not on the header but on the row/column-total ? I know it can be done for rows via the top-N-assistant but we'd like to have this also for columns. Here's...
  7. crystalvictim

    csp: using objectviewer.csp/infoobject.cwr

    Hi, using CR/CE8.5, I want to enable users to view a report's last instance(s) by using a custom csp-page. This page has to handle logon functionlity (we're using secWinAD-authentification), InfoStore-queries and to display a table that contains links to the instances. It all works fine as long...
  8. crystalvictim

    CSP problem (displaying instances)

    Hello there, we want to create a csp page which displays the last instance of a report specified by its number/ID (in fact, we have to as there's no other way to accomplish this...). I downloaded the get_instance sample code provided by the knowledgebase and quite quickly succeeded in querying...
  9. crystalvictim

    command-line parameters for crystal offline viewer

    Hello there, does anyone know if and what command-line parameters exist (beneath the name of an rpt-file) for the crystal offline viewer ? We'd like to open a report export and/or print it via command-line from within a batchfile. By the way, we're running CR/CE8.5 on Win2K. Thanks in...
  10. crystalvictim

    Displaying a report's last instance via URL without using csp-pages

    Hello there. using CR/CE8.5 and having several recurringly scheduled reports we'd like to know if it is possible to access (i.e. view - NOT execute) a report's last instance by unsing a hyperlink/URL command. We came across a crystal document called 'URL commands for the Web Component Server'...
  11. crystalvictim

    Reading data only once when using subreports?

    Using Crystal Reports 8.5 we'd like to know if there's any veriyfied answer to the following question: Is it possible to create a report that contains several subreports which show different views of the same data? To be more precise, we want to create a main report with several subreports...
  12. crystalvictim

    sql expressions with ms-sql / odbc

    With Crystal Reports 8.5 we are desperately trying to build an sql expression that will extract a substring from a memo-field for further use within formulas. Unfortunately, this doesn't seem to work except with an oracle native driver. Our problem is that we want to access a ms-sql database (or...
  13. crystalvictim

    Accessing Exchange/Outlook information

    Hi, we're using CR/CE8.5. We'd like to report on our exchange server's public folders. We have installed outlook 2000 on our ce-server and basically the data access works. Our problem is, that we're only able to access folders on which the 'user' who is running the outlook-process has the...
  14. crystalvictim

    Accessing CE's own database

    Hi, we're usinge CR/CE8.5. CE manages report-information in its own (MS-SQL)database. We figured out that the user to access this DB is called 'SA' and we finally succeeded in establishing a connection. Our problem is, that the database-design seems quite cryptical and that not all the...
  15. crystalvictim

    performance tuning for rec.sel. formula

    hi, this might be quite a simple question but unfortunately we haven't been able to figure out detailled information on this topic yet: We'd like to improve the performance of our record selection formulas (especially when accessing SAP tables). There are some basic statements concerning this...
  16. crystalvictim

    Using UFL on Crystal Enterprise Server

    We have created a UFL in vb following the steps described in the kb-document named scr_user_defined_functions.pdf and it works fine locally (i.e. we're able to use it within the crystal reports designer). Now my question is, how to use this ufl on our enterprise server, so that we'll be able to...
  17. crystalvictim

    APOS-AddIns - any experiences ?

    Is anybody out there using APOS-AddIns (like ViewTimeSecurity, Dynamic Parameters, Instance Monitor etc.)on a crystal enterprise server (preferrably 8.5 oder 9) who can tell me some of his experiences? (e.g. installation efforts, problems or benefits). thanks in advance.
  18. crystalvictim

    Connecting to an access-db via ole (jet4.0) using UNC-Paths

    Hello. I have a report (CR85) that is based on an access-db. the connection method is OLE (Microsoft Jet4.0 OLE DB) and I'm using UNC for the pathname. Executing and running the report on my client works, but there's a problem running the same report on the enterprise server (CE85), saying...
  19. crystalvictim

    permission concept

    hi, a (simple?) question concerning the concept for permissions (for report instances): Let's say, we have a report which can be parameterized for different users (e.g. 4). So we schedule the report 4 times with the corresponding parameters. "User 1" and "user 2" shall be...
  20. crystalvictim

    conditional data selection formula

    Hi everybody, we're using crystal reports 8.5 professional (sap edition) and have recently encountered a strange problem. The situation is as follows: we have reports (mostly based on sap tables) which shall usually cover a certain period of time (e.g. lastfullmonth) and are therefore...

Part and Inventory Search

Back
Top