• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 6504
  • Last Modified:

How to link a report item to a dataset in business intelligence Studio

I had a report that seemed to be working properly, but I added an extra dataset so that I could use the information in the query I wrote to pass into a custom code function I wrote.  However, when I click on the expression to make a change no fields are coming up and I see the message that this report item is not linked to a dataset.  This report has no table its just a blank report made of expressions and fields.  I can't figure out how to link my expression to a dataset. Can someone help me out.

Thanks in advance
0
kpbarem
Asked:
kpbarem
  • 5
  • 4
1 Solution
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
>I can't figure out how to link my expression to a dataset.
Define 'link'.

In any data-bount control you should be able to do a right-click: {control type} Properties, then in the General section, Value combo box, click on the expression ( fx ) button, and when the Expression Editor pops up click on the Datasets category, then an item (dataset), to view all available columns.
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
>I had a report that seemed to be working properly, but I added an extra dataset
It is also possible that this add was not successful.  You'll want to go into the Dataset Properties dialog, in the Parameters section to input correct parameters, then in the Query section hit the Refresh Fields button, then go to the Fields section and eyeball that the expected fields are there.
0
 
kpbaremAuthor Commented:
It looks like the dataset added properly.  I am able to run the query in the Query section.  When I go to the datasets category it gives me an item and the available columns are just First() and Sum() functions of the original data.  When I click on the fields section it says Report Item not linked to a dataset.
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
>and the available columns are just First() and Sum() functions of the original data.
Is this in a tablix, where the tablix can be connected to the dataset, then you can refer to each column individuall?

If not, all you'll see is First() and Sum().
0
 
kpbaremAuthor Commented:
Its not in a tablix or table and I can't really put it in one.
0
 
kpbaremAuthor Commented:
So is there a way to specify a dataset scope without the tablix or table?
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Please explain what exactly you're trying to do here, and the reasons why you don't want a tablix control to do it.
0
 
kpbaremAuthor Commented:
I'm not sure I understood that I could just use First() to select the value since the query only returned one value.  That was a little dumb so i'm sorry for the trouble.  But thank you !!
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Got it.  Yeah the SSRS language is not real intuitive if you're used to VB6 / VB.NET / Access VBA.

Wait 'till you get into scripting in SSIS.  

Thanks for the grade.  Good luck with your project.  -Jim
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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