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. benramz

    Linking Great Plains V2010 and Active Directory

    Great Plains 2010 Version 11.00.1307 Does any one know if it is possible to link Active Directory to the logins to Great Plains?
  2. benramz

    Adding Formula data to Cross tab Reports

    Linda, thanks again! Have you considered writing a book that covers what the other books leave out?
  3. benramz

    Adding Formula data to Cross tab Reports

    The total for multiple months would use the total booked orders / (total web leads + total phone leads) I would just average the closing ratios but this would not be representative for longer time frames.
  4. benramz

    Adding Formula data to Cross tab Reports

    Question on Crystal Report XI I have a cross tab report which has dates as columns, Month over month. Summaries are displayed in columns under the date. the rows are Job type broken down by location. the Summary data is sum of web leads, phone leads and booked orders. **I need to add a...
  5. benramz

    Cross tabs reports Expert Question

    Linda, Thank you! This is why you are the GURU! Looks like knowing the order of the formatting makes the difference in this case. Sorry for the delay, was on vacation.
  6. benramz

    Cross tabs reports Expert Question

    Linda, I used the formulas that you sent and modified for the appointment types. The only issue is that I need to reset the value of T1 for each column. Any Ideas? whileprintingrecords; numbervar t1; if (gridrowcolumnvalue("Command.Appointment Type") = "Delivery" or...
  7. benramz

    Cross tabs reports Expert Question

    Yes, the Cross tab report is different. 1 Dynamic Column: AppointmentDate - Uses a date range 2 Rows: Resource - This is value is either "Truck" or "Warehouse" Appointment Type - The value is "Delivery", "Re-Delivery", "Pick Up Empty", "Pick Up Full", "Access", "Dock In", "Dock Out"...
  8. benramz

    Cross tabs reports Expert Question

    Thanks Linda, I knew I could count on a great solution from you. I am using CR XI Will this work for multiple of appointment types? I have three types of appointments that are defined as a Gain and three that are defined as a loss.
  9. benramz

    Cross tabs reports Expert Question

    I have a cross tab report that produces the sum of daily appointments and sum of the units by appointment type. This was straight forward use of the crosstab wizard. The problem is that I need to have a summary calculation on the report that is something like (Units of Appointment type 1) -...
  10. benramz

    Optimizing OLE objects to reduce the size of reports

    I am working with a system that has a canned crystal report that generates payment receipt data for customers. The canned report is 32KB in size with the data generated. In order to brand the report, we have added OLE Images, text boxes and hyperlinks which increased the size to 2717KB. Does...

Part and Inventory Search

Back
Top