Year as dynamic parameter

[ssingh20]

Hello,

I have CR10 and CR11 and am using Lotus Notes6 as Database.

I have data which is selected based on just one parameter - Year. Now, what I want is that, the year should come from the values of Year in the Date field of the data.

In that way, every year when the report is run, the current year will also be displayed along with the other old years.

Moreover, this will only display years for which we have data in the database!

Can anyone please suggest how I can set this through a parameter?

I have searched through many threads for this problem but did not find the solutions, so I am starting a new thread. I am sorry if this question has been answered before. If anyone can then please redirect me to the appropriate thread.

Thanks a lot,
ssingh

 

[muffntuf]

build a formula
year({datefield}) or year (currentdate)

Then create parameter based off that formula and pull in the list of values.

IF in CRXI then create a List Of Values and schedule it to run yearly to pick up the new year value.


Leave the default open and that should show the current year value.

Thanks,
muffntuf

 

[ssingh20]

Thank you for your reply.

I already have the formula Year({datefield})

What I still did not understand is this statement:-

"Then create parameter based off that formula and pull in the list of values."

How is that supposed to be done? As far as I know we can only display the table fields. Can we display a formula value as parameter?

Please tell me how that can be done.

Thanks again,
ssingh20

 

[PAULCALLAGHAN]

I understand muffntuf however I have an alternative solution. Check out

http://www.milletsoftware.com

for a product called DataLink Viewer.

It is inexpensive, easy to learn and very applicable to your situation.

Mr. Millet has developed a way for you to create a separate crystal report that acts as a parameter only. This way you can customize to your heart's content.

A front-end parameter selection screen would come up, in your case, with only the years to select from that are currently in your database, everytime! When you make your selection it would then run your original crystal report.

His software supports all versions of crystal reports from 8.5 through to 11.