Solved

tablix without data

Posted on 2013-05-10
5
848 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 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

After much searching across the internet I have found that you could not set the name of the file you were attaching to dynamic report subscriptons in Microsoft Reporting Services. I did manage to find one article showing you how your could make a s…
Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
This video Micro Tutorial shows how to password-protect PDF files with free software. Many software products can do this, such as Adobe Acrobat (but not Adobe Reader), Nuance PaperPort, and Nuance Power PDF, but they are not free products. This vide…
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…

705 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