Search results for query: *

We have some custom views that we have created that we would like to use as value table filters in a matrix layout. These custom tables have already been added to the query access manager and are available in a query..but not a matrix nvision. I have already ensured that the effective dates are...

Hi, I have set up a macro that creates a pivot table that needs to be run periodically with new rows of data but same fields each time. The first time the macro worked but now I am getting errors that say "runtime error 1004 reference not valid". How do I revise the code on the macro so that...

I am not too savvy with VB but I am trying to create a macro that will save a file to a new folder. My problem is, each time the file name will be different(because of a new date) and I do not know how to write the macro so that it will copy the most recent file name without replacing a...

Looking for simple way to do the following: @Category = if jobcode = 1063, 1009 1008 etc (about 18 job codes) then "Certified Nursing Tech" I would like to avoid writing separte if then statements and just do if in list then else. Thanks!

Trying to create a formula in Crystal 8.01 that is basically this: if a = 0 and b=c or b = d then "Text" else remaining formula I am abel to do if and statements but I need the if and or. Any thoughts? Thanks!

Have a tabular layout that I need to do a pivot table in excel, and since no data populated, pivot returns error. How do I add totals to layout! Thanks!

I have an excel file to merge to labels with manager name, then ee data. I need a page break after each manager. How do I do that in Word? Thanks!

Help! I have created a crystal report for Peoplesoft 8 in client. Our IS dept copies the entire Crystal report to the server for our end users to run and it seems to work fine. The next day the original crystal report has reverted to a previous version and the edits to the report made the...

I have a crystal report that I have added a subreport(datasource is Peoplesoft)to. I need to join EMPLID from the subreport to EMPLID in main report. Crystal will not let me because the fields are not indexed and the option for indexing the fields is grayed out and won't let me select it. I...

Have a very simple formula(or so I thought), I need to compare two months from different years so I created the following: If {@Month Hired} = 9 then if {@Year Hired} = 2001 then "14- September '01" else "2 - September '00"else "Error" I have tried "if then...