Recent content by LucyColey

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

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?

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

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

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

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

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

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."

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

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

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

Doesn't make a difference unfortunately.

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.

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

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