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...
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...
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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.