Search results for query: *

I have an .mdb with a report that displays properly in Access 2003. The records displayed in the detail section contain a numeric field, sorted in ascending order, and is used as a grouping variable. When the value of the grouping variable changes, the heading text changes. Therefore, one...

We just moved from Access 2003 to Access 2010 and find a difference concerning when calculations are performed. I have a report with a blank Page Header, a blank Page Footer. The Detail section contains subreports with numeric fields. Above the subreports is a summary section that displays...

According to thread149-790093 one can give the user a choice of how to sort fields in a report by giving the user a parameter from which to select. A formula is based on the parameter, and then the formula is used for the sort order. Is there a way I can modify the formula below to sort...

I am writing for reading suggestions about how to update Crystal Report Instance numbers on our web page links. Our web page displays reports as links - for example ReportA links to: http://OracleApplicationServerName/ReportFolder/PrtSpecs.jsp?rptid=InstanceNumber Web page created in: Oracle...

Related to rb2005's posting regarding scheduling & prompting for parameters, I would like to schedule a list of reports, passing parameter values. My thought was to create an event called 'New Quarter'. I would run this event manually when I know there is new data in the database for the new...

Hi. Are there any forums anyone can suggest for help with Oracle Portal? Thank you, Caryn

Goal: Report displays annual sales in columns starting with 1990 to the present. Each year a new sales column should be added to the right. Rows are regions. It has been suggested that I do the report on legal-sized paper, to leave room for the next few years to be added to the right. I...

Hi all, In a Company report, I show Employee names within Dept. I subtotal the number of Employees by Dept. However, if there is only one Employee, I just want to display the Employee name without a subtotal for the Dept. I tried the following suppression 'logic' in Section Expert, for the...

When linking to an MS Access table from a Crystal Report, is there a way to keep decimal values when reading in numeric fields? The Access table that my report uses contains numeric fields defined as 'double' with 1 decimal place. When reading the data into Crystal, Crystal rounds and stores...

Has anyone experienced the following, and if so, has a solution been found? I have a formula for a percent field: if Sum ({%Fld1}) = 0 then 0 else (Sum ({%Fld2})/Sum ({%Fld1}) * 100) I display it in a right-justified field custom-formatted as: Decimal 1.0, Rounding 0.1, Leading Zero...

I would like to know how to display the YEAR in a report title for the most recent value of another field, MONTH. My report lists annual sales totals for each December. I want to display the most recent year for the last December in the title. If my table contains data for: Jan 2001 Jun 2001...

Hi all, My boss wants to modernize the look of our reports, as we'll be displaying on the web, while keeping a format that looks clean and conservative when printed. Templates that come with ver. 9 are pretty wild (by our standards). Can anyone recommend a place to look for report style...

Hi all, We are setting up a web page to replace our old paper 'data book', which contained a finite set of reports in each section. Each report must have a numeric report name to refer to (e.g. Section A, Customers contains: Table 1A: Number of Customers by Country Table 1B: Number of...

Hi folks. The number of columns in my crosstab spans across two landscape (lettersize) pages. When the crosstab displays, one report title shows, but the columns extend horizontally across the next page. This isn't the same behavior as when rows extend vertically past one page causing a page...

Hi all. I need to run a report based on Year, whose value changes one time annually. I do not want to prompt for a year or use the system date, but rather, have a CURRENTYEAR field that I can set and use in formulas, selecting records, and display in report headers. I could then display...

Two types of Companies define Part-timers differently. I need to display Total Part-timers for each company in my report using EITHER table columns PT1 or PT2, depending upon the COMPANY TYPE. To do this I wish to create a manual running total, that sums the (PT1 or PT2) fields, by company...

My report displays the number of people in 4 employee types, for 3 years. My question is: How can I display subtotals for TOTAL APPLICANTS and TOTAL EMPLOYEES (below)? My report output and structure follows: GH1... Company Name 2000 2001 2002 GF2... (1)...

I am working in a crosstab. It seems that if a cell line is added then deleted, a ghost of the still line remains. For my Column heading, in Format Editor, I've set the Background to silver. At first I had the Line Style for both Left and Right lines set to Single, but now I want only the...

Hi, I believe there is a bug in the ProperCase function in that it works up until finding an apostrophe in a string. For instance where XVar contains the string "YEAR'S": ProperCase ({XVar}) returns "Year'S" So I went to Crystal Care Technical Support for fix files and...

The vertical line in my report extends too far down the page. The report displays two group headers and detail information. The Group Header 2 is set to 'keep group together' and 'repeat group header on each page'. So, if there is not enough room for an entire group at the end of the page, it...