Parameters and data

[KathrynB]

I have a date range parameter setup and want the data for the report to only pull docuements that are dated within that date range, without having to go into the Selection expert each time.
The report is setup with a group by a specific field (equipmentId)

 

[MCuthill]

KathrynB,

I assume you mean that you presently have the dates hard coded into your selection criteria, somehting like:

{YourDateField} in [Date(YYYY,MM,DD) to Date(YYYY,MM,DD)]

To add a parameter, you can add a parameter field as follows:
Name: Something of your choosing
Prompting Text: Something Meaningful
Value Type: Date (or DateTime)

Options:
Select the Radio Button next to "Range Values"

Then in your selection criteria, change to as follows:

{YourDateField} in {?YourNewParameterField}

This will display an on-screen prompt each time the report is ran without going into the Selection Criteria.

I hope I have understood correctly, please clarify should you be seeking something else.

Hope this helps!

Mike
---------------------------------------------------------------
"To be alive is to revel in the moments, in the sunrise and the sunset, in the sudden and brief episodes of love and adventure,
in the hours of companionship. It is, most of all, to never be paralyzed by your fears of a future that no one can foretell."

 

[KathrynB]

Thanks - that works great.

Now I have to add Year to Date and Life to date fields to this report. This parameter seems to be causing the report to only pull data from the month.

How to I do this? I have tried adding a date range in the field formula but the parameter seems to override this.

Thanks

 

[MCuthill]

KathrynB,

Report selection criteria superceeds anything else - essentially a "bucket" of all the data for the report. If Year to Date and Life-To-Date are not stored as data elements and that must be calculated... I would think your record selection would need to start further back, or create a subreport to handle the YTD and LTD amounts. (Agruably, you could create formulas the other way... to define the smaller date range you are presently using as a parameter. "flip" the roles with the formulas you speak of, but I am not sure how efficient that report would be if you have lots of history to analyze to calculate YTD and LTD).

I beleive more information about the structure / layout / intent of your report would be helpful in assisting with this item. Can you please provide more information about your report.

Thanks!

Mike
---------------------------------------------------------------
"To be alive is to revel in the moments, in the sunrise and the sunset, in the sudden and brief episodes of love and adventure,
in the hours of companionship. It is, most of all, to never be paralyzed by your fears of a future that no one can foretell."