Simple Answer Needed

[lonegator21]

I'm sure this will be an easy one for most of you. It's been years since I've messed with CR or SQL, and I'm now trying to build a report with CR 2008.

I'm pulling various fields from the same database but have to organize the data in unique order. Here's an example of what I need...

If the field acct_no equals 100 then I need to show the corresponding acct_name field...and ONLY that one record that relates to acct_no 100. I know it's simple, but how do I do this?

Thanks for any help or a point in the right direction!

 

[Turkbear]

Hi,
Place the field(s) you need displayed in the detail section and use a record selection formula like:

{acct_no} = 100






To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[lonegator21]

I understand that I can do that for one record, but I have been asked to produce a custom report with multiple records. In other words, the report may display the info for acct_no 100, then acct_no 205, then acct_no 407, etc. Meaning there is no defined sort order.

ACCT NO---ACCT NAME---PERIOD $ TOTAL---YEAR $ TOTAL

100
205
407

I thought I could make a formula field for each field, such as acct_name_100 and create a formula to pull the account name for account #100. I tried a Select-Where formula but that doesn't seem to work with CR 2008.

Is my best option to do multiple subreports???

 

[Turkbear]

What determines what records are needed?
Are you using user entered parameters?







To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[fisheromacse]

will grouping by account number then placing the acct_name field in the group header do what you need?
it would show 1 acct_name for each account number.
i would use ian's suggestion to suppress the acct_name. it will operate on every detail record. if you have a list of the values that you want the acct_name displayed for, you can use them with a minor change to ian's formula.
{acct_no} in [100,205,407,773]

 

[lbass]

Are you using more than one table? If you link them on the account number, then all records appropriate to the account will appear together.

-LB