Sign in

Microsoft.com

Microsoft

Remove From My Forums

Dates

Question
0

Sign in to vote
Dear All

I want to know how to do the following in designing reports in reporting services:

How can I convert field to "Date"?

How can I add two dates?

I add group but I want to make the group title above the column titles.

Thanks in advance.
Wednesday, March 19, 2008 11:43 PM

Answers

0

Sign in to vote
Check out my post regarding dates in reporting services:

http://kamalhitari.blogspot.com/2008/02/working-with-dates-in-reporting.html

Also, if you want to add dates then the normal sql functions should work as normal. check this article for more info:

http://www.developer.com/db/article.php/3513996

To group fields and columns, you need to set in the report wizard when creating the report initially, i'm assuming you are using visual studio 2005 to do this.

Kamal Hitari

http://kamalhitari.blogspot.com
- Marked as answer by DavidJennawayMVP, Moderator Friday, March 27, 2009 4:46 PM
Thursday, March 20, 2008 8:26 PM

All replies

0

Sign in to vote

See this

http://www.stunnware.com/crm2/topic.aspx?id=JS12

http://www.stunnware.com/crm2/topic.aspx?id=JS12

Regards,

Imran

http://microsoftcrm3.blogspot.com

Thursday, March 20, 2008 9:52 AM

Moderator
0

Sign in to vote
Check out my post regarding dates in reporting services:

http://kamalhitari.blogspot.com/2008/02/working-with-dates-in-reporting.html

Also, if you want to add dates then the normal sql functions should work as normal. check this article for more info:

http://www.developer.com/db/article.php/3513996

To group fields and columns, you need to set in the report wizard when creating the report initially, i'm assuming you are using visual studio 2005 to do this.

Kamal Hitari

http://kamalhitari.blogspot.com
- Marked as answer by DavidJennawayMVP, Moderator Friday, March 27, 2009 4:46 PM
Thursday, March 20, 2008 8:26 PM