dbaspot
Tags Register FAQ Calendar Search Today's Posts Mark Forums Read

Make title area always aligned with data area in web report - Microsoft SQL Server

This is a discussion on Make title area always aligned with data area in web report - Microsoft SQL Server ; Background Have you ever experienced this case? When designing a web report, the column number of data area is less than that of title area. But after expansion, the column number of data area is much bigger than that of ...


Home > Database Forum > Microsoft SQL Server > Make title area always aligned with data area in web report

Reply

 

LinkBack Thread Tools Display Modes
  #1  
Old 10-02-2009, 08:38 AM
Database Newbie
 
Join Date: Apr 2009
Posts: 12
freezean is on a distinguished road
Default Make title area always aligned with data area in web report

Background
Have you ever experienced this case? When designing a web report, the column number of data area is less than that of title area. But after expansion, the column number of data area is much bigger than that of title area in display. As a result, the web report seems irregular.

Example
Take a cross report with horizontal expansion as an example. The design interface is shown below:


In design, the data area has only 4 columns, while the title area has 5 columns.

After expansion, the preview of the report is shown as below:


You can see that the data area has 7 columns and title “Product” and “Date: 2008.12.17″ are at wrong positions. This brings down the neatness and beauty of the report greatly.

How to make title area always aligned with data area?

We can calculate the column number of data area after horizontal expansion and move the corresponding grids in title area right. Then, which ones to move? How to solve the spare area? Fill up blank cells or extend some cells? All these problems are difficult to be solved.

Solution
As a real Excel-like reporting tool, RAQ Report provides a perfect solution to this problem. Not matter how data area expands, with the combination of stretch rules and cell extension, RAQ report can keep specified cells center, right, or left easily. With this function, the beauty of report is guaranteed.

Easy Operation
1. Find cells that need to be aligned right.

2. Check the “Stretch” property of their left cell as show below:


Graphic Illustration


This post is from freezea's blog. You are welcome to cc it anywhere, and please indicate the source.

If you would like to read more articles about reporting tool, you are also welcome to refer to my blog.
__________________
Welcome to my blog
Reply With Quote
Reply

Tags
cell alignment, data area, report design, title area

Thread Tools
Display Modes


Similar Threads

Thread Thread Starter Forum Replies Last Post
SQL Server 2000 Reporting Servicesd usenet ms-sqlserver 8 03-09-2009 02:29 PM
Deployment to Report Server Database Administrator ms-sqlserver 4 09-05-2008 04:48 PM
Report runs code when print previewing Database Administrator ms-access 11 08-03-2008 04:53 PM
how can I make a report that will run against a list of servers? Database Administrator ms-sqlserver 4 11-09-2007 02:31 PM
Published Report Not Showing Correctly in Report Manager webpage Database Administrator ms-sqlserver 1 10-29-2007 03:49 PM


All times are GMT -4. The time now is 03:44 AM.