Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Create table without dataset in a rdlc report.

I'm developing a rdlc report in VS2010 and I need to add a table in the report, but this table has fixed text and doesn't need a datasource. But the report is giving an error because the table isn't related to a datasource. So my question is How do I create table in an rdlc that doesn't need a datsource?

Thanks

like image 502
roma8716 Avatar asked Jun 06 '13 18:06

roma8716


People also ask

How do I add a DataSet to an existing Rdlc Report?

To create a dataset for the RDLC report, click Reporting under Visual C# Items. Click Report, and then click Add. The Report Wizard opens. Enter a dataset name in Name field.To choose a data source for the dataset, click New on the right of Data source drop-down combo box.

What is difference between RDL and Rdlc?

RDL refers to Report Definition Language, which a program is created to assist in management of the server end. This program came into being in 2005 when it was created by SQL Server version of the Report Designer. RDLC, on the other hand, refers to Report Definition Language, Client Side.

How do I add tablix to Rdlc?

For the group on which you want the total, right click on your tablix column and select Insert New row -> inside group below. This will add a new row within the group. Then add a expression of sum(column_name) to the respective column.


Video Answer


2 Answers

By definition a table needs an associated DataSet.

If you only have one DataSet in a report it can use that by default, otherwise one will need to be specified.

If you don't want to associate the table with a DataSet, you could use one or more independent textboxes placed together to get the same results.

You can embed these textboxes in a Rectangle to keep them together when rendering the report.

like image 60
Ian Preston Avatar answered Sep 21 '22 00:09

Ian Preston


If you have fixed values you do not need a Table. Rather, try putting parameters.

In any case, I still suggest you build a DataSet to create a DataTable. Programmatically filling your DataTable is flexible and it would still meet your needs.

For example, your DataTable can contain your fixed values and you can simply attach your DataTable to the report's Datasource. I believe this is your easiest solution.

like image 39
Alex Avatar answered Sep 21 '22 00:09

Alex