Some information in SSRS

Good tutorial:

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

http://www.xrm.sk/blog/2009/05/crm-reporting-tips-and-hints-ii-crmaf-binding-not-working/


To Get only Date value :

if you are getting the Date and Time then this is the method to diffentiate the date.

=FormatDateTime(Fields!scheduledend.Value,DateFormat.ShortDate)
ex: 05/15/2012.

for multiple dataset:

=FormatDateTime(Fields!scheduledend.Value,DateFormat.ShortDate)

=First(Fields!createdon.Value, "withsupplierandstore")

=FormatDateTime(First(Fields!createdon.Value, "withsupplierandstore"),DateFormat.ShortDate)


http://www.dotnetspider.com/resources/42874-SSRS-SQL-Server-Reporting-Services.aspx

use full expressions:
http://technet.microsoft.com/en-us/library/ms157328.aspx

Counting the Rows:

http://www.techonthenet.com/sql/count.php

if we want to give the no.of calls made a person then:


SELECT     createdbyname, COUNT(DISTINCT activityid) AS calls
FROM         FilteredAppointment
GROUP BY createdbyname

here we will get the result with name and count of activities.

Owner	Appointment
Akilan s	2
Damodaram Karnam	3

Another Method:

Give the Select count(*) from (  select * from entity where condition )

ex:

SELECT     COUNT(*)
FROM         (SELECT     createdbyname, createdon, new_name, new_regionofname, new_stockavilability, new_stockavilabilityname, new_stockavilabledate,
                                              new_stockavilabledateutc, owneridname
                       FROM          Filterednew_cooldrink)


with where condition:


SELECT     createdbyname, COUNT(DISTINCT activityid) AS calls
FROM         FilteredAppointment
WHERE     (CONVERT(varchar, createdon, 103) = CONVERT(varchar, GETDATE(), 103))
GROUP BY createdbyname



Formating time : Removing Seconds from the time:

(SELECT CONVERT(VARCHAR, FilteredAppointment.scheduledstart, 101) + ' ' + RIGHT(CONVERT(VARCHAR, FilteredAppointment.scheduledstart, 100), 7) )
                      AS scheduledstart


this is the logic.

where we need to place it.

in query builder. Query looks like.
select new_name, (SELECT CONVERT(VARCHAR, FilteredAppointment.scheduledstart, 101) + ' ' + RIGHT(CONVERT(VARCHAR, FilteredAppointment.scheduledstart, 100), 7) )
                      AS scheduledstart from FilteredAppointment
WHERE     (CONVERT(varchar, createdon, 103) >= CONVERT(varchar, GETDATE() - 5, 103))

then we will get the week data.

Getting Every Record in Different Page:

=Ceiling((RowNumber(Nothing))/1)
check the below link
http://sqlserverrider.wordpress.com/2011/06/20/page-break-at-nth-row-in-ssrs-report/


Giving distinct values in parameter:

For this first we need to create DataSet2 with the distinct condition

SELECT DISTINCT  statuscode, statuscodename from FilteredAccount.
then create a parameter, it will show the distinct values.

Getting the user permission to deploy the report:
http://sanganakauthority.blogspot.in/2012/01/verify-that-sufficient-permissions-have.html

first go to the start and select the Internet Explorer.
Run as Administrator.

give the link like : http://servername/reports
you will see the foldersettings
click on that and add the new role assign.