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 dencom 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: *

  • Users: ITCPhil
  • Content: Threads
  • Order by date
  1. ITCPhil

    Hiding status bar information

    Hi, I know there are a few threads on this but even though they helped me some, I am still running into some difficulty. A bit of background. I am linking a Crystal Report file via a URL. This file has to be live meaning it has to login to a database so my URL contains both the login and...
  2. ITCPhil

    Need help with unmanaged reports

    Hi there, this is on CR10 using either Oracle/Sybase/Remedy ODBC. I have a number of reports that I would like to be unmanaged. I of course mean I just FTP the .rpt file (saved without data) to a website. This is not a report with parameters but some might contain subreports. I do not want...
  3. ITCPhil

    The Table could not be found ???

    Hi, I am having a hard time with a report. I am running it using an Oracle ODBC on CR10. I can run the report without any problem from Crystal Report. I can FTP it to the server where they run and run it from there including refreshing with a login. I can also preview it and refresh from CE...
  4. ITCPhil

    Possible to chart from shared variables only??

    Hi, This is on Crystal 10 using Oracle ODBC. I was asked to get a chart ready for this afternoon showing some 2 numbers on it. The numbers are from different tables that I cannot link properly so I had to get the numbers from subreports. I shared both my numbers and placed them in the main...
  5. ITCPhil

    Accented caracters in a user filled form

    Hi, I am trying to figure out how to get french accents to appear correctly when data is forwarded to an Outlook message. I will explain as best I can. We use a web form when our ticketing system is down where the help desk staff can fill in tickets and then mail it to their mailbox. What...
  6. ITCPhil

    Can you work around TopN needing summarized data?

    Hi, This is on Crystal Report 10 and Oracle data. I've a report showing rankings based on summaries at this time. However, considering that one person might be absent half the month, the summary gives them awful numbers. The client is asking if it is possible to rank based on the averages...
  7. ITCPhil

    Is it possible to rank items??

    Hello, (CR10 - Oracle & Sybase 12) I was requested to do a report which ranks our agents in terms of numbers of some tasks performed. they do not want to see the actual numbers of tasks but just the ranks. I have to rank them based on different sources (Oracle and Sybase) but Crystal does not...
  8. ITCPhil

    Moving my file repositories generates errors

    On CE10 I had to get the repository moved over to E: due to lack of space on a drive. They could not repartition D: due to the setup (VMWare machine) so changing to another drive was my only option. I had them create a new repository for input and output but I don't think that actually matters...
  9. ITCPhil

    Any way to run a .rpt without login on?

    This is for Crystal Report/Enterprise 10 using an Oracle ODBC. Notice that we do not use EPortfolio here, most reports are just viewed online with the odd report that can be run when you click on a url. My question is for someone who is requesting a report that they can run themselves at any...
  10. ITCPhil

    Report functions in CR but fails in CE?

    Hi, Using Crystal Enterprise 10 I am attempting to run a report containing multiple subreports (6) and a shared variable, which is the count of agents so we have a divisor for averages. The report was done in Crystal Report 10 based around 33% on Oracle and 66% on Symposium data. My issue is...
  11. ITCPhil

    Need to calculate business time removing pending time

    Hi, This is on Crystal Report 10 connecting to Oracle. It is something, if even possible that is well beyond my knowledge of crystal. I would like to know if it is something that is doable or if I am wasting my time looking at it. Basically, our incidents are recorded into a database. Now...
  12. ITCPhil

    Shared variable assistance required

    I am working with 2 different databases (identical for sites) using shared variables to pass data from one to the other. This is on Crystal Report 10 connecting to Sybase 12 databases. The problem is not making the shared variables, but rather passing them along to the main report. the main...
  13. ITCPhil

    Any way to UNION 2 tables from different unlinked servers?

    I don't know if this is the place to post this, I am hoping that Crystal 10 has a way to do this but not really expecting anything. Senior management has request a KPI dahsboard report and I have to make it from Crystal as I've no other tool which makes these kinds of dashboard. I can easily...
  14. ITCPhil

    .tmp files filling up the server

    Our Crystal Enterprise 10 server had to be re-imaged and everything restarted from scratch following problems. Following this, there are a bunch of .tmp files appearing from the reportjobserver that are filling up the drive. These did not appear prior to reimaging. Would anyone have any idea...
  15. ITCPhil

    SQL Expression help

    The SQL expression option of Crystal Report 10 is fairly new to me. I know how to use it to locate text, but I am wondering on the possibility of an expression to print information from a line of text. The following 2 lines are from a memo field : 20/03/2006 6:58:44 PM Payant Jonathan Payant...
  16. ITCPhil

    Possible to show group total in sr linked on group member in chart?

    This is using Crystal Report 10 on an Oracle ODBC. A client requested from me a rather large report containing all sorts of data from a few different sources. To get this data I am using subreports linked to the main report on the agents' name. The charts he wants are very simple, most are...
  17. ITCPhil

    Is there a difference between these 2 database expert examples

    Working in CR10 on Oracle. You know when you add tables to a report in the database expert, I'd like to know if there is a difference between these 2 and if it would change the results of a report : - (DB) SRMISPROD (TABLE) SRMIS_REQUEST - (DB) SRMISPROD (TABLE)...
  18. ITCPhil

    "File input repository server is down" CE10, restart does not fix...

    Hi, A little background first. Our CE10 server (VMware) was up and running, but last week something crashed on the box and they had to reboot every VMWare server on the box and after that, we could not longer access CE10 from CR10 to save or open reports. It was giving the cluster...
  19. ITCPhil

    Option to have section grow when field grows (such as larger font)

    Using a Sybase database on CR10 for this one. I know this isn't the most intelligent question but it's been nagging me. Why is it that on some reports, if I increase the font of a field, it will grow the field with it and the section will also enlarge to accomodate it but some reports do not...
  20. ITCPhil

    Can't move database field into text object???

    I'm working on Crystal 10 using an Oracle ODBC. I remember in 8.5 I was able to drop database fields anywhere on my Design and then move them into a text object, but I can't do it anymore. I thought it was only 1 report but tried on another and the same thing happens. If I drag my field...

Part and Inventory Search

Back
Top