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 TouchToneTommy 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: msanders67
  • Content: Threads
  • Order by date
  1. msanders67

    Cross Tab Report Fields - How to access summarized

    I have a cross tab report created and I need to calculate some percentages. When I'm in the formula editor, I do not see the summarized fields available, which is something I need in order to calculate the percentages I want to add. Does anyone know of a way to get to this data? Thanks in...
  2. msanders67

    Pulling Data from a Companion File

    I have a Crystal Report set up in the following manner: Orders File linked to a detail file, a customer master file, and a customer ship-to file. I am pulling data from all of these files in some cases, but there is not always a customer ship-to record on file for every customer, in which...
  3. msanders67

    Shared Variables In Main Report

    I've created a report that pulls in a numeric field and have created a subreport to pull in another. I have shared the variable from the subreport (which is linked to the main report). The value of the shared variable is showing up one record after it should. Example: curr_yr_mtd pyr_mtd...
  4. msanders67

    Accessing Specific Records Conditionally

    I am putting together a report that will pull data from MAS90 files. I need two years worth of GL account informations on the same report. The files I need to use are: GL History&Budget GL Account Master GL Parameters The files are linked from history&budget to account master by account...
  5. msanders67

    TopN Sort with Others

    I have a report - MTD Top 20 Customers based on sales figures. I have three groups set up to get a total for some combined like accouts. IE: I have several accounts that are similar who's sales need to be combined for this report. That all works great, but I then apply the TopN sort to get the...
  6. msanders67

    Sorting on a formula

    I have a report wherein I need to sort on something other than a group summary field, group field, or database field. My report retrieves MTD and YTD sales for customers. I have a group that is based on customer_display_name, which is a field in the same db file with the MTD and YTD figures. I...
  7. msanders67

    Subreport Assistance - Need Data in Group Header

    Okay, I've successfully shared variables; however, I can only seem to get the fields populated when I put the formulas to display the shared variables in a footer on the report. I need the fields from the subreport displayed in a group header as well as use them to caluclate a percentage that...
  8. msanders67

    Subreport Data needed in Main Report

    I have a situation where I need to show data from the main report and then bring in formula fields from a subreport that is completely unrelated to the main report. In detail: Main Report includes customer, YTD sales, YTD cogs (all coming from a single database file) Sub Report includes...

Part and Inventory Search

Back
Top