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...
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...
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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.