Search results for query: *

Awesome, thanks guys!

So I have data that's in the following structure. ID LINE COMMENT 1234 A Test Line A 1234 B Try Line B 1234 C On Line C I need to combine it like so: ID COMMENT 1234 Test Line A, Try Line B, On Line C I tried a loop, different joins, etc. but the problem is...

I am using the script below to update a DB2 table and it successfully executes. However, the database doesn't update. Can anyone help me? Public Class ScriptMain Inherits UserComponent Dim connMgr As IDTSConnectionManager90 Dim conn As OdbcConnection Dim cmdSelect As...

I need to perform an upsert (insert new records and update existing) into a DB2 database using an ODBC connection. If I were strictly using an OLE database this would be easy because I could keep everything within the dataflow tab. Can anyone offer some assistance or guide me in the direction of...

When I run the DTS package, there is no error but the package hangs while trying to input data into the Pervasive DB. The Pervasive table was completely empty so it should have no problem populating it, but 3hrs later I just cancel the execution because nothing is happening. I am specifying a...

Hi everyone, I am having a very time consuming and frustrating problem. Hopefully someone out there has an answer to this. 1.)Microsoft SQL Server 2000 sp2 2.)Pervasive SQL v8 on seperate machine, running Timberline. I need to create a linked server so that the MSSQL server can run scheduled...

Found the answer here: http://aspadvice.com/blogs/crystal/ Just had to edit the web.config file.

Nevermind, I found the answer here: http://aspadvice.com/blogs/crystal/

I have built a reporting system using .Net which allows the user to choose from a list of Crystal Reports. After the user chooses a specific report from the list, they enter in parameters and press a button to display the report. The data from the report shows up correctly, but the custom...

I have built a reporting system using .Net which allows the user to choose from a list of Crystal Reports. After the user chooses a specific report from the list, they enter in parameters and press a button to display the report. The data from the report shows up correctly, but the custom...

Please keep in mind that I am new to using SQL Server, so this might seem simple to the pro's out there. I am trying to create a DTS package that will allow me to transfer data from a Timberline Database on one server to a SQL Server Database on another server. I have a Timberline ODBC driver...

I tried the drilldowngrouplevel function, but I have only been able to use it to supress or show headers. I am unable to show the group footers, they automatically dissapear. I am using Crystal Reports XI.

I have four group footers in a report with drill down to the lowest group's detail. My problem is that as I drill down, only the previous group footer is shown. For example, the report may only show: GH3 GF2 GF2 GF2 GH3 I need it to show: GH3 GF2 GF2 GF2 GF3 GF4 I'm sure there is a simple fix...

Thanks guys, that really helped out alot!

This probably sounds like a simple question, but I am new to Crystal Reports and could use all the help I can get, Thanks! I have a stored procedure that is importing a table of data in the following format: State City Vendor Month Question# Answer IL Chicago ABC...

There are 11 questions on a survey I have created, and I need to record each question and answer on a seperate record of a MS SQL Server table. This table contains 7 columns, 5 of which will have the same data for each question/answer of each survey taken. I cannot figure out a way to record...