Solved

Crystal Reports Query

Posted on 2009-04-10
4
233 Views
Last Modified: 2012-05-06
I have a report I have made with crystal reports. I have hooked it up to MSSQL server. I did that by right clicking in field explorer "Database Fields" and then on "Database Expert" problem is that does not allow me to change the query to what I need. Right now its select all records in the database I need to throw a WHERE clause in there. How can this be done?

This is being loaded by a vb.net program.
0
Comment
Question by:scprogs
  • 2
  • 2
4 Comments
 
LVL 6

Expert Comment

by:RPCIT
Comment Utility
I think what your looking for would be found in Reports / Edit Selection Formula / Record.

Might be different depending on your version.  You use this section to filter your results.
0
 

Author Comment

by:scprogs
Comment Utility
Only thing im finding is this
Crystal Reports -> Report -> Selection Formula -> Record

WHen I go in there I copy the query into a box in there and says thers a error when its the query that it uses currently to get data.

Does this sound like im in the right spot?
0
 
LVL 6

Accepted Solution

by:
RPCIT earned 500 total points
Comment Utility
Sounds like the right place..   What your looking to put in here is not really a full query, but rather the a type of WHERE Clause.  

use the builder to put in something like

{AR.NamedInsured} = 'Named Insured'
0
 

Author Closing Comment

by:scprogs
Comment Utility
Thank you
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

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…
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

743 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

18 Experts available now in Live!

Get 1:1 Help Now