Newbie help with Crystal XI

[ChewDoggie]

Hello,

I'm new to Crystal Reports and I've been given an assignment to modify an existing report (Make "Hours by Labor" report provide detail on a per-shift basis). It seems like a relatively easy request but the unfamiliarity of CR is driving me batty.

I'm examining the Select Expert. In it, a formula states the following:

{TABLE_NAME.LABORLEVELNAME1} = {?CompanyCode} and
{TABLE_NAME.PAYCODEID} = {?PayCodes} and
{TABLE_NAME.WAGEAMOUNT} <> 0 and
{TABLE_NAME.APPLYDATE} >= {?StartDate} and
{TABLE_NAME.APPLYDATE} <= {?EndDate}

A Couple of questions:

1) Where are the "{?FieldName}" values coming from ?
2) How can I modify them, if at all ?
3) When the user clicks on a field in a main report, a detail report displays. How do I modify the query that feeds the detail report ?

TIA !

Chew

Thanks !

Matt


10% of your life is what happens to you. 90% of your life is how you deal with it.

 

[fisheromacse]

1. the '{?NAME}' are parameters and are often required entries by the end user.

2. You can view the existing parameters, and in my experience often it is much easier to create new instead of editing the old.

3. the detail report is likely just hidden, or it is a sub-report embedded into the main report.

i know these are brief answers, but hopefully helpful.

 

[lbass]

You can view and/or change the setup of the parameters by going into the field explorer->parameters.

I think the clicking is a drilldown into either a subreport as was just suggested, or it is a drilldown on a group field into a hidden detail section. The selection criteria are limiting the records that contribute to both detail and group sections, but if you have a subreport, there could be independent criteria added there. You can view the actual formula by going to report->selection formula->record--in the main report and in a subreport(if one exists).

-LB

 

[ChewDoggie]

YES!! These are all helpful. I found out since (speed reading) that I have to hit the refresh button and select "prompt for new parameter values" for the params to work with more recent data. Which was kind of my problem -- the data was out-of-date and I thought that the report was working with static data.

This is all very helpful, thank you all so much !

Chew


10% of your life is what happens to you. 90% of your life is how you deal with it.