• Microsoft Excel – I need to find rows that match a user entered entries and sum results of column b

    I have a spread sheet that looks like this Project Well Hours Lewis 1 12 Lewis 2 3 Lewis 1 9 I want to find all the rows that match a user inputed name (in this case 'Lewis'), then add the numbers in column c labeled 'hours', if the sum equals 24 then no problem, but if the sum does not equal 24...

    Ksaep0420 pointsBadges:
  • Report Versioning (kinda)

    Ok, what I need to be able to do is the following: MHP/FINANCE/Rpt 1 Rpt 1 needs to be modified, I need to be able to make changes to report one BUT still allow it to be used as is until new version is done AND retain all past instances and recurring schedules, anyone have any ideas??? I know if I...

    Pungigi10 pointsBadges:
  • Crystal Reports 8.5 filed data convertion

    How can you do data conversion on the fly for selected records but in indivitual fields? e.g. string data ="5" new string data = "3" (5-2=3) string data = "10" new string data = "8" (10-2=8)

    Iirdtype10 pointsBadges:
  • Is SATA II disks adequate for running VMs

    I built a Hyper-V server, which has a 6 channel SATA II controller. I will use one disk to run he host OS (Windows 2008 Server Enterprise - Core) and will use the remaining 5 SATA II disks to run VMs on. In addition the system has the capacity to hold 32GB RAM, and has 2 Quad CPU sockets. My...

    BringITon5 pointsBadges:
  • Microsoft SSAS with Cognos Front End

    Is there anyone out there that is working or has worked with a Microsoft back-end (SQL SVR 2005, SSIS, SSAS) and a Cognos front end ? What is your experience with this ?

    Sjors & Sjimmie5 pointsBadges:
  • Changing Default Settings for Crystal 11

    When you click the Refresh report option, can you change the default to "Prompt for new parameter values" rather than "User current parameter values"?

    Ccdavis10 pointsBadges:
  • What permissions are necessary to allow an SSIS script to read an excel file in a SharePoint Library?

    I am developing a datamart to feed Performance Point dashboards/scorecards. To deal with managers who do not have a database source, I will have them submit an excel 2003 file to a SharePoint document library (by email). the excel file will have a consistent format. I am developing an SSIS script...

    Dannl10 pointsBadges:
  • pdf plot dialog box

    I am trying to create pdfs in AutoCad using a script file but a dialog box pops up and stops the script file. How do I suppress this dialog box

    Stk196810 pointsBadges:
  • Trouble copying large files to NAS – very slow, and often fails

    Hi all, I'm not an IT expert sadly, but am nevertheless lumbered with trying to manage our small company's half a dozen PCs networked over wired and wireless LAN. A couple of weeks ago one of them (the newest one, less than two weeks out of warranty!) had a massive hard disk failure and all data...

    Roope5 pointsBadges:
  • Virtual Directory

    How to perform operations in IIS without logging in as administrator user. e.g creating virtual directory, assigning permissions to a virtual directory and so on.

    Sim1135 pointsBadges:
  • AS/400 QADBIFLD error Duplicate Record Key?

    The AS400 job QDBSRVXR2 has system error message Duplicate Record in QADBIFLD. I am aware this is a system cross reference file. (System is doing an automatic reply of C and then tries again) Is this file now corrupt ? Would an IPL help ? Reclaim Storage ? What is causing this error. (System is...

    Rockgirl20 pointsBadges:
  • Crystal Reports OBDC (Oracle)

    I created an OBDC on the client to link into the Oracle server, and using it in Crystal report, I can only see the system tables, but not the database table. Using the same obdc in Access application, I can see and am able to link all the tables. Do anyone know why is that I can't see the database...

    Askme5 pointsBadges:
  • Conditional Parameters – Crystal Reports 9

    Hi, I want to create linked parameters so that the user will be given different parameters based on a previous choice. Can this be done in Crystal 9?? Example - User is given 2 parameters P1 & P2, both are mandatory. Depending on the input for P2, then i want P3 or P4 to be displayed..... Any...

    AnJoMi1810 pointsBadges:
  • Autocad

    What commands do I use to set the aspect ratio, the ratio that makes my circles look like circles on my screen instead of an oval, in autocad??

    Beefy5 pointsBadges:
  • XREF’S

    IN ACAD 2008 ON SOME PROJECTS WHEN A XREF IS BOUND WITH INSERT OR BIND THE XREF WILL DISAPPEAR BUT STILL SHOWS THAT ITS THERE IN THE DIALOG BOX AS IF NOTHING HAPPENED. ANY IDEAS?

    JHOLDER25 pointsBadges:
  • Replication for additional domain controller

    I have one main domain contoller that is A. I had already installed one addtional domain controller that is B , my question is how i can replicate this two domain controller through FSMO rules. kindly tell me your replies step wise. G.Arumugam

    Arumugamgopal160 pointsBadges:
  • Similar Microsoft/SAS/Wireless Issue that has my IT department stumped – HELP!

    For the last few weeks, my computer will not let me open Word, EXCEL, SAS, or any other similar program file when I am connected to my wireless internet. When I start up my computer, with the wireless enabled, it takes close to ten minutes for my icons to appear. If I disable my wireless prior to...

    Lthomp565 pointsBadges:
  • How to enable the BizTalk Base EDI Adapter?

    edi adaptor is always disabled...i want to enable it

    Sejalsona1245 pointsBadges:
  • No records in detail causes the group data not to be shown

    Report is grouped by Loan#, I show loan info in the group header and all the trades for this loan in the detail section. If there where no trades, the report doesn't show the loan at all. I would like to see the group header info and show a msg "no trades" in the detail section when there are no...

    Bunker55525 pointsBadges:
  • I need to up load an excel file to sql server db with vb

    I need to upload a excell file to sql server. I made a Stored procedure with the openrowset but if i run de stored procedure works, but embebed in visual basic or in crystal repor an error appears.Somethig about serverliked or server trusted i don't rememeber. does somebody an idea? thanks in...

    Xs4010 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following