Search results for query: *

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

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

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

Hi folks. I am using CR10 against MS Access. I have 2 tables with Service Code and Volume. Some times the Service Codes are the same, most of the time, they aren't. All of the Service Codes are unique. For example, Service Code 1 Volume Service Code 2 Volume 1001 100...

I am currently using CR10 and I noticed that when I do a join, in this case a join between a DB2 table and a SQL Server table ( but this seems to be the norm ), when you display the SQL, the query looks funny. To be clear, there seems to be 2 seperate queries on top of one another, but they...