Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2008-06-19
6
Medium Priority
?
187 Views
Last Modified: 2013-11-26
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
Comment
Question by:Jaclynd
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
6 Comments
 
LVL 1

Expert Comment

by:jacek_j1978
ID: 21824002
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
 

Author Comment

by:Jaclynd
ID: 21824144
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
 

Author Comment

by:Jaclynd
ID: 21826154
Can anyone help me?
0
 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

 
LVL 1

Expert Comment

by:jacek_j1978
ID: 21837708
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
 

Author Comment

by:Jaclynd
ID: 21845790
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
 

Accepted Solution

by:
Jaclynd earned 0 total points
ID: 21848756
I've figured out my questions. Thanks!
0

Featured Post

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.

Question has a verified solution.

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

More often than not, we developers are confronted with a need: a need to make some kind of magic happen via code. Whether it is for a client, for the boss, or for our own personal projects, the need must be satisfied. Most of the time, the Framework…
Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…

636 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