Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. CCSVermont

    How to print detail from TWO tables, VFP, CR11

    Yes, that worked great. Right after I posted this, I saw another post on subreports. It's working great! Thanks for your quick reply.
  2. CCSVermont

    How to print detail from TWO tables, VFP, CR11

    I need to report detail from TWO tables. One is ticket detail, and the other is tender detail. For each TICKET, there may be multiple TENDERS. I want all the TICKET detail in one section (items, prices), and then all the TENDER detail below that (payment types, amounts). I don't know how to...
  3. CCSVermont

    How to set default value for a Dynamic parameter?

    OK, I figured this one out... by not setting up anything other than the parameter "type", it requests what I want... But is there a way to automatically "plug in" the "current system date" into the default value field at the bottom?
  4. CCSVermont

    How to use a formula field in a parameter

    Thanks LB, I'll look at that.
  5. CCSVermont

    How to set default value for a Dynamic parameter?

    CR XI. VFP ODBC data. I have a report using a parameter called "Date Range" for the Select Expert. I cannot figure out where/how to put in default values for beginning and ending date. I also have others I need to do this for, that are text parameters used for the Select Expert. How can I do...
  6. CCSVermont

    How to use a formula field in a parameter

    I don't quite understand you, or maybe this would require a re-write of my report..?? I don't know quite how to do what you're suggesting yet. My formula "Store Dept" is created from fields in the data, like: "0010", "0020" and "1000" are all "Department 1", then "2001", "2002" are "Department...
  7. CCSVermont

    How to use a formula field in a parameter

    I have a formula field, "Store Dept", a "select" formula, that is used to group a report. I want to use this in a parameter, as a dynamic value. It does not show up in the pick list of values/fields to select from when creating the parameter. Can this be done? If so, how? I simply want the...
  8. CCSVermont

    Case statement with sub-cases?

    I got it to work. I think I had a broken link/relation that was causing one table to produce two records for each detail record. Thanks.
  9. CCSVermont

    Case statement with sub-cases?

    >>As you've mentioned, you don't understand Crystal well, so don't state how to do things, rather explain what you have and what you need. You sort of lost me here... I wasn't stating how to do anything, but attempting to describe what I need or am trying to do in a clearer way, so it would be...
  10. CCSVermont

    Case statement with sub-cases?

    Thanks for the quick reply. I'm attempting to use this in a group, to create sub-total breaks and for sorting. The number that I'm converting is like '0010', '1000', '2000', '2001', but not all '1's belong to 'Department 1', etc. for instance, the item's department may begin with a '0' or '1'...
  11. CCSVermont

    Case statement with sub-cases?

    I'm new to Crystal formulas, and I've got this formula that I've created from reading posts here, that's not working. For every misc1 that's either "3" or "6", I'm getting BOTH values, not JUST the one I want (ie; if loccode is "01", I want a certain department name returned, if loccode is...

Part and Inventory Search

Back
Top