Databases Reference
In-Depth Information
11. Choose the
Prompt for credentials
option, place a check mark for
Use as
Windows credentials
and for prompt text,
Enter your windows credentials
as shown in the following screenshot:
12. Click on
OK
.
13. Right-click on
Datasets
on the left side and click on
Add Dataset...
as shown
on the following screenshot:
Note that the dataset can also be shared among reports.
We choose to do otherwise.
14. Change the dataset name to
DatasetEmbed
, choose the option to use a
dataset embedded with the report, and for the data source choice that gets
enabled choose the one created earlier (
DS_embed
) using the drop-down list.
We use
Query type
to be
text
.
Now we need to choose the table and create a query. The dataset from
the query will be used in the report. There are options to create a dataset.
We will choose to use a query as shown:
SELECT Products.ProductID, Products.ProductName,
Categories.CategoryName, Categories.Description
FROM Products INNER JOIN
Categories ON Products.CategoryID =
Categories.CategoryID
Search WWH ::
Custom Search