Recent content by maggiesda

Many thanks for that tip. We shifted to a C# solution but I anticipate having the same issue with passing dates. I will keep your workaround in mind and start looking on the Business Objects knowledge base for bug reports related to this. If I find any, I'll post them here. Good luck on your...

I'm using CR XI with SQL Server (2000). We are moving from CR 8.5 to XI, which is a huge leap because the API we used with 8.5 has gone away. In 8.5, we were able to pass the date in this format: Date(2006,12,30). But that doesn't work with CR XI. Thanks.

I'm using C# to present a report. I'm using some sample code, which I admittedly understand only slightly. Here's the line where I try to pass the data: parameterFieldDefinition.ApplyCurrentValues(currentParameterValues); I can pass a datetime parameter for an rpt-only parameter...

I'm trying to use the RDC API to integrate CR XI with our C++ application. I need an ODBC connection to SQL Server. I'm thinking that crdb_odbc.dll is the DLL I need in my call to LogOnServer, but I keep getting an exception. Has anyone been here and done this already? (See the code below.)...

I'm not sure this will help but I'll offer it up anyway. We use Perl scripts to interrogate the .rpt files. Here's the code we use to open the 8.5 report: #Open up our OLE Automation Server Win32::OLE->Option(Warn => 3); my $application = Win32::OLE->new('Crystal.CRPE.Application'); #...

I'm afraid I wasn't clear in describing my situation. I'm using a table that contains one record. I want to fetch the contents of that record in the report footer. However, Crystal, via the ODBC connection, appears to be reading the new record, i.e. second record in the table. This is not a...

To improve the performance of our reports, we are starting to calculate some of our totals with SQL rather than use Crystals' variables or Summary functions. So we create a query to sum all the amounts in a field and then have the rpt file fetch the result. This works fine with a DAO...

I almost forgot to mention a slight revision: In the suppression formula, I changed it to "carryover = false"; in other words, if we haven't gotten to the subsequent Report Footers we do not want to display the new carryover Page Header. I also declared the carryover var in the Report...

A million thanks. Because we're using a native connection (dao with ACCESS), I did have to add the evaluation-time "WhilePrintingRecords" to all formulas but the suppression one. It worked like a charm!

I have a header in Report Footer a. This header applies to information displayed in Report Footer sections a through i. I want to repeat the header if these sections flow to the next page. Is there a way to determine if a section is on the top of the page? I figure I could put a copy of the...

I was having the same sort of problem: I was using a for loop to search the array, and I was getting the "A subscript must be between 1 and the size of the array" message on a sporadic basis. I think, of course you can only guess about these formulas because there is no way to step...

We are trying to use Crystal Report 8.5, using a front-end and back-end ACCESS database. The reports use the front-end database, which has a combination of real tables and queries, as well as links to all other tables, residing in the back-end database. My problem is that whenever I have linked...

Has anyone noticed that the 'Index in use' combo box in the Link Options dialog appears to be broken in Crystal Reports Version 8.5? If you set the index and save the choice, you will find the combo box blank when you come back to the dialog. It looks like a bug to me. I'm trying to find a...

Many thanks. Over the weekend (I took Friday off), I read some more from George Peck's The Complete Reference: Seagate Crystal Reports 8 and found that there is a build in function called InRepeatedGroupHeader that deals with this issue. I'll take a close look at your solution also and see...

I have a group header and have set the option to 'Repeat group header on each page'. I also have a formula in this group header which initializes the group variables. Whenever I have a page change in the middle of a group the group variables are dutifully cleared. Now this seems to me a case...