2 parameter queries

[Secretgeek]

Good afternoon,

I would've posted these seperately but as they are quite closely connected and on the same project it seemed a bit pointless.

1st question: I have created a very simple report and want to filter the records based on a range parameter. I've created the parameter but it's not showing in the Select Expert when I select the field that I want to use. I've done this several times before and it's always been straightforward. Any pointers as to why the parameter field isn't showing up?

2nd question: I want the user to be able to select the field that another parameter runs on. Can parameters select fields instead of just values within fields?

Any help on either question would be much appreciated.

 

[lbass]

1-If you go to report->selection formula->record, do you see the parameter listed under "report fields"?

2-Please explain more specifically about what you are trying to do.

-LB

 

[Secretgeek]

1-Have sorted that by cut and pasting a select formula from another report into this one.

2-I have 2 date fields on a simple report - 'Acknowledgment' & 'Closed'. I'd like the user to be able to select which field they are basing the date range record select on.

Thanks.

 

[lbass]

Add another parameter (string) with options "Acknowledgement" and "Closed". Then set up your select statement like this:

(
(
{?DateType} = "Acknowledgement" and
{table.acknowledgementdate} = {?DateRange}
) or
(
{?DateType} = "Closed" and
{table.closeddate} = {?DateRange}
)
)

-LB