Search results for query: *

I have two drop-down menus (A and B) that I would like to populate from one query. I have already managed to populate the drop-downs based on two separate queries but I'd rather use one and use a loop (I think) and/or an if statement to remove records that don't belong in each drop-down. To...

Does anyone know how to force a user to enter a parameter (specifically a date parameter)? I don't/can't have a default value and I'm not sure how to force a user to enter a date. Thanks, Meredith

I have a report that contains a subreport in the report footer. I don't want the main report's page header to print when the report footer prints (therefore printing the main report page header on top of the subreport). I also do not want the page header of the main report to print on the first...

I'm trying to calculate an age average and weed out duplicates in the formula but I'm not having much luck. I've created a medical report that includes a patient ID (which is unique to that particular patient) and their age. A particular patient may show up a few times on the report and I only...

I was wondering (if possible) the best way to go about suppressing a group header if it is equal to another group header. To clarify, say I have 5 fields in 2 group headers and I don't want the second group header to print if the 5 fields hold the same exact data as the first header. I'm...

I'd like to show a page header only on the first page of my report. I realize that I'm basically making it into a report header but I have a little problem. I have to show selection criteria for a report on the first page the report and I would normally put the selection criteria in a report...

I am using two parameters in the select expert and I can't seem to get them working properly. I'm actually working with three parameters but one is not used in the select expert, it's just used for sorting. The user first selects whether to view a list of codes sorted alphabetically either by...

The report I'm creating uses a range parameter. The user selects a range of descriptions and the descriptions are displayed alphabetially (such as A - G). I'm wondering if there is a way to plop my {?range} parameter on the report (or some other method)in the report head section so that the...