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

    Retrieve only non-blank cells from a lookup

    Randy700, I took your advice and here is the a part of one of the spreadsheets in question. I was able to successfully copy what I have put between the begining and ending of the code back into a spreadsheet and have it make sense. The only issue with this is that you lose the embeded...
  2. scooterny

    Retrieve only non-blank cells from a lookup

    Skip, kwbMitel, Kurupt55, and Randy Thanks so much for getting back to me. I really appreciate the time and effort you put in to assist me with my issue. Let me start off by saying that most of my problems occur, I think, because of the layout of this spreadsheet. The worksheet I am working...
  3. scooterny

    Retrieve only non-blank cells from a lookup

    bluedragon2, I am not sure you are understanding what I am asking, or perhaps I am not making myself clear. I would like to pull this data in automatically, not manually. Right now, the business where I work would use a formula in column C. So in cell C1 you might have =$A1. In cell C2 you...
  4. scooterny

    Retrieve only non-blank cells from a lookup

    Skip, Please don't give up, I could really use the assistance. I would like the non-blank entries in col A to get pulled into Col C, in a row, as in below. Scott Col A Col C ------ ------ Foo Foo giraffe tire giraffe pumpkin rattlesnake posies china tire...
  5. scooterny

    Retrieve only non-blank cells from a lookup

    Skip, Sorry about that. Here is an example of what I would like. Scott
  6. scooterny

    Retrieve only non-blank cells from a lookup

    Skip, Thanks for responding so quickly. I will try to explain what I want more clearly. I imagined some kind of lookup, but upon second thought, that probably is not the best way to go. I only have one column of data, so there really is no way to look anything up. I am including a sample...
  7. scooterny

    Retrieve only non-blank cells from a lookup

    Folks, I have an Excel 2003 question. I have a particular column filled with character information, but not every cell in the column has data in it. I want to retrieve only the non-blank information from this column into another column. So for instance, I am retrieving data from column C and...
  8. scooterny

    Limit parameter choices

    Ian, Were it so easy. I suppose I neglected to mention that the fields are coming from a stored procedure, and for whatever reason, I am not able to change the setting for the Allow Custom Values option from True to False. I am using CR 2008, by the way, so I have Allow Custom Values instead...
  9. scooterny

    Limit parameter choices

    Folks, I am using CR 2008 and I am trying to limit the user to two choices, one is the default, which I have set up, and one other. They are both text values that don't come from the DB. How can I set this up? Thanks. Scott
  10. scooterny

    CR 10 OLAP error

    Folks, I am running CR10, which I just recently reloaded onto a new PC. I was trying to create an OLAP report, but when I opened the Crystal Reports gallery ( in File - New ), the OLAP report creation wizard wasn't there. Further, when I tried to open a copy of another OLAP report I had on my...
  11. scooterny

    Can't change field length in SSIS Flat File Source Editor

    Folks, I am trying to create my first SSIS package. I have identified all of my fields in the External and Output Columns in the Flat File Source Advanced Editor. I am able to change the length of the Output Column but not of the External column. I can change a string field to a length of 10...
  12. scooterny

    SSIS Execute SQL Task SQL Statement Build Query problem

    Folks, Thanks for responding. Sorry I didn't put code tags on my message and I will look into the SSIS users group in the future. For now, I figured it out myself, I just had to click on the elipses ( . . . ) in the SQL Statement Editor and that gave me another editor to layout my query as I...
  13. scooterny

    SSIS Execute SQL Task SQL Statement Build Query problem

    Folks, I am new to SQL Server 2005 and SSIS. I am trying to recreate and amend at DTS Package someone else created in SQL Server 2000. This step is the first step in the package and involves the dropping and creating of a table. This code worked fine in the old DTS Package and it works fine...
  14. scooterny

    Seeing Code Problem

    Folks, I am an experience programmer/data mining/reporting person, who has just been handed the responsibility of handling our Actuate reports ( the old guy just left ). I have written a total of 1 report. :-) I am using Actuate version 8. My problem(s) is/are - I am not able to run the...
  15. scooterny

    question about set location

    Folks, I am using CR10 and in this case an Access DB. Each week I create a new table on Access, the same format as the previous weeks', only different data. I find myself recreating the CR query each week, as I am not able to point to an existing query and use a different table in the same...
  16. scooterny

    filtering question

    Thanks for the response LB. I certainly could add the clause directly in the command, and in many cases will do so. I guess it just seems easier or faster to do it in the tool. I just wanted to find out the ramifications of doing it the way I described above. I have one other quick quetion...
  17. scooterny

    filtering question

    Folks, I am using CR 10 with DB2. I created a query using the add command. In it, I have a where clause. Later on, I realized I had forgotten another filter and added it in the formula workshop - selection formulas - record selection. I understand this may not be the easiest way to do...
  18. scooterny

    Drag & Drop Development

    This may be somewhat off track from this thread, but still applicable. I have been a developer for about 15 years, the last 4 or so I have been doing data mining, reporting, business and data analysis. Lately I have been using Crystal Reports, although I have also used Business Objects...
  19. scooterny

    Conditional subtotaling

    LB, I am using brackets around everything because I copied the query from Access. Yikes. Once I made that change, everything worked like a champ. I guess that brackets must have some other signifigance. I really appreciate your help. Thank you very much!! Scott
  20. scooterny

    Conditional subtotaling

    yes, that is what I am doing. Here is the query: SELECT [CVR to CAP volume recon summary by svc cd v1].[Service Code 1], [CVR to CAP volume recon summary by svc cd v1].[Volume 1] FROM [CVR to CAP volume recon summary by svc cd v1] union all SELECT [CVR to CAP volume recon summary by svc cd...

Part and Inventory Search

Back
Top