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!

Register Log in
  • 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. mattyboy2000

    Server has not yet been opened 8.5 Not Admin

    Thanks Dave, I checked that, but all of my Crystal files are in the System32 directory. I think this seems the type of problem. Any other ideas? Thanks Matt
  2. mattyboy2000

    Server has not yet been opened 8.5 Not Admin

    Hello, I am setting up a terminal server to run for the client. When I run the report as an Administrator it works, but when I run it as a regular user I get "Server has not yet been opened". Any ideas? Thanks in advance Matt
  3. mattyboy2000

    CR8 ASP not passing Parameters on Web

    QUESTION: What happens if the parameters are set in ASP for a Report, yet the parameter "prompt" still appears? (This is visible after the line of code: CRViewer.ShowReport) Rgds, Wayne.
  4. mattyboy2000

    How to display a Crystal Report object in a web page?

    QUESTION: What happens if the parameters are set in ASP, yet the parameter "prompt" still appears? (This is visible after the line: CRViewer.ShowReport) Rgds, Wayne.
  5. mattyboy2000

    ASP CRViewer not setting Params in CR8

    I'm running an .rpt from a website using ASP pages, and the Parameters are no longer getting auto-set! The Web Server has recently been updated. is this a known fault? Please advise. Thanks, Wayne.
  6. mattyboy2000

    CR8 Installation problems

    I get a similar problem, my Services don't even install! I hope someone can answer these issues. I did a FULL install of CR8 on a Web Server, but the Services did not install. :'(
  7. mattyboy2000

    Crystal 8 Services not installing

    A Web Server is not updating the Services for Crystal 8 after the full install: Page Server Web Component Server Does anyone know of a known fault, or if they can be added manually please? Cheers, Wayne.
  8. mattyboy2000

    Crystal Reports 8 Java Viewer "Cannot connect to server"

    Thanks but we found the problem. It was that the Java viewer with Crystal 8 is incompatible with new Java apps, so we downloaded a patch that worked the business. Ta Matt
  9. mattyboy2000

    Crystal Reports 8 Java Viewer "Cannot connect to server"

    Hello The viewer aplet is displaying, but the applet is unable to locate the report file that is in the same folder as the asp page. Below is the HTML code: <HTML> <HEAD> <title>Crystal Report Viewer</title> <link rel="stylesheet" href="../straightfwd.css" type="text/css"> </HEAD>...
  10. mattyboy2000

    crystal report

    From what I remember (over a year ago now), this happenes if your dataset has changed since the report was created. Try refreshing the DataSource in the report. Ta Matt
  11. mattyboy2000

    Monitoring and debugging large insert statements

    What we have done in our company for things like this is find a field that splits the result set quite well (like MatterStatus/OrderStatus). We then use a cursor to loop through these and then record in a progress table how far we have gotten.
  12. mattyboy2000

    Set all fields to allow null

    Hello, I am creating a script to create a copy of a table then loop thorough an audit table and roll the changes back. The problem I am facing is that some of the fields have been changed to not allow nulls. When I'm looping through the audit table and calling updates I am getting an error...
  13. mattyboy2000

    Inserting info into diffrent tables in diffrent databses

    If you use three level naming when refering to your tables, you can access different databases on the same server: Database1.dbo.Table1 Database2.dbo.Table2 Hope this helps Matt
  14. mattyboy2000

    Linked Server (lossing connection)

    Hi, I am having a strange problem. I am connecting from SQL Server to a Progress database. This works fine 90% of the time. The problem is that the connection between the databases seems to be dropping randomly. What I want to do is try and run a query and if I get an error wait 10 seconds...
  15. mattyboy2000

    Missing Data

    Hello, I'm not a Progress guy, so I apologise if this does not make much sense. I have a query being run from SQL Server 2000. It references a Process database (Solcase 6.12 if that helps). The problem is that the query tends to come back with inconsistent amounts of rows, i.e. 16481, 17297...
  16. mattyboy2000

    Distinct Count Issue

    Is this what you want?: SELECT tl.TypeCode, Count(DISTINCT tl.CaseID) as Cases FROM TBL_THStepsLetter tl GROUP BY tl.TypeCode This will list the Type coded and the number of cases. I think you may have been complicating the matter. Matt
  17. mattyboy2000

    Export Excel

    Hi, I now have another problem. The table that I am using for the base has a inconsistent amount of columns. Therefore if I try to export with more columns that are expected then I get an error. Is there a way that I can export to a Named range telling it just to follow the columns across...
  18. mattyboy2000

    Export Excel

    Hi, Just to let you know if your having this problem, I've fixed this problem. What I did was to export to a hidden Tab and set each cell to reference the 'Value()' from the other page. This also means that the from sheet's format can be changed without problems. Thanks Matt
  19. mattyboy2000

    Export Excel

    Hello everyone, I've been trying to export into an excel named range. The problem I am having is that it exports all values as text (with a ' infront of all numbers). Has anyone had this problem before and if so is there a way around it? Thanks Matt
  20. mattyboy2000

    How to print report in Landsacpe ?

    This is an error that comes with Crystal Reports .NET. If you get the latest update from Crystal Decisions then this problem will be rectified Thanks Matt

Part and Inventory Search

Back
Top