Hi,

Just wanted to give a short update. Thanks for the help once again but I did pick up an issue with period 10 conversion. So I modified the code to...

Hi,

Thank you Vinu ! That is excatly what I was looking for:-)

Hi,

Thank you for the response. What I am looking for is to return only transactions that fall between the start and end of each active version. But these are not...

dope!:blush:

My mistake....I was joining on the wrong field

Hi

On your project properties are you pointing the TargetServerURL to http://server/%5Bb%5Dreportserver%5B/b%5D?

Hi

You could add the NT AUTHORITY\NETWORK SERVICE group

Hi,

Have you given these rights through the SSRS web interface?

Hi,

I would stage the data in a staging table. Then you could load the data into grid in batches for review before moving to the traget table.

Hi

I came across this which we currently use.

http://www.sql-server-performance.com/software/review/dba_dashboard_p1.aspx

Something extra you may want to look at

Hi

Out of curiosity what version of SAP are you using with what RDBMS?

Hi

Firstly what is the reason for you wanting the reports on two different web servers? And do you want one instance of Reporting Services to call both reports?

Hi

My view would be to do the latest. You can always build on your training.

Mike

Hi

Have you tried opening the Reports in VS and running them. If they do run redeloy them this should sort out your problem....If not try creating a simple report...

Hi

You could create a formula within Crystal to do the convert for you too. Crystal has the date fuctions that should help.

Hi

One last thing to add we ran into some problems if SP3 or above was not installed on the SQL2000 Instance.....