Search results for query: *

I hear ya... Thanks for the input on my workbook being a nightmare! lol... It's just a one time proposal, so as soon as I get this summary put together it's over with! I can't seem to get this to work... So I'm playing with INDIRECT statement now... I am in the 'summary worksheet' and have...

I'm looking for the easiest/quickest method to accomplish the below: Column A B C row 1 ='1'!$T$58 ='1'!$B$60 ='1'!$C$30 row 2 ='2'!$T$58 ='2'!$B$60 ='2'!$C$30 row 3 ='3'!$T$58 ='3'!$B$60 ='3'!$C$30 ... row 50 I have...

thanks for the help. that did the trick... what a joke. well, the user brought in his personal laptop that had vista on it already. I've been trying to avoid it all together.

Hey All, We have a domain setup at work, I'm playing with our first Vista machine on the network now. I have it logged into the domain, but when trying to switch users/log off between the domain user profile and the 'this computer' profile it doesn't give me that option. In XP Pro during the...

Okay, well it wasn't before... now I'm using this and it seams to be working. if {HR_EMP_DRUG_DET_MC.Drug_Test_Code} = 'DRUG ' and (dateadd("yyyy", 1, {HR_EMP_DRUG_DET_MC.Employee_Drug_Date}) < currentdate) or (dateadd("yyyy", 1, {HR_EMP_DRUG_DET_MC.Employee_Drug_Date}) in...

Hi all, using CR10: I'm running a formula on a DateTime formatted table. We have Drug Dates entered on the day they took a test. I'm trying to write a report that will let us know when a drug test is expiring within 30 days or if it has already expired. Drug Test's are good for 1 year exactly...

Thanks guys, I appreciate the help. I have now have some solid direction to dig in to.

Hi all, We currently have SBS 2003 with Exchange 2003 setup at our work. At work we have them log into the domain to grab their e-mails, files, etc. For users to access their e-mail remotely we have a terminal server setup that they log in to. I am wondering what are my options to have them...

Thanks for the replies. So after turning off simple files sharing, I will have to look up each user name on the computers and then add them to the "share computer's" user list. What if more than one user name are just DEFAULT USER .... I'm assuming we are going to need unique names on the PC's.

Hi all, I'm use to dealing with SBS Server and AD, but I'm trying to help a group that does not have a Server. Here is there layout: They are networked on a WORKGROUP 15 XP Pro computers - most are single login users 1 XP Pro computer holds ALL the shared folers The user's then access the...

Hi all, Have a user with XP Pro, Crystal Reports 10 Dev. and every time she opens a report it crashes. It gives the CRW32.exe crashed error. To my knowledge no new programs were installed. I un-installed CR 10, reinstalled, with no luck. (It has been working fine for months) Should I try to...

Thank you lbass, that is exactly the solution I was looking for.

Hi all, using CR 10... I have several sub-reports within the report footers of a report. Is it possible to change a label's text in the PAGE HEADER based on which Report Footer is being displayed on the current page? I have 3 different report footers (with sub-reports in them) that have I...

thanks, I have something working now!

Hi all, Crystal Reports 10... MS SQL DB, I have in a detail line these fields: Date1 and Money .... then to the right a couple of date columns. These columns are generated by taking the CURRENT date, then adding a week to 1st column, 2 weeks to the 2nd, and so on. It looks like this: Date1...

Thank you lbass.. that solution is working great

synapsevampire, The calculation in the footer is this: if {ET_REQ_HISTORY_HEADER_MC.Requisition_Mode} = "R" and {#RTotal0} = 2 and ({@curmonth} < {@ParaCurMonthS}) then 0 else if {ET_REQ_HISTORY_HEADER_MC.Requisition_Mode} = "R" and {#RTotal0} = 2 and ({@curmonth} > {@ParaCurMonthS}) then...

Hi all, using CR 10... Details of report: Group #1 Header details line (usually 2 detail lines, either a "I" or "R" req. mode) Group #1 Footer (has some calculations) I have a formula in details (@curmi) that does this: if {ET_REQ_HISTORY_HEADER_MC.Requisition_Mode} = "I" then...

lbass, the parameter will display as actually: "A", "B", "C" - with the quotes. I can remove the quotes if needed, but that is how I have it setup at the moment. I have the parameter in CR set to allow multiple values (under the options)... but really it is just one string with multiple...

MCuthill, I tried to reverse the order, but get an error of "This array must be subscripted. For example array: [i]". Not sure how to proceed with this... ??? Madawc, Thanks for the idea. I'll look into using the SPLIT, never thought of using that.