Solved

crystal reports parameter is showing all records

Posted on 2013-01-30
3
235 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

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

705 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now