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!

Register Log in
  • Congratulations Chriss 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. AcctSolver

    Crystal Syntax vs. Report Smith Syntax

    Thank you hilfy, that did solve most of the issues, but I am not home free yet. I grouped on a concatenated field of check#, check sequence number, and name. The idea of using a maximum as a total worked great for the most part. However, the data set has both positive and negative numbers in...
  2. AcctSolver

    Crystal Syntax vs. Report Smith Syntax

    I am building a report to return payroll data with one line per paycheck. There will be a column for each earnings type. It will be zero of the employee had no earnings of that type, and populated once if he did. The data is structured with one line for every earnings type. CHK#, CHKSEQ#...
  3. AcctSolver

    Creating field to join other tables to

    I have RunNo, Sequence and Weight as below, and need to produce RunNum per the rules above RunNo Sequence Weight RunNum AZ15123 1 42.5 AZ15123A AZ15123 2 41.7 AZ15123B AZ15124 1 82.0 AZ15124 AZ15125 1 81.3 AZ15125 AZ15126 1...
  4. AcctSolver

    Creating field to join other tables to

    I need to join on table to various others, but need to create the field to do so. Table P contains fields: RunNo, sequence, weight. I need to build the field RunNum, and use it for joins. There is always a sequence 1 for each RunNo, but there can be a sequence 2 or 3 as well. If there is a...
  5. AcctSolver

    Join or Formula problem?

    I have two tables, SALES and INVENTORY. In INVENTORY, I have PART_CODE and QUANTITY_ON_HAND. There is a record for each individual item; if I have 25 in stock of an item, I have 25 records. In SALES I have YEAR, PART_CODE and QUANTITY_SOLD. I have a QUANTITY_SOLD for each item I have sold...
  6. AcctSolver

    Display string date time field as only time

    I am working with a model in Microsoft Reporting Services Report Builder 3.0. I need to take a string date field from the model that is formatted mm/dd/yyyy hh:mm:ss and display it as only hh:mm:ss. Please advise as to how that can be accomplished.
  7. AcctSolver

    Help with formula using count as divisor

    ...formula for Amount would I need to create in order to have it work so for every combination of OrderNo and OrderLineNo, if there is only a Sequence 1, then Amount = QTY*UnitPrice. If there is more than a sequence one, the count the number of sequences, then take (1/sequence count)*Qty*Unit...
  8. AcctSolver

    Help with subtotals on maximum of a group

    I have a report that uses data from two tables containing header data, with a linking table containing detail data used solely to create the relationship between the two header tables. Call one CustomerInvoiceHeader, the second CustomerOrderHeader, and the third LinkOrderInvoice. I need one...
  9. AcctSolver

    How do I get a related field to display when taking a maximum of a group?

    Thanks, that is working great.
  10. AcctSolver

    How do I get a related field to display when taking a maximum of a group?

    I am trying to figure out how to get the appropriate data to appear on a report and need help. I have data that looks like this. TransNo ActedOn Date 123221 Mary 9/1/2012 8:15 123221 John 9/1/2012 22:15 123221 Fred 9/1/2012 18:15 123222 Mary 9/1/2012 9:15 123222 Fred 9/1/2012 21:13 I need one...
  11. AcctSolver

    Controlling Display of Data

    Thank you, that worked like a charm!
  12. AcctSolver

    Controlling Display of Data

    I want to display my report header, my page header, some grouped non-dollar statistical data, then another area where I insert additional statistics that come from formulas where I don't have any data in the main column to group by. Next I want to insert headings for $Cost and $Unit. Then I...
  13. AcctSolver

    Excel does not subtotal data exported from Report Builder 3.0

    This may not be the right forum; please feel free to repost to one more appropriate. We have recently begun using Microsoft Report Builder 3.0. When we export reports to Excel and wish to further manipulate data, it is not working out well. We cannot do a data sort/data subtotal as we could...
  14. AcctSolver

    Excel 2010 Macro buttons moving and resizing

    I followed Skip's suggestion in #1 and made sure anything that did not say "don't move" said so. That mostly fixed the problem. When the macros are run, the buttons still move according to my user. But when she reopens the document, they are where they need to be. Works for us.
  15. AcctSolver

    Excel 2010 Macro buttons moving and resizing

    We have had 35 macros in a particular Excel spreadsheet for many years; well prior to Excel 2003. Each macro is on top of one of 35 different data columns. We upgraded to Windows 7 and Excel 2010 a few months back. Now when we press the macro keys, they begin to resize and move. It appears...
  16. AcctSolver

    Table join problem?

    This is what the SQL looks like: "SELECT V_EMPLOYEE.FILE#, V_EMPLOYEE.SOCIALSECURITY#, V_EMPLOYEE.NAME, V_BANKING_INFO.SOCIALSECURITY#, V_EMPLOYEE.COMPANYCODE, V_EMPLOYEE.STATUS FROM REPORTS.V_EMPLOYEE V_EMPLOYEE, REPORTS.V_BANKING_INFO V_BANKING_INFO WHERE...
  17. AcctSolver

    Table join problem?

    I am using Crystal 2008. I have two tables. First table has all employees. Second table has their banking information. I want to obtain the population of all employees with no banking information. I have links on employee#, SSN, etc. What kind of join should these tables/links have? I have...
  18. AcctSolver

    Change short date to yyyymmdd

    I need to change a large number of regularly formatted dates in Excel 2007, like 03/08/1997, into yyyymmdd format 19970308. Doing it with the custom format feature is not sufficient, as the actual data needs to be converted to have content saying 19970308. I did a =year(), =month(), and...
  19. AcctSolver

    Help with defined aging bucket formula

    I am trying to write a projected receipts aging report by week. All weeks are specifically numbered, begin on Sunday, and end on Saturday. My buckets need to be 1 ($ in openAmount field due prior to this week, plus anything due this fiscal week), 2 (due next fiscal week), 3 (due next fiscal...
  20. AcctSolver

    ReportSmith error message cw3215.dll

    I am having a similar problem to the user in thread131-1550453. I recently reinstalled reportsmith on a PC. I installed it from our payroll server, logged on as myself, since rights to our payroll server are limited. The installation went smoothly, and the software works fine FROM MY WINDOWS...

Part and Inventory Search

Back
Top