?
Solved

tablix without data

Posted on 2013-05-10
5
Medium Priority
?
1,082 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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 13

Assisted Solution

by:Koen Van Wielink
Koen Van Wielink earned 800 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 1200 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

Enroll in October's Free Course of the Month

Do you work with and analyze data? Enroll in October's Course of the Month for 7+ hours of SQL training, allowing you to quickly and efficiently store or retrieve data. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

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

Written by Valentino Vranken. A while ago I wrote an article called Chart Optimization Tips (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Chart-Optimization-Tips.html).  This article explained how …
A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…

650 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