Search results for query: *

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

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

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

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

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.

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

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

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.

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.

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

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

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

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

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

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

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

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

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)))

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

Here's a simple way of getting around the Excel limitation save (as for .csv, I believe there's a macro that 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...