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 IamaSherpa 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. Moongirl

    Month date range for missing data

    I have a table that holds coverage information. An example is effective date 11/1/2002 termed date 3/31/2003 Another table lists payments 1/1/2003 2/1/2003 3/1/2003 I am missing the payments for the following months: 11/1/2003 12/1/2003 These payments are not in the payment table, nor do...
  2. Moongirl

    Sorting on a shared variable

    I have a subreport that passes a variable to the main report. I use this shared variable in my main report in a separate formula. I would like to sort based on the result of that formula, but since it uses a variable I cannot choose it in the sort expert. Does anyone have a work around for this?
  3. Moongirl

    Exporting a report with Multiple Subreports to Excel

    I am trying to export a report to excel that has multiple subreports. These subreports are not linked to the main report. The report looks fine in Crystal and each of the subreports reside in separate sections. When I try to export to excel ( and I have tried multiple ways...) the subreports...
  4. Moongirl

    random record selection

    I have a table with 200,000 records. I want the user to enter a parameter (check date) and generate a random list of items paid on that date for an audit. The user wishes to look at only 65 paid records in the report. I do not have the capability to do this as a stored procedure and am...
  5. Moongirl

    Sub report with Null values

    I have a sub report that is linked to a main report by an ID field. The sub report is located in the main report details section A. The main report has one group based on ID. The sub report has a shared variable which can be null or hold a value. If it is null I would still like the value of...

Part and Inventory Search

Back
Top