I'm trying to build a report in excel which shows invoice details. The
invoicedata comes from a sql server db which I have linked in a separate
worksheet and now looks like a table in Excel. How can I have the invoice
detail sheet show the details from the linked table and have controls that
allow to select the details for different clients (by browsing next/previous
or by looking up a name)?

Can't seem to link an active record to the details view.

i'm pretty new to this stuff.. so pointers on where to search would already
be very helpful. I have a .NET C# background.

you're obviously linking the report to the table somehow?

its hard to say without seeing what you have, but I'd imagine that the data
table has one row per client, and that the client name, or maybe an index is
unique?

you can use the OFFSET function to put data into the report

suppose the data table starts at C5 (headings in C4) , cust #1 in C5,D5...,
cust #2 in C6,D6 ...

if in your report you have 1 a cell (A1)
you can use =OFFSET(dataSheet!C4,A1,0)
this reyrn the data in C4 offset by 1 row, ie C5 , which is cust #1
change the 1 in A1 to a 2
then the value you get back is that in C4 offset by two rows, ie C6, which
is cust #2

is this clear?












"Yannick Smits" wrote:

I'm trying to build a report in excel which shows invoice details. The
invoicedata comes from a sql server db which I have linked in a separate
worksheet and now looks like a table in Excel. How can I have the invoice
detail sheet show the details from the linked table and have controls that
allow to select the details for different clients (by browsing next/previous
or by looking up a name)?

Can't seem to link an active record to the details view.

i'm pretty new to this stuff.. so pointers on where to search would already
be very helpful. I have a .NET C# background.

Exactly what I needed! thank you

"Patrick Molloy" wrote:

you're obviously linking the report to the table somehow?

its hard to say without seeing what you have, but I'd imagine that the data
table has one row per client, and that the client name, or maybe an index is
unique?

you can use the OFFSET function to put data into the report

suppose the data table starts at C5 (headings in C4) , cust #1 in C5,D5...,
cust #2 in C6,D6 ...

if in your report you have 1 a cell (A1)
you can use =OFFSET(dataSheet!C4,A1,0)
this reyrn the data in C4 offset by 1 row, ie C5 , which is cust #1
change the 1 in A1 to a 2
then the value you get back is that in C4 offset by two rows, ie C6, which
is cust #2

is this clear?












"Yannick Smits" wrote:

I'm trying to build a report in excel which shows invoice details. The
invoicedata comes from a sql server db which I have linked in a separate
worksheet and now looks like a table in Excel. How can I have the invoice
detail sheet show the details from the linked table and have controls that
allow to select the details for different clients (by browsing next/previous
or by looking up a name)?

Can't seem to link an active record to the details view.

i'm pretty new to this stuff.. so pointers on where to search would already
be very helpful. I have a .NET C# background.