Solved

crystal reports parameter is showing all records

Posted on 2013-01-30
3
239 Views
Last Modified: 2013-02-18
Have a report where I have 3 different parameter fields.
1. Year
2. Period
3. Code

When I run these I get all data from that table. Even when I just use one parameter i still have the same issue.
How I set it up:
Parameter: New
Type Name
Value Filed: I select in the drop down Year
I hit ok.
Then I drag that field to my report.
Save
Run  report and it ask for year, I put in the year and I get every year.
0
Comment
Question by:scottwoltjer
  • 2
3 Comments
 
LVL 7

Accepted Solution

by:
Ross Turner earned 500 total points
ID: 38837349
You need to add your paremeter to selection expert :

1 create new paremeter
2 name your paremeter eg Year
3 select data type e.g number
4 select dynamic or static e.g dynamic
5 select the field you want to map to e.g year
Save

Now with your year paremeter open your selection expert and add

{YourDatabase.Year} = @year


Now you have added your param go back to the field explorer and drag on {YourDatabase.Year}



You can read about it here
http://msdn.microsoft.com/en-us/library/ms227825(v=vs.80).aspx

Or watch a video for the same principle but with dates
Crystal Params Selection
0
 

Author Comment

by:scottwoltjer
ID: 38901968
Where I add in the paremeter is where I am getting lost.
0
 

Author Closing Comment

by:scottwoltjer
ID: 38902816
I was clicking on the wrong selection expret. I was in the selection expert of the detail selection.
This is working. Sorry to take so long.

Thanks
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

792 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question