How to implement remote Data Entry then upload to corp. database?

I'm looking for different solution people have implemented to solve this
problem.
Problem: People need to work remotely. While working remotely they want to
gather information. This information might be survey info, or inspection
info, etc. This information is to be stored remotely on a handheld, or
laptop device. After they get back to the office/homeo office they want to
upload the information to our corporate database, which is SQL Server 2000.
This upload process should be very easy, like a like of a button, or done
automatically when the devices is docked into the corporate network. This
solution has to be supported over the Internet, and intranet.
What I'm looking for is what technologies and processes have people put in
places to implement a solution to handle the problem I stated above.
If you have more questions about what I am asking for please let me know.Greg Larsen wrote:
> I'm looking for different solution people have implemented to solve this
> problem.
> Problem: People need to work remotely. While working remotely they want t
o
> gather information. This information might be survey info, or inspection
> info, etc. This information is to be stored remotely on a handheld, or
> laptop device. After they get back to the office/homeo office they want t
o
> upload the information to our corporate database, which is SQL Server 2000
.
> This upload process should be very easy, like a like of a button, or done
> automatically when the devices is docked into the corporate network. This
> solution has to be supported over the Internet, and intranet.
> What I'm looking for is what technologies and processes have people put in
> places to implement a solution to handle the problem I stated above.
> If you have more questions about what I am asking for please let me know.
This is all supported through Merge Replication. Take a look at the
replication topics in Books Online.
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--

How to implement cube to ODS jump target reports

I have implemented a few reports against Analysis Services cubes in
reporting services. I have more detailed data contained in the cubes
in the underlying SQL datawarehouse. I have build a couple of reports
in RS against the datawarehouse tables as well. Now I want to link
these together some scenarios are in the cube I am storing data for
each product at a monthly level so if a user select a particular
product and month combination I want to trigger the reports against
the datawarehouse and pass the values like product# and month chosen
in the report against the cube to the report against the datawarehouse
to enable users to see all the data for the month at a more detailed
level.
Please can anybody share thoughts how this can be done in reporting
services. Currently we use Cognos reportnet we can do this we are
trying to migrate from Cognos reportnet to Reporting Services from a
standardisation and cost perspective.
Thanks
KarenAre you trying to link from AS cubes to RS reports through actions?
If you are looking at integrating AS 2000 and RS 2000, you may want to check
the following MSDN article about how to use RS URL access in AS actions:
http://msdn.microsoft.com/SQL/sqlwarehouse/ReportingServices/default.aspx?pull=/library/en-us/dnsql2k/html/olapasandrs.asp#olapasa_topic8
The good news is that setting up these actions and passing parameters will
be much easier in AS 2005 / RS 2005.
--
Robert M. Bruckner
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Karen Middleton" <karenmiddleol@.yahoo.com> wrote in message
news:a5fd468a.0504050456.be5acfb@.posting.google.com...
>I have implemented a few reports against Analysis Services cubes in
> reporting services. I have more detailed data contained in the cubes
> in the underlying SQL datawarehouse. I have build a couple of reports
> in RS against the datawarehouse tables as well. Now I want to link
> these together some scenarios are in the cube I am storing data for
> each product at a monthly level so if a user select a particular
> product and month combination I want to trigger the reports against
> the datawarehouse and pass the values like product# and month chosen
> in the report against the cube to the report against the datawarehouse
> to enable users to see all the data for the month at a more detailed
> level.
> Please can anybody share thoughts how this can be done in reporting
> services. Currently we use Cognos reportnet we can do this we are
> trying to migrate from Cognos reportnet to Reporting Services from a
> standardisation and cost perspective.
>
> Thanks
> Karen|||Rob & Deepak
Thanks very much for the update. This was one of our pressing needs as
business
objects is asking the business to switch from reporting services to
Business Objects.
I must say the support in reporting services for Analysis Services at
this point
please note we are still on SQL 2000 is very limited. We are already
using Reporting
Services and constantly we face issues from people like Business
Objects who are
coming to our IT Managers and recommending to switch from Reporting
Services
to Crystal. Their justification is in Microsoft the reporting services
and
Analysis Services and the Excel teams refuse to talk to each other and
the product
be it Excel reporting or reporting services reporting lack integration
with
SQL & analysis services what Crystal can achieve.
We do not want to move from reporting services the competition
constantly goes to
the business with the story of lack of integration.
Thanks