Re: OrderID or DataTable

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

It really depends on how your partner is building the report. If he's using
Reporting Services, it makes sense to send him the OrderID as the query is
built into the report definition--the Reporting Services engine will rerun
the query. If he's using the ReportViewer control, then passing a populated
DataTable makes sense as this is what the ReportViewer control expects.

hth
See Chapter 14.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

"Tim" <Tim@noemailcom> wrote in message
news:%23srHfa3eHHA.3632@xxxxxxxxxxxxxxxxxxxxxxx
Hi Gurus,
I need advice from you. We are going through an arguement.
I am working on a [ORDERS] project, and another person is working on
[REPORTING].

What he want me to pass is a OrderID, then he will do a query, create a
DataTable to create a report.

But the question is should I pass a OrderID, or a DataTable which I
already have before I call the report.

I peronally don't want to do any query or any round trip to database if I
already have the data.
The other programmer don't think I am right. He want to keep his project
simple and clean.

I just want your suggestion, that what is right solution for this.
Should I pass DataTable or OrderID.

Thanks for any help you can provide.
We are using DotNet Framework 2.0

Thanks, Tim






.

Relevant Pages

  • Re: Populating a list -- table structure?
    ... I had made a report already and figured out about adding the ... your responce below, but thanks to your help with SQL, I was able to get the ... It takes a summary from a select query and gives the ... KitID, long integer ...
    (microsoft.public.access.forms)
  • Re: Fields in Label dont give correct information
    ... You need to create a query based on tblRegEvent and tblRegPayment. ... -If your DCountis to count values in your report, ... half the time with very few errors (other than that label problem I had.) ... For example in the Room assignment on the report an idividual will be ...
    (microsoft.public.access.reports)
  • Re: Tips on domain aggregate replacements
    ... This already is a split db, but the users are 400 miles away from the server hosting the data:) They are all running the same copy of the FE locally on a single terminal server via TS/RDP sessions. ... It doesn't seem to have much impact on performance; the report takes just about as long to run if they are all logged in as it does when I am logged on testing it at night. ... I would do DSums from the controls on the report on the data returned by the query. ... The biggest offender is a certain report that needs to Sum a particular complex total for each of the next twelve months (the DSum in VBA was a sideline to this issue) and present these as items on each line of output. ...
    (microsoft.public.access.modulesdaovba)
  • Re: using a form with combo box to input criteria
    ... Candia Computer Consulting - Candia NH ... When you removed the criteria, ... Then your criteria in the query would be... ... query behind your main report. ...
    (microsoft.public.access.forms)
  • Re: using a form with combo box to input criteria
    ... Candia Computer Consulting - Candia NH ... When you removed the criteria, ... Then your criteria in the query would be... ... query behind your main report. ...
    (microsoft.public.access.forms)