12.09.2012, 13:11 | #1 |
Участник
|
sumitsaxfactor: Building a Simple Report–Precision Design
Источник: http://sumitsaxfactor.wordpress.com/...cision-design/
============== In this post, we will see how we can build a report using precision design. A precision design is like a pre-printed format where the placing of report controls, the design and the spacing matters a lot. A precision design is the standard SSRS report designer following the same principles, rules and requirements as are found in a SQL Server Business Intelligence Studio SSRS designer. We will again use the same example of printing Customer Id, Customer name and Balance but this time instead of creating an Auto Design we will use Precision Design. I will also show how we can use some inbuilt parameters to display some generic information like page number, execution date and time etc. Here we will use the same AOT query created in previous example Build and Deploy Simple Report–Queries: SKL_SampleCustomer Create the Required Dataset
Now that the data is ready, we will go ahead and change the look and feel of the report Formatting the table You can specify the lots of formats using the properties windows like Background color, Font type color etc. You can also use the formatting tool bar above to format the data Go ahead and specify the borders for the table for each row. Then change the background of the Header row. Make the text in the header row as center aligned and make the font as bold Select the table rows one by one and change the font to “Segoe UI” and Font Size to “8pt”. Now your table looks as shown below: Now we will go ahead and a Page Header and Page Footer. In Page Header, we will add Report name, Report Title and Execution Date and Time. In the Page Footer, we will add the Page Numbers in the format (Page of Total Pages) To enable Page Header and Footer, in the Report menu select “Add Page Header” and “Add Page Footer” options Now drag three text boxes from tool box and drop onto the Page Header area. Place two text boxes on the left hand corner and one on the right hand corner as shown below. Drag and drop one text box in the center of the Page footer as shown below. Select the first text box, Open the expression box and in the Category section, select “Built-in Fields. Now double click on “ReportName” field and it should add the report name to value section In the same way select “ExecutionTime” in third text box. For report title, Type in “Customer balances” in the second text box In the footer section, select the 4th text box and type the expression ‘=Globals!PageNumber & ” of ” & Globals!TotalPages’ Apply formatting as required. Now you should see the design as follows Now close the designer, add the report back to AOT (along with the model) and deploy the report from within AOT. Create a new menu item Go to AOT –> Menu Items –> Output, Right click and select “New Menu Item”. Set following properties Now run the report and the report will be seen as shown below: Источник: http://sumitsaxfactor.wordpress.com/...cision-design/
__________________
Расскажите о новых и интересных блогах по Microsoft Dynamics, напишите личное сообщение администратору. |
|
|
|