Search results for query: *

FYI, in case anyone else experiences this issue, I got rid of the repeating header by changing the setting for the Group variable to "without a footer section." Caryn

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

Many, many thanks Duane. I will change the Default View on my reports to Print Preview -- this is excellent information. Now if I were to really press my luck I would want to know how to change the default report Default View in Access 2010. However, I am certainly satisfied with the helpful...

Thank you very much, Duane. You provided the solution -- look at data only in Print Preview. Do you by chance know how to make the default view for a double-click on a report be print preview? In 2003, upon double-clicking a report I probably went right into Print Preview. However, in 2010...

Thank you for your reply. The main report contains two subreports. In the main report is a Control Source =(SubRpt1_Total + SubRpt2_Total). There are no Events associated with the control - all "On" events on the property sheet for the control are blank. The same is true for the report - all...

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

Perfect; thank you. Caryn.

...Desc) takes over. Using this reporting structure - grouping by Company Name and Category, is it possible to give the user the following choices: * Sort by Sales Amount, in ascending or descending order, or * Sort by Company Name within Company Category, in ascending or descending order...

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

...with the new data. Currently, I run each report individually and manually update each URL with the new instance number. Ideally, I would like to: * Schedule Current Quarter reports to run based on a NewQuarter event, passing the new Month and Year parameters (I will explore either (1)...

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

My question continues with Thombathe's instructions on Color Picker. I have a black and white .bmp image open in Photoshop. I want to change the white to beige (FFFFCC). In the Color Picker window I have the exact color I want to replace white with. How do I replace everything white in my...

lbass, a very delayed thank-you for your reply. i was trying to accomplish this task without doing a crosstab, because the boss prefers the nicer report-style formatting. but your note nudged me to do this as a crosstab, which i believe is the correct, efficient way to display this matrix...

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

Thank you so much Dave -- your solution worked great! There was one piece I left out of the story -- there are actually multiple Employee records, that show up in aggregate on the Emp group footer. Using your solution I easily test by: DistinctCount ({Table.EmployeeID}, {Table.DEPTCODE}) = 1...

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

K, Thank you SO much for you response. The answer to all of my problems was in your advice - to read in data as decimal through the File->Option->Fields->Number setting. Thanks again for the quick, correct diagnosis and solution!! Caryn

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

...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, Show Zero As: 0.0 The problem is...