Solved

tablix without data

Posted on 2013-05-10
5
627 Views
Last Modified: 2013-05-13
I want a table in the report with no data (just text that I type in)
Is this possible?
0
Comment
Question by:allelopath
5 Comments
 
LVL 12

Expert Comment

by:Harish Varghese
ID: 39157729
Hello,

Yes, you can create a report without any dataset. You may place controls like textbox, image, etc. without having to create a dataset.

But if you want to use a table in a report, you must add a dataset to the report.
Once you create a dataset, you can add controls like table, list, etc. You can associate them to the dataset if you want, but that is optional.

Thanks,
Harish
0
 
LVL 21

Expert Comment

by:Alpesh Patel
ID: 39157745
To do that You can use Label, If you dont want any data fields in report.


Foramt your labels like table row nothing else.
0
 
LVL 1

Author Comment

by:allelopath
ID: 39158709
>>Foramt your labels like table row nothing else.
I did this. They look good when in the Report dev space, but when deploying, they are not quite right, too high or too low by a couple pixels. This is after aligning them and making them the same size.
0
 
LVL 12

Assisted Solution

by:Koen Van Wielink
Koen Van Wielink earned 200 total points
ID: 39159513
Check if the settings 'can grow" or "can shrink" are turned on. If so, turn them off. I've had a similar issue with a label sticker I made. Turning off "can grow" solved the problem.
0
 
LVL 37

Accepted Solution

by:
ValentinoV earned 300 total points
ID: 39160574
You can actually use a table if that works better for the visualization/alignment part.  All you need to do is trick SSRS a little bit.

To start, create a dummy dataset containing a simple select statement that only returns one row (important!).  Here's an example:

SELECT 1 dummy

Then specify this new dataset in the DataSetName property of the table.  That's all, you can type anything you like inside the table, create additional rows and so on, and its content should now render without any issues.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This code started out as a fix for a customer that had incoming data that was hunderds of numbers and words long that was to fit in one column. The problem was that the customer did not want to split words or numbers when wrapping in the column. …
Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …
As a trusted technology advisor to your customers you are likely getting the daily question of, ‘should I put this in the cloud?’ As customer demands for cloud services increases, companies will see a shift from traditional buying patterns to new…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now