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!

  • Congratulations bkrike 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: *

  • Users: mpdinosaur
  • Content: Threads
  • Order by date
  1. mpdinosaur

    Subreports ok in preview, don't run correctly in VB6

    Folks; I've got a main report with multiple subreports. The subreports are passed an id as a parameter. When I check the preview (in Crystal) it works fine. When I run it through VB6, the 2nd and 3rd subreports work fine, the 1st and 4th don't find any data. I've verified the parameters my...
  2. mpdinosaur

    This field name is not known.

    Oh, wise ones... When running a Crystal report (8.5) with several unavoidable subreports I'm getting the error "This field name is not known." Unfortunately, there is no other descriptive information in the error. Everything I've seen from a Google search says the problem is with my selection...
  3. mpdinosaur

    Supress 2 subrpt based on total calc'd in 2nd subreport.

    Folks; Is it possible to supress two subreports based on a total calculated in the 2nd subreport? I have to be able to conditionally supress the detail items (subreport 1) and the summary and analysis data (subreport 2) based on net profitability that's not calculated until the end of...
  4. mpdinosaur

    Is there a way to know a value from the NEXT record?

    When a group footer is being printed, is ther a way to "know" a value in the next record that's going to print? I need to increment a value and conditionally turn off a group header based on a value in the next record. Using CR 8.5 and MS-SQL. Thanks in advance. [thumbsup] MikeTheDinosaur
  5. mpdinosaur

    Appending a field to a Select. Possible?

    Folks; Is is possible to append a uniquely-valued field to a data set? What I'd really like to do is add a serialized (1, 2, 3, 4, etc.) or even randomized field as the last field in my result data set using an SQL stored procedure. I'd like my result to be: MachA ProdX 1 MachA ProdY...
  6. mpdinosaur

    Can I force a group break in CR 8.5?

    Folks; I need to be able to force a group break in CR 8.5 if I detect a certain condition in the data. Unfortunately I also need to have the already defined group break in place, too. The condition I need to detect, is: if ten detail lines have printed, I want to perform the group break. If...
  7. mpdinosaur

    Unusual data problem with "special" form in CR 8.5.

    Hi, folks; I've got what I think is an unusual problem with printing a "special" form in CR 8.5. I'm trying to print a route card for vending machine techs that list the products in the machine on the card by underlaying a bmp under my data. Works like a charm except for the fact...
  8. mpdinosaur

    Unusual one-to-many relationship problem.

    Folks; I have what I think is an unusual problem with a one-to-many relationship query. First some background. I have a table containing vending machine info. The other table contains one record for each product for sale in the machine. There may be one product, there may be 100 or any...

Part and Inventory Search

Back
Top