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!

  • Congratulations TouchToneTommy 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: *

  • Users: Hueby
  • Content: Threads
  • Order by date
  1. Hueby

    EXCEL: creating summary table referencing multiple worksheet cells

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

    Vista Business - switch between domain and 'this computer' profile

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

    Add 1 Year to DateTime for formula

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

    accessing e-mails outside of work domain

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

    User share permissions on shared folders over workgroup

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

    CRW32.exe crashes when opening report

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

    Change label in Page Header based on which Report Footer?

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

    move data into certain column based on dates

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

    Store record value into stored variable, or hold previous value thru ?

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

    parameter use in select formula

    Hello all, I have a multiple value parameter coming in from a VB.NET app. I want to use it in my select formula for a CR 10 report. For example the parameter (@cat) will be a string and contain something like: "A", "B", "C" Then in the select expert formula in the report I have this...
  11. Hueby

    Multiple String Parameter from .NET to CR10 trouble

    Hi all, i'm going to post this here and in the VB.NET section to see if I can get more help on both sides. Anyway, here is what I have: I have a small vb.net app that runs reports made in crystal reports 10. There is one report that has multiple selections for a parameter in the report. So...
  12. Hueby

    Multiple String Parameter from .NET to CR10 trouble

    Hi all, i'm going to post this here and in the Crystal Reports section to see if I can get more help on both sides. Anyway, here is what I have: I have a small vb.net app that runs reports made in crystal reports 10. There is one report that has multiple selections for a parameter in the...
  13. Hueby

    string from .NET over into parameter for search

    Hello all, I have a basic .Net app that pushes a string (strCat) over into a crystal report 10 parameter {?@cat} . The app has a bunch of checkboxes, once the user checks them and wants to run the report this code runs: Public Sub checkboxes() strCat = "" If CheckBox1.Checked...
  14. Hueby

    STRING into parameter for CR report

    Hello all, I have a basic .Net app that pushes a string (strCat) over into a crystal report parameter {?@cat} . The app has a bunch of checkboxes, once the user checks them and wants to run the report this code runs: Public Sub checkboxes() strCat = "" If CheckBox1.Checked =...
  15. Hueby

    show last four digist of SS #

    Can you use the PICTURE() function, or something else, to only show the last 4 digits of a social security number? Thanks for any help... Picture({Social_Security},"_____9999")
  16. Hueby

    no calculations on supressed footer?

    Using CR 10... I have a formula in a GROUP FOOTER #2 that makes some calculations: whileprintingrecords; numbervar sumC := sumC + {@rated}; Based on criteria the FOOTER #2 will either show or be suppressed. In the Group FOOTER #1 I have this: whileprintingrecords; numbervar sumC; Now, the...
  17. Hueby

    DATE parameter problem in formula with dates from DB

    hello all, using CR 10, I have a DATE parameter (@enddate) where user's enter a date. I then want to use it at the end of this formula: Round((datediff("d",minimum({ET_REQ_HISTORY_HEADER_MC.Requisition_Date},{ET_REQ_HISTORY_DETAIL_MC.Equipment_Code}), {?@enddate}) * .7143),0) Though, it...
  18. Hueby

    inserting "fake data row" when needed for calculations

    Using CR 10, MS SQL DB Group Header #1 - grouping by a JOB number Group Header #2 - grouping by a EQUIPMENT number Details - Will either have 1 row, or 2 rows. 1 row could be an ISSUE on X Date 2 rows could be an ISSUE on X Date, and RETURN on X Date. Group Footer #2 - I am calculating the...
  19. Hueby

    file hyperlink pull from SQL DB path/filename

    hi all, using CR 10 w/ MS SQL DB. I have a report that shows invoice #'s and amounts in the detail section of a CR report. There is a table called DI in the database that holds the path and filename of the scanned image of that invoice (by invoice #). I want to create a file hyperlink on...
  20. Hueby

    use variables w/db fields in formula for select range?

    Hi all, Using CR 10, MS SQL DB: I have a report that adds billings together from different periods for Jobs, and then grouped by State (in which the job was done). I want to be able to select the periods as a selection range. So instead of all 13 periods adding, I want to just do period...

Part and Inventory Search

Back
Top