I have never used this builder, but used Oracle's Report Builder which is much different. I am trying to figure this out cause my company wants to have this process...

I am retrieving data from several tables and need to generate a report with two different queries. One query results need to be near the top...

This is what I need to do.

The customer wants an EXCEL spreadsheet with predetermine columns and the selected columns by the user populated.

The front end they want is the ability...

Here is a sample of what I currently do with the string. It also shows what the string will look like. I just need some ideas to adjust the code...

Both worked great. Thanks for your help!

I know it is a new data type for SQL Server 2000 (which I am using). I know you can pass it in a function. I have seen code that refers...

Thanks I thought I tried that. I did have to add COALESCE to each column since the columns could be NULL. It worked great.

Thanks again and Happy Easter

Thanks for your help!