Solved

Crystal Reports Query

Posted on 2009-04-10
4
240 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
[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
  • 2
4 Comments
 
LVL 6

Expert Comment

by:RPCIT
ID: 24117923
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
ID: 24118115
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
ID: 24118322
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
ID: 31568999
Thank you
0

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

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

Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…

623 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