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

    Peoplesoft nVision Matrix layout-Value Tables!

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

    Need to Revise Recorded Code for Pivot Macro

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

    Need to Revise Recorded Code for Pivot Macro

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

    Writing Macro To Save Excel File with New dates each time

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

    Writing Macro To Save Excel File with New dates each time

    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 =...
  6. twkyoscr

    Writing Macro To Save Excel File with New dates each time

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

    Crystal-How To Write "In List" Formula

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

    Crystal-How To Write "In List" Formula

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

    Crystal-How To Write "In List" Formula

    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!
  10. twkyoscr

    How To create IF AND OR formula

    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!
  11. twkyoscr

    How do I add Pivot to Nvision layout ??

    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!
  12. twkyoscr

    Nonbreaking hyphens in Word

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

    Mail Merge in Word 97-How do I page break after Certain Field?

    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!
  14. twkyoscr

    Copying Entire Crystal Report to separate drive/server Corrupts File?

    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!
  15. twkyoscr

    Copying Entire Crystal Report to separate drive/server Corrupts File?

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

    Added subreport to Crystal-Can't Index Fields to Join Tables!

    Found my problem so I am all set! Thanks all!
  17. twkyoscr

    Added subreport to Crystal-Can't Index Fields to Join Tables!

    Ok, I tried that but there is no small scroll bar under "Subreport parameter field to use" I can only select from the main report in that drop down( the field from the main report does have ?Pm before the field name). On the far right under the check box for "Select data in...
  18. twkyoscr

    Added subreport to Crystal-Can't Index Fields to Join Tables!

    Bless you I believe that will work for me! I have one more obstacle though. The main report and the sub report have date range prompts (which would be the same date range each time it's run). Now the prompts are coming up numerous times for the report to complete. How do I get the subreport...
  19. twkyoscr

    Added subreport to Crystal-Can't Index Fields to Join Tables!

    I am using the visual linking expert and Crystal will not let me join those two fields. If I don't need to join the fields in the tables, how do I get the data from the subreport to flow into the data from the main report? See my example below if this helps! EMPLID Name of Employee Dependent...
  20. twkyoscr

    Added subreport to Crystal-Can't Index Fields to Join Tables!

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

Part and Inventory Search

Back
Top