Search results for query: *

I lot easier than I thought. Thank you!

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

It works - kind of. The problem is that it just suppresses the header on the very last page. Unfortunately my subreport is several pages long and so it has to suppress from the time that the report footer prints. Thanks though!

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 do want the average age per hospital. The only problem is that within the group itself, I cannot factor the same patient in the calculation twice. Patients may show up multiple times for various reasons, like multiple diagnoses. For example: Site 1000 ID: 30303 Name: Jimmy Age: 39 ID...

I do want the average age per hospital. The only problem is that within the group itself, I cannot factor the same patient in the calculation twice. Patients may show up multiple times for various reasons, like multiple diagnoses. For example: Site 1000 ID: 30303 Name: Jimmy Age: 39 ID...

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 know this seems like an extremely odd request but I have an odd situation. What I'm basically doing is grouping by one field and then in the group header throwing in other fields to display along with it. In total I have about 6 fields that are put into the group header and from there I...

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

Thanks! I realize now that I presented my problem opposite of what it should have been. I meant to suppress on page 1 but to appear on the rest of the pages. I knocked off the 'not' and it works the way I need it to. Thanks very much!

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

Unfortunately the double quotes didn't seem to do the trick. I read the kbase article and changed my parameter based upon that and the 'All' works now. I did this by removing 'All' as a default choice and now the user just leaves the range blank. However, upon doing this, if the first range is...

Unfortunately it's still appearing blank when 'All' is selected. It's very odd to me that it's doing this all of sudden whereas before I wasn't having any problems with the 'All' and I don't think I changed anything significant. Thanks very much for looking into it though.

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

It worked perfectly, thank you!

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