layout problem

Hi,
I have 4 subreports in a report and adjust thier position well on layout
tag.
Preview on the report designer everything is fine.
But deploy to report server and browse on IE the subreports all on the wrong
position!
How can I resolve this problem?
Thanks for help!
AngiI had the same problem with some of my reports I found out the only way
ot get the layout right is to enter the location for each item on the
report in the location property and " measure/space" so nothing is over
laping. One can begin where one ends but if they overlap the location
it will be moved to onther page. It still looks a little funny on the
browser but it prints perfectly.sql

Layout problem

Layout problem -
I've created a report with the wizard and it looks fine.
It have a TITLE, a few SUB TITLES (all are textbox with values) and a textbox with JUMP TO link that use as a back button. beneath is a table.
Whan I run ut it look fine (In the first page there is the header and underneath there is the table) but I've noticed that whan the report have more then one page, all of my header (e.g. TITLE,SUBTITLE,BUTTON) is not showen in the second page and above and only the table is.
I've tried to move the title to the header part but it give me an error the the value of the textbox in the header refers to a field and field can't be use in a page header.
Can anybody help me with the title part to make it visible in all pages?
Thank alot in advance,
Roy.
From http://www.developmentnow.com/g/115_0_0_0_0_0/sql-server-reporting-services.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.comIf you click on the header in the designer and then look at the properties
there is a property that is PrintOnFirstPage. This defaults to True, I think
if you set this to False the report will behave the way you want.
Stuart
"roy mm" wrote:
> Layout problem -
> I've created a report with the wizard and it looks fine.
> It have a TITLE, a few SUB TITLES (all are textbox with values) and a textbox with JUMP TO link that use as a back button. beneath is a table.
> Whan I run ut it look fine (In the first page there is the header and underneath there is the table) but I've noticed that whan the report have more then one page, all of my header (e.g. TITLE,SUBTITLE,BUTTON) is not showen in the second page and above and only the table is.
> I've tried to move the title to the header part but it give me an error the the value of the textbox in the header refers to a field and field can't be use in a page header.
> Can anybody help me with the title part to make it visible in all pages?
> Thank alot in advance,
> Roy.
>
> From http://www.developmentnow.com/g/115_0_0_0_0_0/sql-server-reporting-services.htm
> Posted via DevelopmentNow.com Groups
> http://www.developmentnow.com
>

Layout problem

Layout problem -
I've created a report with the wizard and it looks fine.
It have a TITLE, a few SUB TITLES (all are textbox with values) and a textbox with JUMP TO link that use as a back button. beneath is a table.

Whan I run ut it look fine (In the first page there is the header and underneath there is the table) but I've noticed that whan the report have more then one page, all of my header (e.g. TITLE,SUBTITLE,BUTTON) is not showen in the second page and above and only the table is.

I've tried to move the title to the header part but it give me an error the the value of the textbox in the header refers to a field and field can't be use in a page header.

Can anybody help me with the title part to make it visible in all pages?

Thank alot in advance,
Roy.Are you using a true page header or just a couple of test fields at the top of the page. Click the Report menu and see if you have a Page Header selected.

Layout problem

Layout problem -
I've created a report with the wizard and it looks fine.
It have a TITLE, a few SUB TITLES (all are textbox with values) and a textbox with JUMP TO link that use as a back button. beneath is a table.

Whan I run ut it look fine (In the first page there is the header and underneath there is the table) but I've noticed that whan the report have more then one page, all of my header (e.g. TITLE,SUBTITLE,BUTTON) is not showen in the second page and above and only the table is.

I've tried to move the title to the header part but it give me an error the the value of the textbox in the header refers to a field and field can't be use in a page header.

Can anybody help me with the title part to make it visible in all pages?

Thank alot in advance,
Roy.

Firstly, there is no way to specify that an item should appear on all pages.

However, you do have a few options:

Can you change the textbox contents so it doesn't refrence a field but a parameter instead?|||Hi.
1) the first solution is no good since i can't (I'm getting one value as parameter and need to get his match value from the db)
2) I didn't quit get that part, can you please explain me again?
3) ok, this look like a solution, but it realy not that nice.
To make the header look like he is now i'll need a table with only header for my first header line and another tabke with just a header a 5 cells for each value i want to show.
meanwhile it look like the only solution i have.

I wrote to myself your comment about the display in the exporting! Its importent.

Thank,
Roy.|||

A list control allows you to define grouping in your data. It also has the option of adding a page break before/after each group. For export to Excel this forces each group onto a separate tab.

If you drop a table or matrix into a list control then you can control how the data is groupped and hence paged by setting the attibutes of the list control.

So as an example imagine I have a query with 5 fields (or dimensions) country, sales person, month, product and sales amount. My target audience aim to export to Excel. I can configure the report so that in excel it will end up having a tab per country, on each tab have a grid per sales person and in the grid have month and product on the rows and columns. This can be achieved using a matrix nested inside 2 list controls. List 1 groupped by country with a page break, list 2 groupped by sales person with no page break and the other 2 fileds in the matrix.

The point is, you can then include textboxes within the lists and they will repeat in a similar fassion.

Once again, paging in the web will potentially break certain pages up further if they are too long. 400 pages in the web doesn't mean there will be 400 tabs in Excel.

|||

Thanks heaps ! this post did help me with finding a solution for another problem of exporting data to multiple worksheets in Excel.

Nadeem

Layout problem

Layout problem -
I've created a report with the wizard and it looks fine.
It have a TITLE, a few SUB TITLES (all are textbox with values) and a textbox with JUMP TO link that use as a back button. beneath is a table.

Whan I run ut it look fine (In the first page there is the header and underneath there is the table) but I've noticed that whan the report have more then one page, all of my header (e.g. TITLE,SUBTITLE,BUTTON) is not showen in the second page and above and only the table is.

I've tried to move the title to the header part but it give me an error the the value of the textbox in the header refers to a field and field can't be use in a page header.

Can anybody help me with the title part to make it visible in all pages?

Thank alot in advance,
Roy.

Firstly, there is no way to specify that an item should appear on all pages.

However, you do have a few options:

Can you change the textbox contents so it doesn't refrence a field but a parameter instead?|||Hi.
1) the first solution is no good since i can't (I'm getting one value as parameter and need to get his match value from the db)
2) I didn't quit get that part, can you please explain me again?
3) ok, this look like a solution, but it realy not that nice.
To make the header look like he is now i'll need a table with only header for my first header line and another tabke with just a header a 5 cells for each value i want to show.
meanwhile it look like the only solution i have.

I wrote to myself your comment about the display in the exporting! Its importent.

Thank,
Roy.|||

A list control allows you to define grouping in your data. It also has the option of adding a page break before/after each group. For export to Excel this forces each group onto a separate tab.

If you drop a table or matrix into a list control then you can control how the data is groupped and hence paged by setting the attibutes of the list control.

So as an example imagine I have a query with 5 fields (or dimensions) country, sales person, month, product and sales amount. My target audience aim to export to Excel. I can configure the report so that in excel it will end up having a tab per country, on each tab have a grid per sales person and in the grid have month and product on the rows and columns. This can be achieved using a matrix nested inside 2 list controls. List 1 groupped by country with a page break, list 2 groupped by sales person with no page break and the other 2 fileds in the matrix.

The point is, you can then include textboxes within the lists and they will repeat in a similar fassion.

Once again, paging in the web will potentially break certain pages up further if they are too long. 400 pages in the web doesn't mean there will be 400 tabs in Excel.

|||

Thanks heaps ! this post did help me with finding a solution for another problem of exporting data to multiple worksheets in Excel.

Nadeem

sql

Layout of report parameters

Hi all

Is there any way to change the way the report parameters are displayed?

Presently they are just in a tabular format. I am after displaying them as follows:

- - -

__

- -

The horizontal line is there to group the parameters. Is that possible?

Thanks heaps
This is not natively supported. You would need to construct your own prompting area.

Layout margins in cm

Some how layout margins are appearing in cm on report design layout.
I would like them to be setup in inches.
Layout margins come up as inches on other developers machines.
How can I set it up so that I get margins as inches and not cm.
Please help.
TIA..Hi sqlster,
You should be able to simply type in 0.5in for a margin.
Is your language set to "English (United States) in the report properties?
IT may be defaulting to metric based on that, but in any case, you should be
able to type "in" after your numbers and it should be in inches.
I hope that helps!
Chris
"sqlster" <nospam@.nospam.com> wrote in message
news:D00CBBE8-DDF1-4D4E-AA29-90B653F728F4@.microsoft.com...
> Some how layout margins are appearing in cm on report design layout.
> I would like them to be setup in inches.
> Layout margins come up as inches on other developers machines.
> How can I set it up so that I get margins as inches and not cm.
> Please help.
> TIA..|||Hi sqlster,
You should be able to simply type in 0.5in for a margin.
Is your language set to "English (United States) in the report properties?
IT may be defaulting to metric based on that, but in any case, you should be
able to type "in" after your numbers and it should be in inches.
I hope that helps!
Chris
"sqlster" <nospam@.nospam.com> wrote in message
news:D00CBBE8-DDF1-4D4E-AA29-90B653F728F4@.microsoft.com...
> Some how layout margins are appearing in cm on report design layout.
> I would like them to be setup in inches.
> Layout margins come up as inches on other developers machines.
> How can I set it up so that I get margins as inches and not cm.
> Please help.
> TIA..|||I tried typing inches. But it reverts back to inches after I save, close and
reopen the report.
"Chris Hastings" wrote:
> Hi sqlster,
> You should be able to simply type in 0.5in for a margin.
> Is your language set to "English (United States) in the report properties?
> IT may be defaulting to metric based on that, but in any case, you should be
> able to type "in" after your numbers and it should be in inches.
> I hope that helps!
> Chris
> "sqlster" <nospam@.nospam.com> wrote in message
> news:D00CBBE8-DDF1-4D4E-AA29-90B653F728F4@.microsoft.com...
> > Some how layout margins are appearing in cm on report design layout.
> >
> > I would like them to be setup in inches.
> >
> > Layout margins come up as inches on other developers machines.
> >
> > How can I set it up so that I get margins as inches and not cm.
> >
> > Please help.
> >
> > TIA..
>
>|||I meant to say that even if I type inches, it reverts back to cm after I save
and close the report.
TIA...
"sqlster" wrote:
> I tried typing inches. But it reverts back to inches after I save, close and
> reopen the report.
> "Chris Hastings" wrote:
> > Hi sqlster,
> > You should be able to simply type in 0.5in for a margin.
> > Is your language set to "English (United States) in the report properties?
> > IT may be defaulting to metric based on that, but in any case, you should be
> > able to type "in" after your numbers and it should be in inches.
> > I hope that helps!
> > Chris
> >
> > "sqlster" <nospam@.nospam.com> wrote in message
> > news:D00CBBE8-DDF1-4D4E-AA29-90B653F728F4@.microsoft.com...
> > > Some how layout margins are appearing in cm on report design layout.
> > >
> > > I would like them to be setup in inches.
> > >
> > > Layout margins come up as inches on other developers machines.
> > >
> > > How can I set it up so that I get margins as inches and not cm.
> > >
> > > Please help.
> > >
> > > TIA..
> >
> >
> >
> >|||Hi Tia,
I'm sorry, I haven't got a clue. The only thing I can think of is that your
regional options are set to metric on that computer. Have you checked that?
If you go into control panel, regional and Language Options, then
customize, there is a measurement system at the bottom that should be US and
not Metric.
Other than that, make sure the properties of the report have the right
language selected, and if it still happens, I'm at a loss.
I'm sorry I couldn't be of more help...
Chris
"sqlster" <nospam@.nospam.com> wrote in message
news:A7D197C8-6223-43A2-AE7D-46D9C1F9F5F4@.microsoft.com...
>I meant to say that even if I type inches, it reverts back to cm after I
>save
> and close the report.
> TIA...
> "sqlster" wrote:
>> I tried typing inches. But it reverts back to inches after I save, close
>> and
>> reopen the report.
>> "Chris Hastings" wrote:
>> > Hi sqlster,
>> > You should be able to simply type in 0.5in for a margin.
>> > Is your language set to "English (United States) in the report
>> > properties?
>> > IT may be defaulting to metric based on that, but in any case, you
>> > should be
>> > able to type "in" after your numbers and it should be in inches.
>> > I hope that helps!
>> > Chris
>> >
>> > "sqlster" <nospam@.nospam.com> wrote in message
>> > news:D00CBBE8-DDF1-4D4E-AA29-90B653F728F4@.microsoft.com...
>> > > Some how layout margins are appearing in cm on report design layout.
>> > >
>> > > I would like them to be setup in inches.
>> > >
>> > > Layout margins come up as inches on other developers machines.
>> > >
>> > > How can I set it up so that I get margins as inches and not cm.
>> > >
>> > > Please help.
>> > >
>> > > TIA..
>> >
>> >
>> >
>> >

Layout Issue

I have a dataset that goes like this

1

2

3

4

5

6

Using a table control, report preview appears as above.

I want the report to look like

1 2 3

4 5 6

How can I generate a report like this ?

Thanks

Is there any other control I can use to get the desired output.

Thanks !!

Layout incorrect when using ReportViewer

Please can someone help me with this.

I have created a very simple SQL report which has a title, Image, 3 subtitles and some data fields.

When I view it is my VS designer and preview it looks perfect, however when I deploy and view the the report through my ReportViewer control all the labels get moved around and the entire thing is a mess.

If I then export it to PDF it looks perfect again... I am sure I am missing something obvious but I can't find it.

I have done absolutely no expression formatting or coding at all. It's a plain SQL query and plain result textboxes.

Could be that something is overlapping in your report. Make sure that none of the components or fields are overlapping even slightly with each other. Overlapping items usually do not get rendered correctly when viewed on HTML.

-Aayush

|||

Aayush Goyal wrote:

Could be that something is overlapping in your report. Make sure that none of the components or fields are overlapping even slightly with each other. Overlapping items usually do not get rendered correctly when viewed on HTML.

-Aayush

It actually turned out to be a combination of two things, I had some overlapping but it still failed after I fixed that. I then checked it in IE and it worked this time.

Now I need to find out why it is not working in Firefox?

Launching Report Builder via internet

I have a copy of report builder exposed to the local LAN and also the
internet, currently I am using a dynamic IP for testing in a development
environment. I am using windows logon to for security.
If I log onto the server from the local lan using the username/pw the report
display and I am able to launch the report builder. If I logon via the
internet I am able to view the report but when I launch the report builder I
get a secuirty error as far as I can tel.
Do the reports consider an internet connection different to a LAN
connection?
Is there a way around this problem?
Suggestions?
Using SQL 2005 running on Windows 2003 SP1
Regards,
John
Error message <ip was changed>
**************************
PLATFORM VERSION INFO
Windows : 5.1.2600.131072 (Win32NT)
Common Language Runtime : 2.0.50727.42
System.Deployment.dll : 2.0.50727.42 (RTM.050727-4200)
mscorwks.dll : 2.0.50727.42 (RTM.050727-4200)
dfdll.dll : 2.0.50727.42 (RTM.050727-4200)
dfshim.dll : 2.0.50727.42 (RTM.050727-4200)
SOURCES
Deployment url :
http://0.0.0.0/ReportServer/ReportBuilder/ReportBuilder.application
ERROR SUMMARY
Below is a summary of the errors, details of these errors are listed later
in the log.
* Activation of
http://0.0.0.0/ReportServer/ReportBuilder/ReportBuilder.application resulted
in exception. Following failure messages were detected:
+ Downloading
http://0.0.0.0/ReportServer/ReportBuilder/ReportBuilder.application did not
succeed.
+ The remote server returned an error: (401) Unauthorized.
COMPONENT STORE TRANSACTION FAILURE SUMMARY
No transaction error was detected.
WARNINGS
There were no warnings during this operation.
OPERATION PROGRESS STATUS
* [7/25/2006 4:23:21 PM] : Activation of
http://0.0.0.0/ReportServer/ReportBuilder/ReportBuilder.application has
started.
ERROR DETAILS
Following errors were detected during this operation.
* [7/25/2006 4:23:24 PM]
System.Deployment.Application.DeploymentDownloadException (Unknown subtype)
- Downloading
http://0.0.0.0/ReportServer/ReportBuilder/ReportBuilder.application did not
succeed.
- Source: System.Deployment
- Stack trace:
at
System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem
next)
at System.Deployment.Application.SystemNetDownloader.DownloadAllFiles()
at
System.Deployment.Application.FileDownloader.Download(SubscriptionState
subState)
at
System.Deployment.Application.DownloadManager.DownloadManifestAsRawFile(Uri&
sourceUri, String targetPath, IDownloadNotification notification,
DownloadOptions options, ServerInformation& serverInformation)
at
System.Deployment.Application.DownloadManager.DownloadDeploymentManifestDirectBypass(SubscriptionStore
subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState,
IDownloadNotification notification, DownloadOptions options,
ServerInformation& serverInformation)
at
System.Deployment.Application.DownloadManager.DownloadDeploymentManifestBypass(SubscriptionStore
subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState,
IDownloadNotification notification, DownloadOptions options)
at
System.Deployment.Application.ApplicationActivator.PerformDeploymentActivation(Uri
activationUri, Boolean isShortcut)
at
System.Deployment.Application.ApplicationActivator.ActivateDeploymentWorker(Object
state)
-- Inner Exception --
System.Net.WebException
- The remote server returned an error: (401) Unauthorized.
- Source: System
- Stack trace:
at System.Net.HttpWebRequest.GetResponse()
at
System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem
next)
COMPONENT STORE TRANSACTION DETAILS
No transaction information is available.Well it does not seem to be an Internet problem. After checking several
computers on the LAN I have found one XP Pro system that shows the download
box but then nothing, very useful (NOT) and one Win2KPro system that give me
the same network security setting error.
I found a newsgroup message that said turn off the anonymous setting and
another that said turn it on. Neither worked but it was off.
Also found one that said to change to partial trust in the config file, did
not help either.
I am starting to deeply regreat my choice in trying to use this mess.
Regards,
John|||John, did you ever resolve your problem? I'm getting ready to install RS2005
and I want to do the same thing.
--
Dan D.
"John J. Hughes II" wrote:
> I have a copy of report builder exposed to the local LAN and also the
> internet, currently I am using a dynamic IP for testing in a development
> environment. I am using windows logon to for security.
> If I log onto the server from the local lan using the username/pw the report
> display and I am able to launch the report builder. If I logon via the
> internet I am able to view the report but when I launch the report builder I
> get a secuirty error as far as I can tel.
> Do the reports consider an internet connection different to a LAN
> connection?
> Is there a way around this problem?
> Suggestions?
> Using SQL 2005 running on Windows 2003 SP1
> Regards,
> John
> Error message <ip was changed>
> **************************
> PLATFORM VERSION INFO
> Windows : 5.1.2600.131072 (Win32NT)
> Common Language Runtime : 2.0.50727.42
> System.Deployment.dll : 2.0.50727.42 (RTM.050727-4200)
> mscorwks.dll : 2.0.50727.42 (RTM.050727-4200)
> dfdll.dll : 2.0.50727.42 (RTM.050727-4200)
> dfshim.dll : 2.0.50727.42 (RTM.050727-4200)
> SOURCES
> Deployment url :
> http://0.0.0.0/ReportServer/ReportBuilder/ReportBuilder.application
> ERROR SUMMARY
> Below is a summary of the errors, details of these errors are listed later
> in the log.
> * Activation of
> http://0.0.0.0/ReportServer/ReportBuilder/ReportBuilder.application resulted
> in exception. Following failure messages were detected:
> + Downloading
> http://0.0.0.0/ReportServer/ReportBuilder/ReportBuilder.application did not
> succeed.
> + The remote server returned an error: (401) Unauthorized.
> COMPONENT STORE TRANSACTION FAILURE SUMMARY
> No transaction error was detected.
> WARNINGS
> There were no warnings during this operation.
> OPERATION PROGRESS STATUS
> * [7/25/2006 4:23:21 PM] : Activation of
> http://0.0.0.0/ReportServer/ReportBuilder/ReportBuilder.application has
> started.
> ERROR DETAILS
> Following errors were detected during this operation.
> * [7/25/2006 4:23:24 PM]
> System.Deployment.Application.DeploymentDownloadException (Unknown subtype)
> - Downloading
> http://0.0.0.0/ReportServer/ReportBuilder/ReportBuilder.application did not
> succeed.
> - Source: System.Deployment
> - Stack trace:
> at
> System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem
> next)
> at System.Deployment.Application.SystemNetDownloader.DownloadAllFiles()
> at
> System.Deployment.Application.FileDownloader.Download(SubscriptionState
> subState)
> at
> System.Deployment.Application.DownloadManager.DownloadManifestAsRawFile(Uri&
> sourceUri, String targetPath, IDownloadNotification notification,
> DownloadOptions options, ServerInformation& serverInformation)
> at
> System.Deployment.Application.DownloadManager.DownloadDeploymentManifestDirectBypass(SubscriptionStore
> subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState,
> IDownloadNotification notification, DownloadOptions options,
> ServerInformation& serverInformation)
> at
> System.Deployment.Application.DownloadManager.DownloadDeploymentManifestBypass(SubscriptionStore
> subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState,
> IDownloadNotification notification, DownloadOptions options)
> at
> System.Deployment.Application.ApplicationActivator.PerformDeploymentActivation(Uri
> activationUri, Boolean isShortcut)
> at
> System.Deployment.Application.ApplicationActivator.ActivateDeploymentWorker(Object
> state)
> -- Inner Exception --
> System.Net.WebException
> - The remote server returned an error: (401) Unauthorized.
> - Source: System
> - Stack trace:
> at System.Net.HttpWebRequest.GetResponse()
> at
> System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem
> next)
> COMPONENT STORE TRANSACTION DETAILS
> No transaction information is available.
>
>|||Basically I was forced to set the report builder directory to anonymous
access. Considering I am running on a test system this was not a major
problem but I would not suggest it for a production system.
Regards,
John
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:6B7ECD5F-014C-439C-B6BD-65FEBC694EFB@.microsoft.com...
> John, did you ever resolve your problem? I'm getting ready to install
> RS2005
> and I want to do the same thing.
> --
> Dan D.
>
> "John J. Hughes II" wrote:
>> I have a copy of report builder exposed to the local LAN and also the
>> internet, currently I am using a dynamic IP for testing in a development
>> environment. I am using windows logon to for security.
>> If I log onto the server from the local lan using the username/pw the
>> report
>> display and I am able to launch the report builder. If I logon via the
>> internet I am able to view the report but when I launch the report
>> builder I
>> get a secuirty error as far as I can tel.
>> Do the reports consider an internet connection different to a LAN
>> connection?
>> Is there a way around this problem?
>> Suggestions?
>> Using SQL 2005 running on Windows 2003 SP1
>> Regards,
>> John
>> Error message <ip was changed>
>> **************************
>> PLATFORM VERSION INFO
>> Windows : 5.1.2600.131072 (Win32NT)
>> Common Language Runtime : 2.0.50727.42
>> System.Deployment.dll : 2.0.50727.42 (RTM.050727-4200)
>> mscorwks.dll : 2.0.50727.42 (RTM.050727-4200)
>> dfdll.dll : 2.0.50727.42 (RTM.050727-4200)
>> dfshim.dll : 2.0.50727.42 (RTM.050727-4200)
>> SOURCES
>> Deployment url :
>> http://0.0.0.0/ReportServer/ReportBuilder/ReportBuilder.application
>> ERROR SUMMARY
>> Below is a summary of the errors, details of these errors are listed
>> later
>> in the log.
>> * Activation of
>> http://0.0.0.0/ReportServer/ReportBuilder/ReportBuilder.application
>> resulted
>> in exception. Following failure messages were detected:
>> + Downloading
>> http://0.0.0.0/ReportServer/ReportBuilder/ReportBuilder.application did
>> not
>> succeed.
>> + The remote server returned an error: (401) Unauthorized.
>> COMPONENT STORE TRANSACTION FAILURE SUMMARY
>> No transaction error was detected.
>> WARNINGS
>> There were no warnings during this operation.
>> OPERATION PROGRESS STATUS
>> * [7/25/2006 4:23:21 PM] : Activation of
>> http://0.0.0.0/ReportServer/ReportBuilder/ReportBuilder.application has
>> started.
>> ERROR DETAILS
>> Following errors were detected during this operation.
>> * [7/25/2006 4:23:24 PM]
>> System.Deployment.Application.DeploymentDownloadException (Unknown
>> subtype)
>> - Downloading
>> http://0.0.0.0/ReportServer/ReportBuilder/ReportBuilder.application did
>> not
>> succeed.
>> - Source: System.Deployment
>> - Stack trace:
>> at
>> System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem
>> next)
>> at
>> System.Deployment.Application.SystemNetDownloader.DownloadAllFiles()
>> at
>> System.Deployment.Application.FileDownloader.Download(SubscriptionState
>> subState)
>> at
>> System.Deployment.Application.DownloadManager.DownloadManifestAsRawFile(Uri&
>> sourceUri, String targetPath, IDownloadNotification notification,
>> DownloadOptions options, ServerInformation& serverInformation)
>> at
>> System.Deployment.Application.DownloadManager.DownloadDeploymentManifestDirectBypass(SubscriptionStore
>> subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState&
>> subState,
>> IDownloadNotification notification, DownloadOptions options,
>> ServerInformation& serverInformation)
>> at
>> System.Deployment.Application.DownloadManager.DownloadDeploymentManifestBypass(SubscriptionStore
>> subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState&
>> subState,
>> IDownloadNotification notification, DownloadOptions options)
>> at
>> System.Deployment.Application.ApplicationActivator.PerformDeploymentActivation(Uri
>> activationUri, Boolean isShortcut)
>> at
>> System.Deployment.Application.ApplicationActivator.ActivateDeploymentWorker(Object
>> state)
>> -- Inner Exception --
>> System.Net.WebException
>> - The remote server returned an error: (401) Unauthorized.
>> - Source: System
>> - Stack trace:
>> at System.Net.HttpWebRequest.GetResponse()
>> at
>> System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem
>> next)
>> COMPONENT STORE TRANSACTION DETAILS
>> No transaction information is available.
>>
>>|||I agree. That is the issue we're having. We have a client that wants to have
a few people use ReportBuilder from a site that we host in-house. We're
trying to figure out the security, too. Good luck.
Thanks,
--
Dan D.
"John J. Hughes II" wrote:
> Basically I was forced to set the report builder directory to anonymous
> access. Considering I am running on a test system this was not a major
> problem but I would not suggest it for a production system.
> Regards,
> John
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:6B7ECD5F-014C-439C-B6BD-65FEBC694EFB@.microsoft.com...
> > John, did you ever resolve your problem? I'm getting ready to install
> > RS2005
> > and I want to do the same thing.
> > --
> > Dan D.
> >
> >
> > "John J. Hughes II" wrote:
> >
> >> I have a copy of report builder exposed to the local LAN and also the
> >> internet, currently I am using a dynamic IP for testing in a development
> >> environment. I am using windows logon to for security.
> >>
> >> If I log onto the server from the local lan using the username/pw the
> >> report
> >> display and I am able to launch the report builder. If I logon via the
> >> internet I am able to view the report but when I launch the report
> >> builder I
> >> get a secuirty error as far as I can tel.
> >>
> >> Do the reports consider an internet connection different to a LAN
> >> connection?
> >> Is there a way around this problem?
> >> Suggestions?
> >>
> >> Using SQL 2005 running on Windows 2003 SP1
> >>
> >> Regards,
> >> John
> >>
> >> Error message <ip was changed>
> >> **************************
> >> PLATFORM VERSION INFO
> >> Windows : 5.1.2600.131072 (Win32NT)
> >> Common Language Runtime : 2.0.50727.42
> >> System.Deployment.dll : 2.0.50727.42 (RTM.050727-4200)
> >> mscorwks.dll : 2.0.50727.42 (RTM.050727-4200)
> >> dfdll.dll : 2.0.50727.42 (RTM.050727-4200)
> >> dfshim.dll : 2.0.50727.42 (RTM.050727-4200)
> >>
> >> SOURCES
> >> Deployment url :
> >> http://0.0.0.0/ReportServer/ReportBuilder/ReportBuilder.application
> >>
> >> ERROR SUMMARY
> >> Below is a summary of the errors, details of these errors are listed
> >> later
> >> in the log.
> >> * Activation of
> >> http://0.0.0.0/ReportServer/ReportBuilder/ReportBuilder.application
> >> resulted
> >> in exception. Following failure messages were detected:
> >> + Downloading
> >> http://0.0.0.0/ReportServer/ReportBuilder/ReportBuilder.application did
> >> not
> >> succeed.
> >> + The remote server returned an error: (401) Unauthorized.
> >>
> >> COMPONENT STORE TRANSACTION FAILURE SUMMARY
> >> No transaction error was detected.
> >>
> >> WARNINGS
> >> There were no warnings during this operation.
> >>
> >> OPERATION PROGRESS STATUS
> >> * [7/25/2006 4:23:21 PM] : Activation of
> >> http://0.0.0.0/ReportServer/ReportBuilder/ReportBuilder.application has
> >> started.
> >>
> >> ERROR DETAILS
> >> Following errors were detected during this operation.
> >> * [7/25/2006 4:23:24 PM]
> >> System.Deployment.Application.DeploymentDownloadException (Unknown
> >> subtype)
> >> - Downloading
> >> http://0.0.0.0/ReportServer/ReportBuilder/ReportBuilder.application did
> >> not
> >> succeed.
> >> - Source: System.Deployment
> >> - Stack trace:
> >> at
> >> System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem
> >> next)
> >> at
> >> System.Deployment.Application.SystemNetDownloader.DownloadAllFiles()
> >> at
> >> System.Deployment.Application.FileDownloader.Download(SubscriptionState
> >> subState)
> >> at
> >> System.Deployment.Application.DownloadManager.DownloadManifestAsRawFile(Uri&
> >> sourceUri, String targetPath, IDownloadNotification notification,
> >> DownloadOptions options, ServerInformation& serverInformation)
> >> at
> >> System.Deployment.Application.DownloadManager.DownloadDeploymentManifestDirectBypass(SubscriptionStore
> >> subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState&
> >> subState,
> >> IDownloadNotification notification, DownloadOptions options,
> >> ServerInformation& serverInformation)
> >> at
> >> System.Deployment.Application.DownloadManager.DownloadDeploymentManifestBypass(SubscriptionStore
> >> subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState&
> >> subState,
> >> IDownloadNotification notification, DownloadOptions options)
> >> at
> >> System.Deployment.Application.ApplicationActivator.PerformDeploymentActivation(Uri
> >> activationUri, Boolean isShortcut)
> >> at
> >> System.Deployment.Application.ApplicationActivator.ActivateDeploymentWorker(Object
> >> state)
> >> -- Inner Exception --
> >> System.Net.WebException
> >> - The remote server returned an error: (401) Unauthorized.
> >> - Source: System
> >> - Stack trace:
> >> at System.Net.HttpWebRequest.GetResponse()
> >> at
> >> System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem
> >> next)
> >>
> >> COMPONENT STORE TRANSACTION DETAILS
> >> No transaction information is available.
> >>
> >>
> >>
> >>
>
>|||I figured out how to get this to work. I was having the exact same problems.
1. Connected to the report report server at work over the VPN. My machine
at home is not part of the work domain and I'm not using a RADIUS server.
2. After viewing the http://servername/reports page, I set the server up in
IE zone security to a TRUSTED SITE.
3. Click on the Report Builder icon and presto, work perfect, using the
credentials I entered in the IE login dialog box.
Before I made this report server a trusted site, I was getting those 401
errors.
Hope this helps you too,
Karl
"Dan D." wrote:
> I agree. That is the issue we're having. We have a client that wants to have
> a few people use ReportBuilder from a site that we host in-house. We're
> trying to figure out the security, too. Good luck.
> Thanks,
> --
> Dan D.
>
> "John J. Hughes II" wrote:
> > Basically I was forced to set the report builder directory to anonymous
> > access. Considering I am running on a test system this was not a major
> > problem but I would not suggest it for a production system.
> >
> > Regards,
> > John
> >
> > "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> > news:6B7ECD5F-014C-439C-B6BD-65FEBC694EFB@.microsoft.com...
> > > John, did you ever resolve your problem? I'm getting ready to install
> > > RS2005
> > > and I want to do the same thing.
> > > --
> > > Dan D.
> > >
> > >
> > > "John J. Hughes II" wrote:
> > >
> > >> I have a copy of report builder exposed to the local LAN and also the
> > >> internet, currently I am using a dynamic IP for testing in a development
> > >> environment. I am using windows logon to for security.
> > >>
> > >> If I log onto the server from the local lan using the username/pw the
> > >> report
> > >> display and I am able to launch the report builder. If I logon via the
> > >> internet I am able to view the report but when I launch the report
> > >> builder I
> > >> get a secuirty error as far as I can tel.
> > >>
> > >> Do the reports consider an internet connection different to a LAN
> > >> connection?
> > >> Is there a way around this problem?
> > >> Suggestions?
> > >>
> > >> Using SQL 2005 running on Windows 2003 SP1
> > >>
> > >> Regards,
> > >> John
> > >>
> > >> Error message <ip was changed>
> > >> **************************
> > >> PLATFORM VERSION INFO
> > >> Windows : 5.1.2600.131072 (Win32NT)
> > >> Common Language Runtime : 2.0.50727.42
> > >> System.Deployment.dll : 2.0.50727.42 (RTM.050727-4200)
> > >> mscorwks.dll : 2.0.50727.42 (RTM.050727-4200)
> > >> dfdll.dll : 2.0.50727.42 (RTM.050727-4200)
> > >> dfshim.dll : 2.0.50727.42 (RTM.050727-4200)
> > >>
> > >> SOURCES
> > >> Deployment url :
> > >> http://0.0.0.0/ReportServer/ReportBuilder/ReportBuilder.application
> > >>
> > >> ERROR SUMMARY
> > >> Below is a summary of the errors, details of these errors are listed
> > >> later
> > >> in the log.
> > >> * Activation of
> > >> http://0.0.0.0/ReportServer/ReportBuilder/ReportBuilder.application
> > >> resulted
> > >> in exception. Following failure messages were detected:
> > >> + Downloading
> > >> http://0.0.0.0/ReportServer/ReportBuilder/ReportBuilder.application did
> > >> not
> > >> succeed.
> > >> + The remote server returned an error: (401) Unauthorized.
> > >>
> > >> COMPONENT STORE TRANSACTION FAILURE SUMMARY
> > >> No transaction error was detected.
> > >>
> > >> WARNINGS
> > >> There were no warnings during this operation.
> > >>
> > >> OPERATION PROGRESS STATUS
> > >> * [7/25/2006 4:23:21 PM] : Activation of
> > >> http://0.0.0.0/ReportServer/ReportBuilder/ReportBuilder.application has
> > >> started.
> > >>
> > >> ERROR DETAILS
> > >> Following errors were detected during this operation.
> > >> * [7/25/2006 4:23:24 PM]
> > >> System.Deployment.Application.DeploymentDownloadException (Unknown
> > >> subtype)
> > >> - Downloading
> > >> http://0.0.0.0/ReportServer/ReportBuilder/ReportBuilder.application did
> > >> not
> > >> succeed.
> > >> - Source: System.Deployment
> > >> - Stack trace:
> > >> at
> > >> System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem
> > >> next)
> > >> at
> > >> System.Deployment.Application.SystemNetDownloader.DownloadAllFiles()
> > >> at
> > >> System.Deployment.Application.FileDownloader.Download(SubscriptionState
> > >> subState)
> > >> at
> > >> System.Deployment.Application.DownloadManager.DownloadManifestAsRawFile(Uri&
> > >> sourceUri, String targetPath, IDownloadNotification notification,
> > >> DownloadOptions options, ServerInformation& serverInformation)
> > >> at
> > >> System.Deployment.Application.DownloadManager.DownloadDeploymentManifestDirectBypass(SubscriptionStore
> > >> subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState&
> > >> subState,
> > >> IDownloadNotification notification, DownloadOptions options,
> > >> ServerInformation& serverInformation)
> > >> at
> > >> System.Deployment.Application.DownloadManager.DownloadDeploymentManifestBypass(SubscriptionStore
> > >> subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState&
> > >> subState,
> > >> IDownloadNotification notification, DownloadOptions options)
> > >> at
> > >> System.Deployment.Application.ApplicationActivator.PerformDeploymentActivation(Uri
> > >> activationUri, Boolean isShortcut)
> > >> at
> > >> System.Deployment.Application.ApplicationActivator.ActivateDeploymentWorker(Object
> > >> state)
> > >> -- Inner Exception --
> > >> System.Net.WebException
> > >> - The remote server returned an error: (401) Unauthorized.
> > >> - Source: System
> > >> - Stack trace:
> > >> at System.Net.HttpWebRequest.GetResponse()
> > >> at
> > >> System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem
> > >> next)
> > >>
> > >> COMPONENT STORE TRANSACTION DETAILS
> > >> No transaction information is available.
> > >>
> > >>
> > >>
> > >>
> >
> >
> >|||Thanks Karl. The particular problem I'm working on doesn't use VPN. I'll keep
this in mind
for the future if we decide to use VPN at another time.
--
Dan D.
"Karl 140.6" wrote:
> I figured out how to get this to work. I was having the exact same problems.
> 1. Connected to the report report server at work over the VPN. My machine
> at home is not part of the work domain and I'm not using a RADIUS server.
> 2. After viewing the http://servername/reports page, I set the server up in
> IE zone security to a TRUSTED SITE.
> 3. Click on the Report Builder icon and presto, work perfect, using the
> credentials I entered in the IE login dialog box.
> Before I made this report server a trusted site, I was getting those 401
> errors.
> Hope this helps you too,
> Karl
> "Dan D." wrote:
> > I agree. That is the issue we're having. We have a client that wants to have
> > a few people use ReportBuilder from a site that we host in-house. We're
> > trying to figure out the security, too. Good luck.
> >
> > Thanks,
> > --
> > Dan D.
> >
> >
> > "John J. Hughes II" wrote:
> >
> > > Basically I was forced to set the report builder directory to anonymous
> > > access. Considering I am running on a test system this was not a major
> > > problem but I would not suggest it for a production system.
> > >
> > > Regards,
> > > John
> > >
> > > "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> > > news:6B7ECD5F-014C-439C-B6BD-65FEBC694EFB@.microsoft.com...
> > > > John, did you ever resolve your problem? I'm getting ready to install
> > > > RS2005
> > > > and I want to do the same thing.
> > > > --
> > > > Dan D.
> > > >
> > > >
> > > > "John J. Hughes II" wrote:
> > > >
> > > >> I have a copy of report builder exposed to the local LAN and also the
> > > >> internet, currently I am using a dynamic IP for testing in a development
> > > >> environment. I am using windows logon to for security.
> > > >>
> > > >> If I log onto the server from the local lan using the username/pw the
> > > >> report
> > > >> display and I am able to launch the report builder. If I logon via the
> > > >> internet I am able to view the report but when I launch the report
> > > >> builder I
> > > >> get a secuirty error as far as I can tel.
> > > >>
> > > >> Do the reports consider an internet connection different to a LAN
> > > >> connection?
> > > >> Is there a way around this problem?
> > > >> Suggestions?
> > > >>
> > > >> Using SQL 2005 running on Windows 2003 SP1
> > > >>
> > > >> Regards,
> > > >> John
> > > >>
> > > >> Error message <ip was changed>
> > > >> **************************
> > > >> PLATFORM VERSION INFO
> > > >> Windows : 5.1.2600.131072 (Win32NT)
> > > >> Common Language Runtime : 2.0.50727.42
> > > >> System.Deployment.dll : 2.0.50727.42 (RTM.050727-4200)
> > > >> mscorwks.dll : 2.0.50727.42 (RTM.050727-4200)
> > > >> dfdll.dll : 2.0.50727.42 (RTM.050727-4200)
> > > >> dfshim.dll : 2.0.50727.42 (RTM.050727-4200)
> > > >>
> > > >> SOURCES
> > > >> Deployment url :
> > > >> http://0.0.0.0/ReportServer/ReportBuilder/ReportBuilder.application
> > > >>
> > > >> ERROR SUMMARY
> > > >> Below is a summary of the errors, details of these errors are listed
> > > >> later
> > > >> in the log.
> > > >> * Activation of
> > > >> http://0.0.0.0/ReportServer/ReportBuilder/ReportBuilder.application
> > > >> resulted
> > > >> in exception. Following failure messages were detected:
> > > >> + Downloading
> > > >> http://0.0.0.0/ReportServer/ReportBuilder/ReportBuilder.application did
> > > >> not
> > > >> succeed.
> > > >> + The remote server returned an error: (401) Unauthorized.
> > > >>
> > > >> COMPONENT STORE TRANSACTION FAILURE SUMMARY
> > > >> No transaction error was detected.
> > > >>
> > > >> WARNINGS
> > > >> There were no warnings during this operation.
> > > >>
> > > >> OPERATION PROGRESS STATUS
> > > >> * [7/25/2006 4:23:21 PM] : Activation of
> > > >> http://0.0.0.0/ReportServer/ReportBuilder/ReportBuilder.application has
> > > >> started.
> > > >>
> > > >> ERROR DETAILS
> > > >> Following errors were detected during this operation.
> > > >> * [7/25/2006 4:23:24 PM]
> > > >> System.Deployment.Application.DeploymentDownloadException (Unknown
> > > >> subtype)
> > > >> - Downloading
> > > >> http://0.0.0.0/ReportServer/ReportBuilder/ReportBuilder.application did
> > > >> not
> > > >> succeed.
> > > >> - Source: System.Deployment
> > > >> - Stack trace:
> > > >> at
> > > >> System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem
> > > >> next)
> > > >> at
> > > >> System.Deployment.Application.SystemNetDownloader.DownloadAllFiles()
> > > >> at
> > > >> System.Deployment.Application.FileDownloader.Download(SubscriptionState
> > > >> subState)
> > > >> at
> > > >> System.Deployment.Application.DownloadManager.DownloadManifestAsRawFile(Uri&
> > > >> sourceUri, String targetPath, IDownloadNotification notification,
> > > >> DownloadOptions options, ServerInformation& serverInformation)
> > > >> at
> > > >> System.Deployment.Application.DownloadManager.DownloadDeploymentManifestDirectBypass(SubscriptionStore
> > > >> subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState&
> > > >> subState,
> > > >> IDownloadNotification notification, DownloadOptions options,
> > > >> ServerInformation& serverInformation)
> > > >> at
> > > >> System.Deployment.Application.DownloadManager.DownloadDeploymentManifestBypass(SubscriptionStore
> > > >> subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState&
> > > >> subState,
> > > >> IDownloadNotification notification, DownloadOptions options)
> > > >> at
> > > >> System.Deployment.Application.ApplicationActivator.PerformDeploymentActivation(Uri
> > > >> activationUri, Boolean isShortcut)
> > > >> at
> > > >> System.Deployment.Application.ApplicationActivator.ActivateDeploymentWorker(Object
> > > >> state)
> > > >> -- Inner Exception --
> > > >> System.Net.WebException
> > > >> - The remote server returned an error: (401) Unauthorized.
> > > >> - Source: System
> > > >> - Stack trace:
> > > >> at System.Net.HttpWebRequest.GetResponse()
> > > >> at
> > > >> System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem
> > > >> next)
> > > >>
> > > >> COMPONENT STORE TRANSACTION DETAILS
> > > >> No transaction information is available.
> > > >>
> > > >>
> > > >>
> > > >>
> > >
> > >
> > >sql

Launching a Report From an Application

We are trying to launch a report from an application. All that happens is
that the applciation gives the user a link that it dynamically builds,
populating all of the parameters for the user.
Currently the link launches the report, but we wanted two things to happen.
We did not want to show the parameters to the user from within the report and
we also wanted to kkep the tool bar, the green spirally thing when loadign
and the drop downs for exporting.
But it seems like you can either have all that studd on the toolbar and be
able to see the parameters or don't see the parameters and don't see the
toolb bar of green spirally thing.
Any suggestions here? I want to see the toolbar, but I do not want to see
the parameters.Have you tried using
&rc:Toolbar=true&rc:Parameters=false
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Cooper" <Cooper@.discussions.microsoft.com> wrote in message
news:393DA10F-2182-4CA0-B5FD-C617C870384E@.microsoft.com...
> We are trying to launch a report from an application. All that happens is
> that the applciation gives the user a link that it dynamically builds,
> populating all of the parameters for the user.
> Currently the link launches the report, but we wanted two things to
> happen.
> We did not want to show the parameters to the user from within the report
> and
> we also wanted to kkep the tool bar, the green spirally thing when loadign
> and the drop downs for exporting.
> But it seems like you can either have all that studd on the toolbar and be
> able to see the parameters or don't see the parameters and don't see the
> toolb bar of green spirally thing.
> Any suggestions here? I want to see the toolbar, but I do not want to see
> the parameters.

Launch Subscription via VB Code

I have created a subscription via Report Manager & would like to launch it
via vb code or rs script on any given date or time. That is, even though the
subcription may have a set date/time, via CODe I would launch it & modified
its date & time as necessary.
--
EdgarNot particularly elegant, but you can do this in the following way:
1) create a shared schedule that fires once, in the past. Save the Schedule
ID you get back
2) create a subscription that is triggered by this shared schedule.
3) use some code to call the FireEvent method and submit the
TimedSubscription event as the EventType and the schedule ID from (1) as the
MatchData.
-Lukasz
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"mresanchez" <mresanchez@.donot-spam.com> wrote in message
news:045CCA4A-B712-489D-8609-068642154128@.microsoft.com...
>I have created a subscription via Report Manager & would like to launch it
> via vb code or rs script on any given date or time. That is, even though
> the
> subcription may have a set date/time, via CODe I would launch it &
> modified
> its date & time as necessary.
> --
> Edgar|||Lukasz,
I tried your solution & everything works fine except that I get an error
saying that the subscription cannot be found. Even though the subscription
ID is listed within SQL Server. Below is the output I get with the error. I
also Echo the subscription ID & the line so I can see the ID which later I
find in the subscriptions table in SQL Svr. Is there a particular way to
format the subscriptionID in order for RS to see it?
The Current Subscription is: 0d49d301-ecd8-43fc-8319-21ec19e82f77
==========================================System.Web.Services.Protocols.SoapException:
System.Web.Services.Protocols.SoapException: The subsc
ription cannot be found. The subscription identifier that is provided to an
operation cannot be located in the report server database. -->
Microsoft.ReportingServices.Diagnostics.Utilities.Subscrip
tionNotFoundException: The subscription cannot be found. The subscription
identifier that is provid
ed to an operation cannot be located in the report server database.
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.WebServer.ReportingService.GetSubscriptionProperties(String Subsc
riptionID, String& Owner, ExtensionSettings& ExtensionSettings, String&
Description, ActiveState& A
ctive, String& Status, String& EventType, String& MatchData,
ParameterValue[]& Parameters)
at
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message,
WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] param
eters)
at
Microsoft.SqlServer.ReportingServices.ReportingService.GetSubscriptionProperties(String Subsc
riptionID, ExtensionSettings& ExtensionSettings, String& Description,
ActiveState& Active, String&
Status, String& EventType, String& MatchData, ParameterValue[]& Parameters)
at ____ScriptClass.Main()
The command completed successfullysql

launch report manager

How do I launch report manager in SQL 2005? Thanks.
Use a web browser. The URL to use in the browser is configured in the "Reporting Services
Configuration" tool, found in SQL Server 2005, Configuration Tools program group.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"00KobeBrian" <a@.b.com> wrote in message news:OeeV4G36GHA.4580@.TK2MSFTNGP03.phx.gbl...
> How do I launch report manager in SQL 2005? Thanks.
>
sql

launch report manager

How do I launch report manager in SQL 2005? Thanks.Use a web browser. The URL to use in the browser is configured in the "Repor
ting Services
Configuration" tool, found in SQL Server 2005, Configuration Tools program g
roup.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"00KobeBrian" <a@.b.com> wrote in message news:OeeV4G36GHA.4580@.TK2MSFTNGP03.phx.gbl...[vbcol
=seagreen]
> How do I launch report manager in SQL 2005? Thanks.
>[/vbcol]

launch report manager

How do I launch report manager in SQL 2005? Thanks.Use a web browser. The URL to use in the browser is configured in the "Reporting Services
Configuration" tool, found in SQL Server 2005, Configuration Tools program group.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"00KobeBrian" <a@.b.com> wrote in message news:OeeV4G36GHA.4580@.TK2MSFTNGP03.phx.gbl...
> How do I launch report manager in SQL 2005? Thanks.
>

Launch Report Builder from Sharepoint

How do you launch report builder from sharepoint site? Does sharepoint site supports report builder?

The launch point for Report Builder is just a URL, which you can place on any web page. The URL has the form:

http://<servername>/reportserver/reportbuilder/reportbuilder.application

Hope that helps...

|||Yes!! This is exactly what I want. Thanks much!!

launch report builder from C# app

Hi friends
how can i launcg report builder from a C# app ?
i know i can use following url but need to know how to execute that url to bring up the report builder
http://<localhost>/reportserver/reportbuilder/reportbuilder.application

Thanks for your help
finally i found how to do that

WebBrowser wb = new WebBrowser();
wb.Navigate("http://<localhost>/reportserver/reportbuilder/reportbuilder.application");

that works nicely.
one more question on this one ,does anybody know how to select report model also by default instead of user choosing after launching report builder ?|||

Please see this blog post:

http://blogs.msdn.com/bobmeyers/archive/2006/01/24/517083.aspx

Note the issue mentioned in the comments.

|||

Thank you very much Bob.

I've been searching for a solution for this one. Thanks again.

Last() Function?

Greetings,
I'm having some trouble to create a report. In this report I'm supposed to get the last row for each group of customers, ordered by date. Let me explain you a bit further using an example:
The table contains these fields, amongst others: CustomerID, Car, LastVisit.
So, for each customer there are many rows, each one with a different value in LastVisit. What I need to get, and before I started it looked quite easy, is a recordset with the last visit of each customer, given a specific car. For example, the last visit of each customer that has a Ford.
Now, I think there's a function LAST() in Access that actually gets the last row in a group by. That would be great, because the only thing I would have to do is grouping by CustomerID and getting the said last row, but unfortunatelly looks like SQL Server 2000 doesn't support that function.
The question is, how can I get that last row in each group? I've already tried using cursors in a stored procedure and temporary tables but I'm afraid I need a less time consuming solution as I'm dealing with more than 1.5 million rows.
If that's not possible, I guess I could "mark" the rows that I need and filter it later, but I'm not sure how to do it either...
If anyone around can give me some advice I would really appreciate it. I apologize if I was not very clear. I'll try to clarify it if you have doubts.
Thanks in advance,
Ricardo Lopez.

Two thoughts:

1. Try using MIN and MAX (whichever gives the correct value in this case) it will work on values which are non-numeric aswell.

2. Otherwise, use top with an order by, and use desc or asc as appropriate, and write a series of sql statments to get each group, and then combine using the UNION ALL operator.

|||

This will get you the results. It is using a derived table to get the last visit date for a customer id and then joining it with the same table to get the car of that visit.

select v.CustomerID, v.Car
from Visits v
inner join (select CustomerID as CustomerID, max(LastVisit) as LastVisit
from Visits
group by CustomerID) vlast
on (vlast.CustomerID = v.CustomerID and vlast.LastVisit = v.LastVisit)


I have assumed that LastVisit is a datetime column.

Last Year Month to Date Function

I have been spoiled by some report writing tools that have intrinsic
functions like Last Year Month-to-date. I'm looking for a way to emulate
this in SQL Server now with my fields that are date/time.

I'm thinking I need to develop a user defined function to accept a date
input parameter, but I don't know where to start.

Help/Examples appreciated.

Thanks,
Frank

*** Sent via Developersdex http://www.developersdex.com ***Hi, Frank

If you have a date and you want to obtain the corresponding date in the
previous year, you can use the DATEADD function, like this:
DATEADD(year, -1, @.TheDate). For more informations, see:
http://msdn.microsoft.com/library/e..._fa-fz_2c1f.asp

Razvan

Last Run Time History

Is there a way to store the history of every subscription to a report?
Currently, it only stores the last run time.Presently no. You could write a custom delivery extension that logged this
information for each delivery but that is an involved process.
-Lukasz
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"jvmiller" <jvmiller@.discussions.microsoft.com> wrote in message
news:CFD19093-C5EE-4D9E-BC4F-0C4CBDE84D4A@.microsoft.com...
> Is there a way to store the history of every subscription to a report?
> Currently, it only stores the last run time.