Databases Reference
In-Depth Information
18. Click on
OK
and hit
F5
. The report will be processed and after a little while it
will be rendered, as follows:
This completes the hands-on exercise 2.3.
In
Learning SQL Server Reporting Services 2008
,
ISBN
:
9781847196187
, you can find
data sources from, Report Models, MS Access 2003, ODBC DSN, and XML DATA.
Hands-on exercise 2.4 - modifying the report
in Project RSPW2012 using an expression
In the design window of the report, you can make many changes—add/remove
columns, add columns with an expression, and so on. For example, in the
RSPW2012
project, we have shipping information displaying the required and shipped date.
You may like to see how many days it took for the shipment to be made. You can
use an expression and display it in a column of the report:
1.
Go to the design of the report in the
RSPW2012
project.
2.
Right-click on the
Shipped D
ate column and from the drop-down list, choose
Insert Column to the right
(click on the handle to get a drop-down list).
3.
Right-click on the empty column you inserted next to
Shipped Date
and
select
Text-box Properties...
, as follows:
Search WWH ::
Custom Search