SSRS The definition of the report report name is invalid. The FilterExpression expression for the dataset dtsMatchUnmatch refers to the field FieldName. Report item
- Details
- Written by Ranjeet
Recently I replaced one column in report dataset query with an expression. I didn’t change anything in report as no change in order and number of datasets columns. When I run the report preview I got below error.
An error occurred during local report processing. The definition of the report '/report name' is invalid. The FilterExpression expression for the dataset 'dtsMatchUnmatch' refers to the field 'DateCreated'. Report item
I just want to add here the mistake I did when added the expression and forget to give expression column alias as of that/previous column name. Once I received error immediately I understood my mistake and given the expression name/alias as of column name. And error got fixed.
SSRS: How to do table header formatting in SSRS
- Details
- Written by Ranjeet
Again, when we are working on reports, formatting is very much important. It presents the data to end user, so it should be properly formatted and should looks good. In this article I will try to demonstrate little bit about basic table header formatting. Obviously, you can much more than what I am writing down here. But I am sure if you at least do as these below, you reports will looks pretty gentle.
- Select column header by clicking on left most of the table border next to column header line. See below
- Format header back ground and font color
- Click on Background color.
- Select Blue and then click OK
SSRS: How to set table level shorting order in SSRS
- Details
- Written by Ranjeet
When working on reports, sorting is always an important features. It simply change the view of the data and give user facility to see with different angles by just clicking on sort option. In this article, I am going to let you know how to check the table level default sort order and how to add default sort column in table report item.
- Right click on top left corner of the table
- Click on Tablix Properties… Below dialog box will appear.
SSRS: How to insert new columns or merge two cells in table report item in SSRS
- Details
- Written by Ranjeet
Let see how you can add/insert new column/cells in table. Also will see how to merge tow column/cells into one columns.
Add new Cell/Columns
- Right click on top of the column header
- Click on insert -> select left or right
- New column will be inserted
Merge two Cells/Columns
SSRS: How to assign datasets field into table columns in SSRS
- Details
- Written by Ranjeet
This article will just let you know how you can link your table column to datasets fields. It’s very easy. There might be two to three way to do. Below are the following way you can link your
- Drag filed from datasets directly to any column of the table on design pan
- Click on the icon on table column, and select one of the datasets fields
SSRS: How to add table report item to report design pan in SSRS
- Details
- Written by Ranjeet
Once you are open report design pan in SSDT and created required items like shared data source and shared data sets. Its time now to add report item into the report design pan. In this article and few next articles I will talk about table report item. In this particular article, I am going to illustrate how to add a table report item in report design pan. You can do the same be following way. Although you can refer my How to create your first report in SSRS which will tell you about complete sequence.
- By right clicking on design pan and select table
- Select table
- Once you select table, it will be get added to your report pan like below
SSRS: What are the basic frequently used SSRS report item table features in SSRS
- Details
- Written by Ranjeet
Table item is one of the report item which we frequently use in report design pan. So, it is always very important to know it thoroughly. What is this item, how and when to use etc. In this article I will list out most frequently used table features.
- Add table item to report design pan
- Assign/drag dataset field into table fields
- Insert new cells in table
- Merge two or more cells in table
- Table level default shorting order
- Column level interactive sort order features
- Adding table filter features
- Renaming Column headers
- Format header row
- Keep row header visible while scrolling the report
Whenever I drag a table into the report design pan, I always make sure that these above features have been added at appropriate place/level when required.
SSRS: Cannot create a connection to data source dsFirstEmbededDataSource. rsErrorOpeningConnection in SSRS
- Details
- Written by Ranjeet
Recently I created few reports in SSRS, which uses embedded datasets. When I deployed it and published for users to view. Users started complaining sending below errors.
An error has occurred during report processing. (rsProcessingAborted) Cannot create a connection to data source 'dsFirstEmbededDataSource'. (rsErrorOpeningConnection) For more information about this error navigate to the report server on the local server machine, or enable remote errors
SSRS: What is TargetServerURL and its syntax in SSRS
- Details
- Written by Ranjeet
This article all about what is TargetServerURL parameter in report project properties window. When you create a report project, all the other Deployment group properties will be auto filled with default value except TargetServerURL. All the parameter in this Deployment group does effect the deployment you do by SSDT tool. TargetServerURL parameter actually let the report project know that when you deploy it by right clicking on report project, it will deploy to that (mentioned) report server.
I believe you must have clear understanding of what report server is and what report manager is. Let me give a brief introduction of both. Report server is SSRS server where we deploy the reports. And by using report manager you can manage those deployed reports. Mange in the terms of view, search, print, subscribes, manage security, manage cache datasets etc.
How to build TargetServerURL parameter value?
You can create it by writing as below:
http://<computername>/reportserver.
SSRS: How to create embedded datasets in SSRS
- Details
- Written by Ranjeet
We have already covered what is a datasets and its different types like shared and embedded. And have also covered how to create a shared datasets. Now its times to know how to create an embedded datasets. I would strongly recommend you to go through “what is datasets and its types” article to know about it.
As we all know a shared datasets resides on report project level where as an embedded datasets resides on individual report level. When we open/create a new report project we gets the list of three folders in right hand side under solution explorer. Here you can see named “shared datasets”. So, the datasets created under this folder is called shared datasets and can be shared with all the reports which is fall under this report project. See below screen shot for your reference.
More Articles...
- SSRS: How to create embedded data source in SSRS
- SSRS: A log on error occurred when attempting to access the file share. The user account or password is not valid in SSRS Report
- SSRS: How to create a duplicate copy of a report in SSRS
- SSRS: How to create your first report in SSRS
- SSRS: How to create shared data set in SSRS