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

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

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

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

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

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

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

Using Crystal XI with Oracle 9. I have two tables that are logically related in business terms but are not physically related in any way in database terms. My requirement is to select data from both tables and display one set of results at the beginning of the report and the second set of...

Using Crystal Reports XI on Oracle 9. My report has 3 groups and a detail section. G1 is standalone. The data in G2,G3,D,F3,F2 is considered a related section. I want to change the background color of every alternating related section so that the sections are visually offset from each other...

I am a little confused with how to control the default display for date and datetime fields. Under File/Options you can specify the default format to be used. You can also right-click on a specific field instance and directly set its format independant of the overall setting. But how can you...

Is there a way to save a report as a template that can be reused by other reports? I am using Crystal Report XI (with Oracle) and I see that I can create a report based on pre-defined templates but don't see how I can create a template of my own. Thanks! ...Jake

I thought I knew how to do this but clearly I don't. My table looks as follows: DP_DEALID, DP_TYPE, DP_DATE, DP_POSITION I need to select the DP_POSITION for all DP_DEALID and DP_TYPES with the max date <= a specified date. So for a given DP_DEALID and DP_TYPE I will get just one record - the...

Crystal Report XI with Oracle 9. I am summarizing data by date and currency. The user now wants the sum to be cumulative for a currency across dates. In other words, in the currency footer I display the sum for that currency for that date. But when I start the sum for that same currency for...

Using Crystal XI with Oracle 9. I am printing detail records that include three calculated columns: AssetBal, LiabilityBal, and FundingBal. For each row, FundingBal is the difference between AssetBal and LiabilityBal. AssetBal and LiabilityBal are formulas that examine the record and...

I have a report with two groups. I need to summarize one of the detail fields in both footers. The problem is that the requirements specify that under certain conditions, the value in the column being summarized should be blanked out and its value not included in the summarization. If I...

Is there a way to specify a formula to be executed before the report actually does anything? I would like to use this formula to validate the report parameters (e.g., field 2 must not have a value greater than field 1) and to display an error message if the parameters are not valid. Thanks...

I have a data entry field with the following mask: 00-LLL-0000. The problem is that the field in optional and they may want to leave it blank. How can I create a data entry mask that satisfies both requirments?

I have a command object with the following query: select FP_FUNDINGID as FundingId, max(FP_DATE) as FundingDate from FG_POSITION where FP_DATE <= TO_DATE('{?As Of Date}', 'DD-MON-YY') group by FP_FUNDINGID having max(FP_DATE) <= TO_DATE('{?As Of Date}', 'DD-MON-YY') As you can see...

We have a requirement that report parameters be validated against each other. For example, given a report that uses two date parameters, I need to validate that the second date is greater than the first date. Is there a way to implement this using formulas? Thanks! ...Jake