I have developed a simple SSRS report using the Precision Design want to share some properties in it.
Below is the image of simple report I have made using the precision design.
As you can see in the above report that I am showing the total amount against each budget purpose type.
To do this just right click the row and than select the parent group as you can see this in the below image.
After that a new window will open where you have to select the column on which we have to apply the group and also we can select to add the footer row below if we want to show the total.
After doing that a new column will be created.you can delete that if you don't want it.This column is basically showing the field on which we have applied the group by.As you can see this in the below image.
I have deleted that Column.After that on the footer row I am calculating the sum of the amount.I have also added one more column on which I have put some text.
As you can see this in the below image.
Now you can see in the above images there is a background colour and borders around the cells you can do this just by right click the cell and than select the table box property as you can see this in the below image.
After that a new window will open where you can select the border node to set the border of the of the cell as you can see this in the below image.
After select the fill node to set the background colour of the cell.As you can see this in the below image.
In the above image you can also see the alignment option to set the alignment of the cell.
You can also set the border and background color of the all the cells in single just by selecting all the cells and than right click and than select the properties.
As you can see this in the below image.
These are some simple tips related to precision desing in SSRS reporting.
I hope you like it.If you have any question related to them than feel free to comment.
Thanks
Muhammad Zahid.
Below is the image of simple report I have made using the precision design.
As you can see in the above report that I am showing the total amount against each budget purpose type.
To do this just right click the row and than select the parent group as you can see this in the below image.
After that a new window will open where you have to select the column on which we have to apply the group and also we can select to add the footer row below if we want to show the total.
After doing that a new column will be created.you can delete that if you don't want it.This column is basically showing the field on which we have applied the group by.As you can see this in the below image.
I have deleted that Column.After that on the footer row I am calculating the sum of the amount.I have also added one more column on which I have put some text.
As you can see this in the below image.
Now you can see in the above images there is a background colour and borders around the cells you can do this just by right click the cell and than select the table box property as you can see this in the below image.
After that a new window will open where you can select the border node to set the border of the of the cell as you can see this in the below image.
After select the fill node to set the background colour of the cell.As you can see this in the below image.
In the above image you can also see the alignment option to set the alignment of the cell.
You can also set the border and background color of the all the cells in single just by selecting all the cells and than right click and than select the properties.
As you can see this in the below image.
These are some simple tips related to precision desing in SSRS reporting.
I hope you like it.If you have any question related to them than feel free to comment.
Thanks
Muhammad Zahid.
No comments:
Post a Comment