shravan.gavva (11/20/2013)

---

Hi,

I have two columns in the same table

One is data_value (varchar) and the other is sql_data_type (varchar). Data_value holds info like dates, decimals, etc..

sql_data_type holds info about what type...

Thanks for the kind feedback 🙂

I didn't say that 😉

...but yes, generally I would advocate COALESCE for that use.

It is dynamic on mine, just making sure you drag the page header size until it won't get any smaller works here...

Attached is a standalone sample report that does this...

Not automatically, but linked reports are very cool and will let you achieve your requirement without any additional report development

In this case, I would plump for 2.

Reason 1 : #1 and #3 are the same behind the scenes, but #3 is shorter and more readable, so eliminate #1

Reason 2...

This works I think:

1. Add a page header

2. Add a textbox to the page header, positioned top left and filling the width of the header

3. Populate the textbox expression with...

...and you can't have a single report with a parameter for A,B,C etc?

If Not, you can create the report with the parameter as a hidden parameter with a default of...

It's just that intellisense needs a refresh. Click in the Editor and press Shift-Ctl-R

Sorry, two things that need clarifying

1. Why can't you use a datetime instead of a varchar? SQL 2005 certainly has datetime and smalldatetime?

2. If you must use a varchar, how...

It depends a lot on the data type of the item being displayed, but if it is a date/time field, then just put a capital "T" in the "format" property...

You need to find out what the actual error message is.

It should be output in the window at the bottom of the package designer (Output window) when you run...

rray 44280 (11/19/2013)

---

I appreciate that. If they'd just give me back windows instead of forcing me to use tabs it would help a ton! I understand that that's a VS...

The best delimiter will be the one that doesn't exist in your data.

Only you can find that.

Lowell's suggestion is a good one.

So this:

was not correct?:crazy: