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

How do I link two different datasets by a unique variable?

I'm a beginner in Visual Studio/Reporting Services and I have a dataset that contains claim information and I would like to link to a different dataset that contains diary entries for each claim to create a toggle or drill through report. Each dataset has various fields that need to be visible with the only common or unique field being claim number.
0
Jaclynd
Asked:
Jaclynd
  • 4
  • 2
1 Solution
 
jacek_j1978Commented:
As I believe you are looking for something like this - Master/Detail Using a Selectable Master GridView with a Details DetailView:

http://msdn.microsoft.com/en-us/library/aa581795.aspx

Am I right?
0
 
JaclyndAuthor Commented:
I can't seem to locate GridView in my toolbox. I'm working with SQL Server 2005 - SQL Business Intelligence Development studio.

To give you more detail. My report with the claim information has several different columns for one claim and the diary detail has more than one entry for each claim. Each of the entries has it's own list of columns. I would like the user to be able to view the claim number and claim information then be able to hit a toggle or link that will expose all of the dairy entries attached to the specific claim number. I'm very beginner so step by step instructions would be great.
0
 
JaclyndAuthor Commented:
Can anyone help me?
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
jacek_j1978Commented:
Gridview control you can find in Visual Studio toolbox among data controls. You have to open aspx page in design view (for web projects, or datagridview for winform project)  to enable this control on toolbox. But my question is: do you use visual studio? You write in you first post that you use it, but later you have written that you use only Sql Server 2005?
0
 
JaclyndAuthor Commented:
It is Sql server reporting services; however opens into a visual studio window. I have attached a screen print of the current report that I'm working on. I don't know how to open in an aspx page?
VisualStudio.doc
0
 
JaclyndAuthor Commented:
I've figured out my questions. Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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