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 Chris 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. debrichards

    Can't access Dynamics Tables through Crystal Reports

    Previously I had access to my Dyamics tables using Crystal Reports (8.5). Then a while back we had a version update for Dynamics (To 6.00g52). My previous tables were accessed like the example below. Table: Caltc.dbo.SOP30300 Server Type: ODBC-CALTECH Server Name: dynsql Database: master...
  2. debrichards

    "The Summary/Running total Field coulf not be calculated." Error

    I am trying to summarize a Total per Month column for cases sold. The report gave me eaches sold first, which I converted into cases using the formula below. Now when I try to total the cases by month I get the following error message: "The Summary/Running total Field could not be...
  3. debrichards

    Keep last group on page together?

    My report is a summary of all the invoices for a particular sales rep in a one week period. So all the invoices and the detail for each invoice are listed one after another. There may be 1 to 6 invoice summaries per page. If a customer has two invoices in that week they are placed together...
  4. debrichards

    Parameter Values not all selected when setting default values

    Unbelievable... After trying several different things it finally worked. Be nice to know why? What did I do? Debbie
  5. debrichards

    Parameter Values not all selected when setting default values

    I have a parameter fields for a customer name range. When I set the default values only about the first half of our customers names the Parameter Values not all selected when setting default values. I have selected the customer number instead of customer name and the same thing happens. I...
  6. debrichards

    Keep last group on page together?

    I have a report with many "groups" of information (invoice information). I would like the last groups information to stay together and move to the next page if the whole group doesn't fit on the current page. For instance, I have the invoice info, inv. total lines and Customer total...
  7. debrichards

    Table fields not displaying

    I have received this message "More than one data source or stored procedure has been used in this report. Please make sure no SQL Expression is added and no server-side group is performed" About a week ago an MIS person came in and relinked me to my Dynamics tables. This report was...
  8. debrichards

    Table fields not displaying

    Thank you for the prompt reply to my post. I relinked the tables and tried again to include the fields. No change I have linked tables from Great Plain Dynamics verson #6. One table contains information from the Customer card, one from the Salespersons card, Invoice information, and...
  9. debrichards

    Table fields not displaying

    I included a table into an existing report and moved two of the fields from the table onto the report. No information will display. I pulled a field from another table and dropped it into the report. It displayed fine. Could anyone give me some ideas as to what I might be dealing with? I...

Part and Inventory Search

Back
Top