How to specify dataset scope in business intelligence studio

Posted on 2012-08-29
Medium Priority
Last Modified: 2012-08-30
I have a report that has multiple datasets and does not have a table or matrix container.  Is there a way to specify scope for an expression so that I can use fields from one of the datasets?
Question by:kpbarem
LVL 10

Accepted Solution

Mez4343 earned 2000 total points
ID: 38348014
Not exactly sure what you mean by 'scope' but here are some thoughts:

I believe inorder to add an expression that would read a field from a dataset you need to have a data region (table, matrix, textbox, etc) defined.

try this:
1) add textbox
2) right-click textbox and add expression
3) Add lookup value for expression picking a dataset
     for example,  =First(Fields!customer_name.Value, "AllCustomersDataSet")

The expression formula needs to be an aggregate function since resultset *could* return more than 1 row. If you need to define a smaller scope to filter the dataset, then you could create another dataset and modify the Query so that it returns the scope needed.

For example, Add dataset = 'SelectedCustomer'
Query= Select customer_name From CustomerTable where customer_name = @Customer

@Customer is a Parameter field that would be set after the user selects a customer. The expression would use SelectedCustomer dataset and First() function would return only return the selected customer.

Author Closing Comment

ID: 38350711
Thank you this was well put.  I'm not entirely sure I understood the functionality before.

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

Question has a verified solution.

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

Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
This code started out as a fix for a customer that had incoming data that was hunderds of numbers and words long that was to fit in one column. The problem was that the customer did not want to split words or numbers when wrapping in the column. …
Screencast - Getting to Know the Pipeline
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…
Suggested Courses
Course of the Month14 days, 5 hours left to enroll

807 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