Recent content by twkyoscr

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

Let me explain further and hopefully briefly! I am actually running a Peoplesoft nVision report that runs bi weekly for each pay period. I have a template or layout in Excel that is supposed to run a tabular report based on the query in Peoplesoft. I have created an nVision InstanceHook that...

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

Thank you so much for the example and the explanation. You have saved me a ton of time and trouble!! This works perfectly!

I see what you are saying with this piece ActiveWorkbook.SaveAs FileName:= _ "S:\HRShare\WorkforcePlanning\Suzanne\Riley-Posted Positions by Recruiter\Riley-Posted Positions by Recr" & myDate & ".xls" however I am not sure where to place the statement: myDate =...

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

Never mind, I was missing a quote on a job code listed. THANKS AGAIN!

Thanks for your response, that is just what I'm needing. I entered the following and I am getting an error message if {A_CNT_01_STAFFINGMIX.JOBCODE} in ["001062","001009","001043",...] The error message says that the ] bracket is missing and it places the cursor...

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 found something on this! See below! To hyphenate part of the document, select the text you want, select Tools, Language then Hyphenation, Manual. If Word finds a word to hyphenate, click yes. If you want to insert the hyphen in another part of the word, use the arrow keys to move the...

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!

That's what I was thinking, but I am not sure how to verify that. I just wanted to make sure that copying it didn't change the crystal. If you have any further insight, please share. Thanks for your response!

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