Can i developmy db in SQL Server MSDE then upload to SQL Server 20

I want to develop a web application using the MSDE version of SQL server -
will i then be able to upload it to a web host running SQL Server 2000?
Thanks
Yes.
"JoeConnor79" <JoeConnor79@.discussions.microsoft.com> wrote in message
news:8F42A758-7C69-4A04-94A7-5A7F1A0A709A@.microsoft.com...
> I want to develop a web application using the MSDE version of SQL server -
> will i then be able to upload it to a web host running SQL Server 2000?
> Thanks

can i develop on a different machine?

I have just installed reporting services on our web server and am able
to create report projects from there, but I don't generally create
visual studio projects on the web server. I use a development machine
that does not have IIS installed. Is there any way to create report
projects on my development machine and point it to the report server?
I can't find any information on this, all of the examples I find tell
me to open a new report project, but the template only exists on the
report server. Is there some client tool I need to install?When you installed on the web server you installed both server and client
tools. Normally you would not have VS installed on the production machine
and only install the server part. Although it can be handy to be developing
on a machine that has both installed it is not necessary. When you preview a
report in VS it is not using IIS. Just install the client tools from the RS
installation on a machine that has Visual Studio on it.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"malpous" <porterdn@.email.uc.edu> wrote in message
news:97b85c30.0411221031.6907a8e2@.posting.google.com...
> I have just installed reporting services on our web server and am able
> to create report projects from there, but I don't generally create
> visual studio projects on the web server. I use a development machine
> that does not have IIS installed. Is there any way to create report
> projects on my development machine and point it to the report server?
> I can't find any information on this, all of the examples I find tell
> me to open a new report project, but the template only exists on the
> report server. Is there some client tool I need to install?

Can any one help me wid this Problem

Hello Guys,

I have developed some projects in VB. And now wanted to develop some reports. As i have gone through Data Report, i am facing a **** lot of problem in Page Breaking. I am not able to do the Page Break.

I want per record per page. viz. Employee Name, Salary and Photo per page/employee.

Some one told me to use Crystal Report as it give feature of Conditionall Page Breaking as well as Grouping and it also has Looping Functionality.

Guys, please suggest and help me to develop the Reports.

ThanksIf you want to print only one record per page then goto section expert of the report and in the New Page After option there is button labled x-2. Click that and write this

recordnumber mod 1=0

Calling Subscription screen inside Report viewer

Hello

I use SQL Server 2005 Reporting Service to develop all my Reports. i design the report and deploy to the report server. i have created a Web application where i use the above report to be shown inside a ReportViewer page.

when any user view's the report i also want to give them the subscription screen inside the report viewer. BIG QUESTION is how do i call the subscription screen of a specific report inside the report viewer?

any help is appreciated

/Chandresh Soni

Assuming a clickable link is an appropriate solution here, and assuming that these are RDLs rather than RDLCs (which it seems they are), and if you really want to do it inside the report definition itself, realize that the subscription page is just like any other URL.

You should be able to have a textbox that says "click here to go to the subscriptions page for this report" that navigates to a URL using something similar to this expression for the navigation link:

Code Snippet

="http://YourServer/Reports/Pages/Report.aspx?ItemPath=" &
Globals!ReportFolder & "/" & Globals!ReportName
& "&SelectedTabId=SubscriptionsTab"

... but there is no real advantage to putting this inside the report, IMHO. Why not just something like this expression as a hyperlink in the header of your ReportViewer ASPX page?

>L<

|||

Hello Lisa,

thanks for looking at my problem. you solution works but still have a problem. when i use a link as you suggested in my report viewer the user gets the subscription page but after he completes he is redirected again to show Report manager with all reports.

I have a.rdl file which i show in my web page. but i use this http://<servername>/reportserver?folder name/reportname

this gives me control to show only report with out showing the report manager's header and other details.

eg http://gloss.asp.net/ReportServer?%2fDMS_Reports%2fHB107_Dashboard&rcocMap=false

/Soni

|||

Chandresh, if you don't want them to see the report manager, you shouldn't be sending them to the report manager <s>.

You can interrogate current subscriptions, using the RS SOAP interfaces. You then display whatever limited interface to your users you want, and provide any updates back to RS with SOAP interfaces. Doesn't this make more sense?

>L<

|||

hi again,

many thanks, do you know where can i find more documentation on using RS SOAP API

/Chandresh soni

|||You could start here... http://msdn2.microsoft.com/de-de/library/ms155376.aspx

Or here http://msdn2.microsoft.com/de-de/library/ms155376.aspx

>L<

Calling Subscription screen inside Report viewer

Hello

I use SQL Server 2005 Reporting Service to develop all my Reports. i design the report and deploy to the report server. i have created a Web application where i use the above report to be shown inside a ReportViewer page.

when any user view's the report i also want to give them the subscription screen inside the report viewer. BIG QUESTION is how do i call the subscription screen of a specific report inside the report viewer?

any help is appreciated

/Chandresh Soni

Assuming a clickable link is an appropriate solution here, and assuming that these are RDLs rather than RDLCs (which it seems they are), and if you really want to do it inside the report definition itself, realize that the subscription page is just like any other URL.

You should be able to have a textbox that says "click here to go to the subscriptions page for this report" that navigates to a URL using something similar to this expression for the navigation link:

Code Snippet

="http://YourServer/Reports/Pages/Report.aspx?ItemPath=" &
Globals!ReportFolder & "/" & Globals!ReportName
& "&SelectedTabId=SubscriptionsTab"

... but there is no real advantage to putting this inside the report, IMHO. Why not just something like this expression as a hyperlink in the header of your ReportViewer ASPX page?

>L<

|||

Hello Lisa,

thanks for looking at my problem. you solution works but still have a problem. when i use a link as you suggested in my report viewer the user gets the subscription page but after he completes he is redirected again to show Report manager with all reports.

I have a.rdl file which i show in my web page. but i use this http://<servername>/reportserver?folder name/reportname

this gives me control to show only report with out showing the report manager's header and other details.

eg http://gloss.asp.net/ReportServer?%2fDMS_Reports%2fHB107_Dashboard&rcocMap=false

/Soni

|||

Chandresh, if you don't want them to see the report manager, you shouldn't be sending them to the report manager <s>.

You can interrogate current subscriptions, using the RS SOAP interfaces. You then display whatever limited interface to your users you want, and provide any updates back to RS with SOAP interfaces. Doesn't this make more sense?

>L<

|||

hi again,

many thanks, do you know where can i find more documentation on using RS SOAP API

/Chandresh soni

|||You could start here... http://msdn2.microsoft.com/de-de/library/ms155376.aspx

Or here http://msdn2.microsoft.com/de-de/library/ms155376.aspx

>L<