CONVERT is specific to SQL Server, and allows for a greater breadth of flexibility when converting between date and time values, fractional numbers, and monetary signifiers.

CAST is the more ANSI-standard...

It works. I've tested it on SQL Server 2005 🙂

I also worked hard towards it but concluded that it's not possible by design itself. Please let us know if you could succeed.

Thanks

I would love to have that functionality like microstrategy 🙂

Did you try using something like REPLACE(REPLACE(YourField,CHAR(10),''),CHAR(13),'') to modify the field from within the report query?

Does this report behaves differently for same records or differently when different records? Try using TRIM()

We have IBM team handling servers and backups

Check exporting the report to pdf. If you still get an extra column, try setting textbox positions using property window, I mean left=xxx in; top=xxx in.

I Agree. Handling it through a SQL stored Procedure is the best option.

Hi,

What are you trying to achieve?

Do you need only records from Table 2 those exist in Table 1?

Please clarify.

Try

http://www.pinaldave.com/

http://www.w3schools.com/sql/

Hi,

What are trying to do? Use Left / Right / Inner joins as required.

SELECT A,B,C,D,E,F,Name FROM TABLE1 LEFT JOIN TABLE2 ON A=Loc

SELECT A,B,C,D,E,F,Name FROM TABLE1 RIGHT JOIN TABLE2 ON Loc=A

SELECT...

Hi,

You may try:

SELECT convert(varchar(30),Getdate(),121) --2013-08-08 19:01:19.733

Hi,

By design, the parameters will be rendered while the report is processing. This means there is no option to hide a parameter at run-time :crying:.

I would suggest you implementing...

Hi,

You may use cascading parameters also, if your default values should change based on the main parameter values.

Thanks.