Displaying customer data

11 Apr 2006 8:37 PM

helpful sql

Hi all,
   I need to design a solution that will display customer data from Sql
Server tables in an Internet Explorer tab of a third party app, e.g. the
third party app has a tab that can display web pages.

   The third party app display one customer record at a time. I need to
display Payment Transaction records for the current customer(linked by
CustomerNo field) in the Internet Explorer tab. There are six types of
Payment Transaction records. I need to display all Payment transaction
records for the current customer, the subtotal for each transaction type and
the total ampont for all transactions.

   What are the best tools for implementing this solution? Shoule I use
DbNetGrid, Reporting Services, Crystal Reports or any other tool? Please
also point me to any examples on the web or any tutorial.

Thanks in advance.

12 Apr 2006 1:30 PM

Ignacio Machin ( .NET/ C# MVP )

Hi,

Take a look at this page

http://office.microsoft.com/en-gb/assistance/ha011153831033.aspx

Show quoteHide quote

"helpful sql" <nospam@stopspam.com> wrote in message
news:uVMSYfaXGHA.3972@TK2MSFTNGP04.phx.gbl...
> Hi all,
>   I need to design a solution that will display customer data from Sql
> Server tables in an Internet Explorer tab of a third party app, e.g. the
> third party app has a tab that can display web pages.
>
>   The third party app display one customer record at a time. I need to
> display Payment Transaction records for the current customer(linked by
> CustomerNo field) in the Internet Explorer tab. There are six types of
> Payment Transaction records. I need to display all Payment transaction
> records for the current customer, the subtotal for each transaction type
> and the total ampont for all transactions.
>
>   What are the best tools for implementing this solution? Shoule I use
> DbNetGrid, Reporting Services, Crystal Reports or any other tool? Please
> also point me to any examples on the web or any tutorial.
>
> Thanks in advance.
>