I want to Print a report from Crystal of various Note Types within a period of time. I create a Query with Note Type = (ask) and Note Date = (ask). When I run the Query I select the Note Type Equals whatever and Note Date Between start date And end date. I am told that before I ever run this Crystal report I must change the Export Criteria to reflect the Note Type and Dates selected in the Query. This seems awfully redundant to me. What is the purpose of (ask)? The Query runs before the Export. Doesn't the Export work on the Subset result of the Query? Thanks, Dan Enright Winthrop U. Rock Hill, SC [i]--- Edited at 10/3/2006 11:23:43 AM by Dan Enright[/i]

This is one of the problems I have with the ASK query. Everytime you want to use it in an export or report, you must repeat the criteria. I find it more trouble than helpful in these cases. Jo Ward Neuhaus Education Center (713) 664-7676 ext. 233 [Email Removed]

Query will group the constituent records together that MEET the query criteria; Export will export out any information on the population created from your query - so yes you have to define what is being exported on the population you created in query. Elaine Tucker Stewardship Coordinator St. Mark's School of Texas www.smtexas.org  [Email Removed] another great forum: http://reusers.server-planet.com

I love using Ask queries in Export. It is much easier than creating bunches of queries for similar exports that just vary on one or 2 criteria. I'm not sure what problem you're having regarding using these exports in Crystal. *** I can spell, I just can't type. Where is spell check? Melissa S. Graves Manager, Development Database & Direct Mail Planned Parenthood of Connecticut [Email Removed] 203-752-2804

The Export does work on the Subset result of the Query, but the subset is records of the Query type. In other words, if you are running a Constituent Query, it will return the Constituents who meet the criteria; a Gift query will return Gift records; etc. It does not pass any information about child objects such as Notes, particularly whether those child objects were included in and met the query criteria. It would be difficult for an object-oriented approach to pass anything other than just the parent object. Even if it were relatively simple, it would take a lot of effort to rewrite the existing code base to accommodate this drastic a change in approach. I know that's a lot of techie talk, but I hope that it explains both what the purpose of the (ask) is and why it must be repeated in the Export. Drew J. Drew Allen Children's Hospital of Philadelphia [Email Removed] Check out the user run RE Forum at http://reusers.server-planet.com/

Thank you Drew for your "techie talk" answer. I don't fully understand your response. Are you saying that all the Query returns is the Constituent ID of those people that have Note Types Equal whatever and Note Date Between start date and end date? Thanks, Dan Enright Winthrop U. Rock Hill, SC

Essentially yes. I believe that it's actually the System ID rather than the Constituent ID. Drew J. Drew Allen Children's Hospital of Philadelphia [Email Removed] Check out the user run RE Forum at http://reusers.server-planet.com/

That's not nice. I should be able to apply Output fields to the Query and pass them to the Export. I'm going to suggest this to BB.

There used to be "load fields from query" but it somehow went by the wayside when RE7 came into being. Elaine Tucker Stewardship Coordinator St. Mark's School of Texas www.smtexas.org  [Email Removed] another great forum: http://reusers.server-planet.com

There used to be "load fields from query" but it somehow went by the wayside when RE7 came into being. Elaine Tucker Stewardship Coordinator St. Mark's School of Texas www.smtexas.org  [Email Removed] another great forum: http://reusers.server-planet.com

There used to be "load fields from query" but it somehow went by the wayside when RE7 came into being. Elaine Tucker Stewardship Coordinator St. Mark's School of Texas www.smtexas.org  [Email Removed] another great forum: http://reusers.server-planet.com

There used to be "load fields from query" but it somehow went by the wayside when RE7 came into being. Elaine Tucker Stewardship Coordinator St. Mark's School of Texas www.smtexas.org  [Email Removed] another great forum: http://reusers.server-planet.com

There used to be "load fields from query" but it somehow went by the wayside when RE7 came into being. Elaine Tucker Stewardship Coordinator St. Mark's School of Texas www.smtexas.org  [Email Removed] another great forum: http://reusers.server-planet.com

I have no problem with the fact that the query output fields don't automatically come into export. I frequently wnat my query to give me things like "who gave this year over $500 (summary total)" but then I want to export the gifts they gave THIS year or proposal information, etc. about them. Which records you want to report on and What you want to export about them are different things. I frequently don't even create query output fields for this reason. Occasionally I will set up a few output fields to check my data but I never expect to use these fields for reporting. If you know (or even think) your query will be used in an export don't put that much time into your query output fields. *** I can spell, I just can't type. Where is spell check? Melissa S. Graves Manager, Development Database & Direct Mail Planned Parenthood of Connecticut [Email Removed] 203-752-2804

It would be nice to still have the OPTION to load output from query. I don't want them loaded automatically, but I frequently put in fields in my query to verify that it is pulling what I am expecting, and would like to not have to redo all of that in Export. This is high on my list of suggestions for Blackbaud. Jo Ward Neuhaus Education Center (713) 664-7676 ext. 233 [Email Removed]