Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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