Accessing Dataset values

I have 2 datasets. One is used to give the values to a parameter and the
second one is used to populated the main table in my report.
The first one has a code and a Name like:
Code Name
c cat
d dog
I would like to display â'catâ' in the main table, but I just have the code
â'câ'. Is there a way to do it ?Soan,
I'm not sure I fully understand your scenario.
If you're after the 'label' from the chosen parameter, you can get it
using;
=Parameters!paramname.Label
Chris
Soan wrote:
> I have 2 datasets. One is used to give the values to a parameter and
> the second one is used to populated the main table in my report.
> The first one has a code and a Name like:
> Code Name
> c cat
> d dog
> I would like to display â'catâ' in the main table, but I just have
> the code â'câ'. Is there a way to do it ?|||I am looking for a function that returns the second value of the dataset when
i give the first one.
Something like Parameters!paramname.Label the difference is that the
parameter does not have the valued assigned (I want to access different
values in the dataset).
> I'm not sure I fully understand your scenario.
> If you're after the 'label' from the chosen parameter, you can get it
> using;
> =Parameters!paramname.Label
> Chris
>
> Soan wrote:
> > I have 2 datasets. One is used to give the values to a parameter and
> > the second one is used to populated the main table in my report.
> >
> > The first one has a code and a Name like:
> > Code Name
> > c cat
> > d dog
> >
> > I would like to display â'catâ' in the main table, but I just have
> > the code â'câ'. Is there a way to do it ?
>|||Soan, I think you just need a join in the second dataset on the table
from the 1st dataset that gives you the description. You should make
the dataset contain all the data you want to show in the data region.
eg dataset 1 gives salesperson list;
Select SalesId, FirstName from tblSalesperson
this is used in the parameter. The value is SalesId, the label is
FirstName.
the second dataset would return the orders for that salesperson, but
you want the sales persons fullname on it from the salespersons table;
Select O.OrderId, O.SalesId, S.FullName, O.Date, O.Value
From tblOrder O
Join tblSalesperson S On O.SalesId = S.SalesId
Where O.SalesId = @.parametername
You can achieve this in the Graphical query designer, but I always use
the Generic designer so can't really explain it that well.
Hope that helps.
Chris
Soan wrote:
> I am looking for a function that returns the second value of the
> dataset when i give the first one.
> Something like Parameters!paramname.Label the difference is that the
> parameter does not have the valued assigned (I want to access
> different values in the dataset).
>
> > I'm not sure I fully understand your scenario.
> > If you're after the 'label' from the chosen parameter, you can get
> > it using;
> > =Parameters!paramname.Label
> >
> > Chris
> >
> >
> > Soan wrote:
> >
> > > I have 2 datasets. One is used to give the values to a parameter
> > > and the second one is used to populated the main table in my
> > > report.
> > >
> > > The first one has a code and a Name like:
> > > Code Name
> > > c cat
> > > d dog
> > >
> > > I would like to display â'catâ' in the main table, but I just
> > > have the code â'câ'. Is there a way to do it ?
> >
> >

access table body row from textbox using reportitems collection

Hi

I need to access value of perticular row that is populated in table component from a textbox outside table.

When you are saying particular row, i think you should be knowing the rownumber of the table.

Why can't you have a seperate dataset some thing like t

select top {row_numer} col_name from table1

take the last value from this dataset. leave the main dataset

I wish you might have got some idea with this push

Thank you,

Raj Deep.A

|||

Thanks for your kind consideration.

This solution is convinient if we have one or two cells in which we need to fetch data. But I have a report in which 40-50 such fields are there. And to create a dataset for each row would be tiresome job and not optimal. I was looking at some solutions in direction of

ReportItems collection. I am not sure wether we can get data from data section of table ie except header and trailer.

Regards

Spandan

Access Linked Tables, monitoring SQL

We have a table that is populated via Access linked tables with forms bound
to it. When monitoring the table(or all SQL against the database) I don't
see any of the commands (CRUD) against this table. I beleive that
client-side cursors are used in this scenario? I'm depsarate to see the SQL
as we have disappearing data. Any thonughts or suggestions?
Have you tried a Profiler trace? That will show you the commands that
Access is executing against the server.
--Mary
On Thu, 18 Jan 2007 09:01:03 -0800, Jeff Ericson
<JeffEricson@.discussions.microsoft.com> wrote:

>We have a table that is populated via Access linked tables with forms bound
>to it. When monitoring the table(or all SQL against the database) I don't
>see any of the commands (CRUD) against this table. I beleive that
>client-side cursors are used in this scenario? I'm depsarate to see the SQL
>as we have disappearing data. Any thonughts or suggestions?

Access Linked Tables, monitoring SQL

We have a table that is populated via Access linked tables with forms bound
to it. When monitoring the table(or all SQL against the database) I don't
see any of the commands (CRUD) against this table. I beleive that
client-side cursors are used in this scenario? I'm depsarate to see the SQ
L
as we have disappearing data. Any thonughts or suggestions?Have you tried a Profiler trace? That will show you the commands that
Access is executing against the server.
--Mary
On Thu, 18 Jan 2007 09:01:03 -0800, Jeff Ericson
<JeffEricson@.discussions.microsoft.com> wrote:

>We have a table that is populated via Access linked tables with forms bound
>to it. When monitoring the table(or all SQL against the database) I don't
>see any of the commands (CRUD) against this table. I beleive that
>client-side cursors are used in this scenario? I'm depsarate to see the S
QL
>as we have disappearing data. Any thonughts or suggestions?