?
Solved

Crystal Report basic and beyond.

Posted on 2014-04-10
4
Medium Priority
?
1,039 Views
Last Modified: 2014-04-11
It's been a little while since I worked with Crystal Reports. Could someone refresh me on the following?...
I have built a report form that is just a structure and doesn't do anything yet. I have everything laid out. The report is called "Order History". There is a firld in the sub header called Item Number. I want to be able to enter an item number into that field and have the report pull the data from the sql server 2008 r2 DB relating to Item number which is in a table called Item.
I am a little rusty and with one or two recollection exercises I should be able to figure the rest out on my own.

I have attached a few .rpt files as well.
Thanks in advance.
Order-History.rpt
Receiving.rpt
Location-History.rpt
0
Comment
Question by:tesla764
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 5

Assisted Solution

by:mebaby333
mebaby333 earned 1200 total points
ID: 39992881
Sounds like you want to do a parameter? Is this what your after? Basically I want the report only to pull up info on the item I choose?
0
 
LVL 101

Assisted Solution

by:mlmcc
mlmcc earned 300 total points
ID: 39992892
I think you need to create a parameter and use it to filter the report based on the comparison .

{ItemNumber} = {?ItemNumberParameter}

See the attached report

mlmcc
Order-History.rpt
0
 

Author Comment

by:tesla764
ID: 39992914
Wow thanks for the quick responses. I have to go now and will address this first thingh tomorrow. Thanks.
0
 
LVL 5

Accepted Solution

by:
mebaby333 earned 1200 total points
ID: 39992938
Create a new parameter field
On the field explorer right click on Parameter Fields
Choose new
Name your parameter and choose its type
under list of values set it to dynamic
choose "New" under data source and select the field from the drop down box
click ok

If you go into the Select Expert
choose "New"
Then choose the item field from your list of fields
choose "is equal to" in the first drop down and then from the drop down choose your parameter ( it will look like this {?parameter} )  
click ok

Refresh the data and it should ask for the parameter
I have not put it on the form directly
0

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

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

Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
Suggested Courses
Course of the Month12 days, 15 hours left to enroll

777 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