interactive sorting in sql reporting 2000

hi all

how can i get interactive sorting in sql reporting 2000 that is available in sql reporting 2005

plz suggest me the solution for same.

Most people approximated this behavior by using a series of parameters which allowed a user to select which columns to sort on. Then, you'd use the parameter values and inject their values into a custom built expression and/or expressions behind a data region. For example:

= "SELECT MyField, MyField1, MyField2 FROM MyTable ORDER BY " & Parameters!SortParameter.Value

...which would resolve to Select....From MyTable ORDER BY SomeColumn.

The example above is very simple...you'd have to make it fancier and use IIF statemetns to check for empty values, etc. etc..

Interaction between tables of local and remote SQL databases

Hi all,

I would be very glad if someone can suggest me what techniques I should use in the following scenario:

I have 2 SQL Server databases : DB1 and DB2. DB 1 is on a remote server (hosting server) and DB 2 is on a local server.

Some tables of each db contain tables that are polulated and changed by the appropriate application, i.e.:

DB1.users, DB1.orders,... etc are managed by "webapplication"

DB1.products ... are not managed by "webapplication" : in fact only used to read from

DB2.products, DB2.customers, .... etc are managed by "winapplication"

DB2.orders,....are partially managed by "winapplication"

Since the amount of data can go over 100000 records i'm wondering what would by the best approach to :

- synchronize the data of DB1.products and DB2.products in DB1 on remote server (updated newly added rows and update changed rows,....)

- the products data is only (at the moment) added, edited and deleted on the local server

I think SQLBulkCopy will not do the job. Should it be possible with some query? Or...?

Any suggestions are appreciated!!

O.

Some addition:

- Does SQLBulkCopy copy-append data to the destination database.table?

- What about identity keys?

- Should it be the best solution to modify the SqlCommand so it takes only those rows I want to be inserted as (depending on bulkcopies already done before) or is this done by SQLBulkcopy itself....?

Please inform.

O.

Integrating SSRS with SAP

Hi ,

I can see that there is an adapter description for SAP is available [although commented] in rsreportserver.config.

Can anybody suggest what i need to followup to call the SAP interfaces[i alreday have RFC and SAP.NET connector avialable with me] and i am calling the SAP interface thru custom assembly.

If the adapter is available can anybody suggest some how can i activate the adapter to call the SAP interfaces directly from SSRS and how the credentila flows from SSRS to SAP.

Have you reviewed the SAP topic in BOL?|||

Teo,

Thansk for the reply.BOL was pointing to the netweaverBI sys but for our case the netweaver frx was not inplace...however i found the link http://msdn2.microsoft.com/en-us/library/ms141761.aspx and it was mentined that it came as a separate download.

The Microsoft .NET Data Provider for mySAP Business Suite is not included in SQL Server 2005, you must download it from http://msdn.microsoft.com/downloads/.

thanks again for the reply though.