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...
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...
...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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.