Search results for query: *

CR XI on ORA 9i How do I disable drill-down to a sub-report but show the sub-report data only? Thanks, Ivan

CR XI and Oracle 9i. My report has one group and details. gh1 suppressed details gf1 used for summary In my GF1 I clicked Reset page number after and New page after with not onlastrecord. Every page shows Page 1 even if I have more than 1 page for the group. Is anything else need to be done...

CR XI and Oracle 9i. Most of the time when I try to skip so many pages or when I export the report to PDF then I get the message "NOT SUPPORTED" with a blank page. To get back to normal then I must click the design tab first and then Preview tab. Is there a way to fix this message? Thanks, Ivan.

CR XI and Oracle 9i. I created a subreport with headings (same heading as the main report) because they want to see the headings when a break occurs. The problem is when it goes to a new page, I get double heading and the question is: How can I eliminate either the headings from the main report...

Using CR XI SP 3 with Oracle 9i. When I get to print the 10th record I need to retrieve the values used by the 5th row. How do I save it and reuse when I'm in my last row? My report page print all 10 rows from a view, but I need to look back by using formulas and/or creating share number. e.g...

CR XI with Oracle 9i. My main report only uses half of the page and it calls a sub-report. If subreport has 9 rows then it will print after the main report, otherwise it creates a new page(s) to prints all the rows. The user wants to see a continues printing but I cannot control it. Is any way...

Using CR XI sp3 and Oracle 9i. Displaying verbiage in the page footer when calling a sub-report. This subreport will display summaries after all detail has been processed. The sub-report is on the Report Section (RHb). I created a formula, setting a booleanVar to true and I placed it in RHA...

Crystal Reports XI Release 2 - Service Pack 3 Oracle 9i. After creating a report in one machine (this report is QA'd before we move it to Production) and when it runs in Production some differences are shown follow: - Some suppressed lines are not longer suppressed while is run in Production...

Inserting an image (small arrow in 3-D) straight to the report is allowed but when and I use a formula (conditional insert) it doesn't let me copy the image it. e.g. if a=1 then show image else ' '; Any suggestions? Thanks, Ivan

CR XI - Oracle 9i. How do I make a message to show up at the end of the page? I placed a message at the end of the page footer and it shows up about an inch from the edge (end of) the page. I'm displaying different messages depending of the page. Thanks, Ivan.

Using CR XI SP 3 with Oracle 9i. I'm using the Format Eitor to supress printing if the field=0 (Decimals 1, Rounding 1). But, if the field is = 0.02 or 0.001- it will print 0. Is any way there without using a separate formula to suppress them (I have 75 numeric fields)? Thanks, Ivan.

CR XI with Oracle 9i and Microsoft OLE DB for Oracle. I connected to a new instance that has more than 2500 views, since my view name (xcr_..) starts with an X will show up at the end of the list therefore I cannot see it, because the limitation of OLE DB (ADO). Is ther a way to expand the...

Everytime that I open a Report, I get the Crystal Reports XI Release 2 - Service Pack 3 update screen (I already updated to R2 sp2) and when I try to execute it I get an error 404 (an internet communication error). How can I fix it or how can I get rid of the popup (update) screen? Thanks.

I need to change some values for a variable used on the PH (page header) before printing a subreport used on RF (report footer). For my Grand Totals, I want "Whatever" and for the RF "SUMMARY". I used the following "if onlastrecord then "SUMMARY" else "Whatever" and the problem is that it shows...

CR XI under Oracle 9i. I need to suppress a subgroup total when subgroup total is equal to group total. ex. We have Groups that contains only one subgroup and I want to eliminate printing of the subgroup. Thanks, Ivan.

Hi, The idea is not to display if the value = 0. This is what I have tried: 1) If {TOT_VAR4}=0 then " " else "/"&totext({TOT_VAR4},"#####",0) It will display "/- 12" and I need to display "/-12" 2) I created a formula: a: var4= If {TOT_VAR4}=0 then " " else "/" I used a text object where I...

CR XI Oracle 9i. I created a stored procedure for my report, and it runs fine until I decided to add more fields to my Proc. When I run CR as new (logging to Oracle) I don't see my new fields. I logged off from CR and logged on again and the new fields aren't there.... The Proc show as valid...

CR XI with Oracle 9i. I have a report with 2 groups, and by using the Change group option I declare them to use "Keep Group Together" and "Repeat Group Header on each Page". But, when group1 doen't fit in a page will jump to new page leaving 2/3 of the page blank. If I remove the keep the group...

CR XI under Oracle 9i. I created a master-detail (using subreports) report and when I run it through TEST works without problem. Then when I connect it to PROD (using the SET DATASOURCE LOCATION updating it from TEST to PROD) I get about 50 times the amount of rows (repeats the set of 203 rows)...

Using CR XI with Oracle 9i. This is a Master to Detail reporting. I want to print the subreport only if a condition is met. For instance show the subreport if the print_flag='Y' Thanks, Ivan.