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 derfloh 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: LucyColey
  • Order by date
  1. LucyColey

    Exporting to Excel

    I've tried differnt versions of Excel, but have not tried the extended. Would that work?
  2. LucyColey

    Exporting to Excel

    In exporting a report to Excel I get a blank row between each record. The detail section of the report is as small as it can go, so there isn't any blank space between records on the report when you view it in CR. Is there a setting to get rid of those blank sections in Version 8?
  3. LucyColey

    Physical Database Not Found

    I created a report that pulls data from a SQL 7 stored procedure. The report pulls fine on my machine, but when anybody else tries to run it, we get the error "Physical Database Not Found". I can use the connection from that report to create a new report using the same stored...
  4. LucyColey

    Database Connection

    We're trying to pull a report from VB and we're getting an error that says that the physical database is not found. We are using a SQL database and I can run the report locally from my machine directly through Crystal, but it prompts me for the password. If we run the report with the NT...
  5. LucyColey

    Format Settings?

    I have a report that pulls data for the previous three months, so, when I run it this month, it would pull data for May, June and July. It gets more complicated. We have a field called TRANSMONTH. This is a six charachter string that represents the month of the transaction. So, this report...
  6. LucyColey

    Multiple Values In Parameter

    I remember reading something about this a while ago, but can't find it when I need it of course. I have a parameter in V8 that allows multiple values and I would like to display those values selected in the report header. How do I extract that? I place the parameter on the report, but it...
  7. LucyColey

    Allow Multiple Values Parameter

    I have a parameter that Allows Multiple Values. When running in Crystal, I have no problems, but we are creating a web interface and I haven't been able to find ANYTHING that can tell me how these values should be passed into one parameter in the Crystal Report to be used in the Selection...
  8. LucyColey

    Subreport Links

    Guess what I just found on Crystal's sight? "This is a known issue and has been assigned Track ID 51891. This issue has been resolved in Crystal Reports 8.5."
  9. LucyColey

    Subreport Links

    Unfortunately, the subreport parameter is not an option in the list of available linked fields. Any other ideas? The subreorts are not "on demand" reports. A bunch of subreports printing one right after the other is just a creative way for me to display unrelated information on the...
  10. LucyColey

    Subreport Links

    I have a container report that contains eight subreports. Each subreport has an identical parameter. I would like to pass that prompt from the container report so I only have to enter the value once instead of eight times (once for each subreport). The subreports aren't really linked to any...
  11. LucyColey

    Splitting file

    I create reports and the people that run them print them to PDF files for distribution. Many reports are run for the entire company, but have page breaks between each office. Each office is manually printed to it's own file. Somebody told me that they thought they heard there is a now way to...
  12. LucyColey

    Conditional Formatting

    Doesn't make a difference unfortunately.
  13. LucyColey

    Chart

    How do you get it so you can "see through" the chart on top? When I overlay them, I am unable to view the chart on the bottom.
  14. LucyColey

    Conditional Formatting

    Yes, the Trues and Falses are correct, but the highlighting on the Trues is not. The formula I used is: If {InsertRejects9.ForcedError} Like [ '*|33|*' , '*|32|*' ] Then Silver Else Black To give you an example of what I'm getting, there is a record where the...
  15. LucyColey

    Conditional Formatting

    Something funky is going on here. First, to answer your question, the vertical bars are in the string, they separate codes populating a single field (it wasn't the best way the programmers could have set up this table). Second, I tried your recommendation, but instead of using white, I changed...
  16. LucyColey

    Conditional Formatting

    ...I've tried two ways at looking at this. The first is to conditionally format the background of FIELD2. If {InsertRejects9.ForcedError} Like '*|33|*' Then Silver Else If {InsertRejects9.ForcedError} Like '*|32|*' Then Silver Else White When I do this, the ELSE statement works...
  17. LucyColey

    Setting Database Location

    We're trying to set up a process to run our reports through the web and I'm hoping that there is an easy way to get around having multiple copies of the same report. For example, a report may be used by a dozen different clients, which means each would use the same report, but need to be linked...
  18. LucyColey

    Chart

    I want to create a combination bar and line chart. Does Crystal 8 have that capability?
  19. LucyColey

    Run Time Limits?

    I have a report that I'm pulling that is taking forever. It returns records, but after I let it run for a while (about 45 min), it returns the "No Rowset Was Returned For This Table, Query Or Procedure" error. Typically when this happens, there is a problem with the database...
  20. LucyColey

    Location

    Wow, where to begin? I use an OLEDB connection most often, but you could also use an ODBC connection. I'm not sure what you mean by "Where should the report be generated in a SQL - Server?" Crystal requests information from a table located on your SQL Server. You need to know what...

Part and Inventory Search

Back
Top