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 strongm 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. ReportSmithing

    Available vs. Default Parameter - Works in Preview but not from the Report Manager

    I have a weird problem I would like to have resolved. I create reports for our ADP Enterprise V3 application (or PeopleSoft) using an Oracle 9.2 backend database. I created a report that has a parameter that uses two stored procedures. The avaiable selection returns all paygroups that the...
  2. ReportSmithing

    Parameter Listbox showing nothing on control although all under lying values are checked

    I have a report that uses 6 different parameters. Each parameter is based on a query where "(Select All)" is natively checked off with all the values present. When I run the report, my parameters display part of what is checked off...Active,Leave,Term...as much as can fit in the control window...
  3. ReportSmithing

    Excel 2010 VBA to create an index page based on table of contents

    I would like to take values from a single sheet and create an index based off of a table of contents. I have imported a table of contents that lists multiple departments and their page numbers in column A and B... Department Page Finance 1 Finance 2 Finance 3...
  4. ReportSmithing

    EV4 Hosted - Crash when saving to Excel, CSV and Dif

    Can anyone shed any light on this? I have a client that is hosted on EV4 using Citrix and this happens with multiple users using different computers. Report generation runs fine, but when you attempt to save your report in .xls, .csv or .dif formats (doesn't matter how many rows you have)...
  5. ReportSmithing

    Fonts in ReportSmith

    Any reason why ReportSmith displays Wingdings just fine, but other symbol type fonts like Webdings, Wingdings2 and Wingdings3 don't work at all? I've tried these same fonts in Word and they work fine.
  6. ReportSmithing

    Reportsmith 3.11 user security

    Disable all toolbar options to prevent the user from altering the report. 1. Create a macro linked to the event 'Before Report Open' 2. Paste into macro... EnableMenu "File",0 EnableMenu "Edit",0 EnableMenu "View",0 EnableMenu "Insert",0 EnableMenu "Format",0...
  7. ReportSmithing

    ReportSmith and Windows Vista - SmartHeap Library MEM_BAD_POINTER

    Anyone else having a problem with running ReportSmith on a Windows Vista machine? I'm getting the SmartHeap Library MEM_BAD_POINTER multiple times when I run a report. I've noticed that most of my reports have a logo from a Word document (Word 2003) and this seems to conflict with the new...
  8. ReportSmithing

    Importing Object to Form Report Questions.

    I just did a search and there's a lot of converter software out there (pdf to xls). You may need to try several and choose the best since many of these converters don't traslate very well.
  9. ReportSmithing

    Importing Object to Form Report Questions.

    No...but there's alot of third party products (free trials) that will convert .pdf to .doc. DocSmartz 1.5 does this very, very well - other products out there don't do so well.
  10. ReportSmithing

    Calulate a field depending on years of service

    Uncheck the box for Database Grouping and you should be fine.
  11. ReportSmithing

    Derived Field - Year from entered date

    You're close... TO_CHAR(<<DTVAR, "TO_DATE('"yyyy"-"mm"-"dd"', 'YYYY-MM-DD')">> ,'YYYY')
  12. ReportSmithing

    Reports not launching from attachment

    I had this same issue and was able to solve it. Here's what I did.... Go into your Control Panel and select Folder Options. Click on the File Types tab and navigate to RPT and highlight. Click the Advanced button and then click New. Enter the Folling.... Action: Run Application used to...
  13. ReportSmithing

    CASE with multiple criteria

    Yes...you'd write it like this: Case When Location = '0001E' and Jobcode = '900922' Then 'Director' When Location = '0001' and Jobcode = '900922' Then 'Allocator' Else 'NA' End
  14. ReportSmithing

    ReportSmith Enterprise with Web and URLs

    Anyone have any experience with ReportSmith 4.2 Enterprise with Web? Currently our company runs ADP Enterprise Version 3 (Oracle back-end) and we would like to purchase this product since it's web enabled. However, when I look at all the features, I get the feeling that you can ONLY access the...
  15. ReportSmithing

    Graph Function

    Yes, the graph function does work in ReportSmith and requires MS office to work. Unfortunately, the graph will remain stagnant once you add the graph to your report - you can regen your report all day long and the graph will retain the original values of when you first added the graph and will...
  16. ReportSmithing

    Pulling the top 2 rows as well as New Hires on a table...

    There's a big problem with the above statements - EFFSEQ is not factored into your code. For instance, there COULD be two effective dates that are equal, yet the sequence numbers can be changed (0 and 1) in which case the 0 sequence row should reflect your prior row. To deal with the problem...
  17. ReportSmithing

    Need Formula for &quot;1st of month following 30 days&quot;

    This would work in most cases... DATEADD(Day,30,"REPORTS"."V_EMPLOYEE"."HIREDATE") But what about the month with only 28(29) days in it? Or those hired on the first of February - should they be effective for March 1st? Or those months with 31 days? I don't know if you're doing some benefit...
  18. ReportSmithing

    Need Formula for &quot;1st of month following 30 days&quot;

    If you're on Oracle, you would create a derived field: TO_DATE((to_char(add_months(last_day("EMP1"."HIRE_DT" - 1),1)+1)))
  19. ReportSmithing

    Saving reports with &gt; 32K records as .CSV

    As far as I know, there is no record limitation when saving to a .dif format.
  20. ReportSmithing

    Saving reports with &gt; 32K records as .CSV

    ...was posted in previous threads that addresses this). When you run your report and you select "Save As", choose the option "Data Interchange Format Files (*.dif). Once the file is saved, go to the file and right-click on it and select "Open with..." and choose the program Excel - and there...

Part and Inventory Search

Back
Top