Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1346
  • Last Modified:

tablix without data

I want a table in the report with no data (just text that I type in)
Is this possible?
0
allelopath
Asked:
allelopath
2 Solutions
 
Harish VargheseProject LeaderCommented:
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
 
Alpesh PatelAssistant ConsultantCommented:
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
 
allelopathAuthor Commented:
>>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
 
Koen Van WielinkBusiness Intelligence SpecialistCommented:
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
 
ValentinoVBI ConsultantCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now