Search results for query: *

We are an Oracle shop and we have developed a series of reports using Crystal Report XI. We are now looking to upgrade to the latest release of Crystal Reports which, I believe, is Crystal Reports 2008 (or is it called 12?). My first order of business is finding out whether the old reports are...

Yes, I did try this. But can you please explain WHY this works. Why is it drillable if I am putting a formula in a "suppress" checkbox? Is it drillable by default? I expected that, unless I say "Hide (drill-down ok)", it will be fully expanded and not drillable. So why does your technique work?

LB, OK. This sort of works but is not quite what I want. I am trying to understand how/why this suggestion works and, once I do that, I'm sure I can get to where I need to go. If I use a formula for section suppressing, then the section will either be suppressed or it won't, depending on the...

Thank for getting back to me. Unfortunately, I don't get quite understand what you would have me do. My report has 3 levels: 1) Summary; 2) Currency; 3) Instruments. By default only the summary is displayed. The user can optionally drill-down into Currencies and, from there, optionally...

Using Crystal X1 with Oracle 10. I am modifying a report so that it has sections tagged as "Hide (drill down ok)". When the report is displayed it is collapsed. Is there a way to have the report fully expanded in-place so that it appears as it did before I made the sections drillable? If...

Crystal XI with Oracle 9 I have a group header, grouped by currency, that sums up numbers and displays some indicative data. I need to fetch an exchange rate from an unrelated table (linked by a pseudo-key created via a formula), once per currency, so that I can display the exchange rate for...

That suggestion worked perfectly. Thanks! A web link to a page in the Business Objects knowledgebase with the same suggestion can be found here...

Using Crystal XI and Oracle. I have a container report with two subreports. The container report defines a standard header and footer that will be used across both subreports. My requirement is to have sub header at the top of each page where the subheader is unique to the subreport. In the...

Thanks, everyone, for your help and suggestions. What I ended up doing was creating a new report containing two detail sections, one for each subreport. In one of those sections I reimplemented the logic from the existing report and in the other section I implemented the new report. This...

I am using Crystal Reports XI with Oracle 9. I have an existing report that show "Asset-Level Liqudity". They want this report modified to now show "Vehicle-Level Liquidity" as well. The query for VL is fundamentally different than the query for AL so I believe I need to do this using...

Hmmm. And I found that if I display the parameter using the formula ToText(?Param) it works fine. Arfe you saying that Date parameters honored the setting even without this? Just to be clear, when you add the parameter to the design view it will display using your selected format. Save the...

I didn't set up my own functionality; I use Crystal's File/Options menu to specify how I want to see all dates on the report. If another user brings up the .rpt file in his instance of Crystal, and he has a different default date format specified, all the dates on the report should honor his...

I don't want my user to have to modify the report itself nor do I want to hard-wire a format. I just want the user to specify his preferred formatting option via the menu and all dates should be consistently formatted the same way when the report is executed. This works for all dates BUT date...

Using Crystal Reports XI with Oracle 9. The format in which dates appear (e.g., MM/DD/YY or DD-MON-YYYY) can be configured using "File/Options/Fields" and then specifying the format for 'Date' and 'Date and Time'. This works fine for all fields EXCEPT for parameter fields. If I have a...

Thanks to you both for your replies. I cannot combine the two tables using a UNION query since the two sections will have two different sets of headers. Let me explain what's going on here. We have a process that will produce a set of results in one table and a set of exeception results in...

You wrote: "Yes, sort of, the XML file is treated as a single table, howit was constructed may include multiple tables." So a single XML file describes the equivalent of one database table. The file itself may contain multiple XML tables but, ultimately, the sum of that XML is considered a...

I will be (and have been) using Crystal to create fairly complex reports off of Oracle 9 tables. I have just now been given a new requirement to create reports off of XML data files as well. I am not using Crystal's SDK nor am I using it as a part of any of Microsoft's tools. Therefore, I am...

Using Crystal XI with Oracle 9. Can anyone recommend a good book for working with Crystal? The on-line documents are good when you know what you are looking for. I am looking for a book that explains how to solve problems with Crystal. ...Jake

Thanks, LB. I need to read up on using unlinked subreports since I have never used them. Having said that, can I use this technique to have both reports print on the same page? This assumes, of course, that the number of rows from each table (i.e., from the main report and thhe unlinked...

Using Crystal XI and Oracle 9. I am reasonably comfortable desiging reports using Oracle tables. The plan now for this new requirement is to give me an XML data file to be used as the input to a report. I have done some reading on Crystal and XML data files and I have some questions: 1) Can...