Putting Reports in Folders

Using Visual Studio I am trying to arrange my reports.
Here is what I have found:
1. I cannot create folders in Visual Studio.
2. I can deploy individual reports after changing the project property
(destination folder) to have reports arranged in folders.
3. I can deploy multiple projects - each landing in different folders
to have reports arranged in folders.
4. I can deploy a project the vanilla way then in Report Manager move
reports to other folders.
My disappointment is with number 1.
Number 2 is a pain in the neck.
If I do number 3, I have to have so many Data Sources defined it's a
mess.
Number 4 is so much work, I hate it.
HERE'S THE QUESTION
What's the best way to do it?
Thanks in advance.
JerryI am doing #3 & have a folder on Report Manager to share the Data sources.
Data sources still are moved along with the reports to their corresponding
folders. I moved those ones to the shared Data Sources folder, and it works
pretty good for me.
- David
"Jerry Nixon" wrote:
> Using Visual Studio I am trying to arrange my reports.
> Here is what I have found:
> 1. I cannot create folders in Visual Studio.
> 2. I can deploy individual reports after changing the project property
> (destination folder) to have reports arranged in folders.
> 3. I can deploy multiple projects - each landing in different folders
> to have reports arranged in folders.
> 4. I can deploy a project the vanilla way then in Report Manager move
> reports to other folders.
> My disappointment is with number 1.
> Number 2 is a pain in the neck.
> If I do number 3, I have to have so many Data Sources defined it's a
> mess.
> Number 4 is so much work, I hate it.
> HERE'S THE QUESTION
> What's the best way to do it?
> Thanks in advance.
> Jerry
>sql

Putting different reports in the Document Map

Hi,
I am not sure if this is possible or not, but here it goes.
I currently have 3 different chart reports, say 1, 2, 3. The users of these
reports pick which report they would like to run from a drop down in the
application. The remaining parameters for all of the reports are all the
same, so the only difference is picking the report name itself.
A user came to me and asked if there was a way to generate all 3 of the
chart reports at the same time and just have the 3 report names in the
Document Map, so then they could go from chart to chart just by using the map.
I have one idea of making a new report with all 3 charts in it, but I am not
sure how I would just have the one displaying at a time, and then having the
Document Map with only the 3 chart names.
Does this make sense and are there any suggestions?
ThanksPlease check my posting on your other thread with the title "Charting and
the Document Map".
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Spencer23" <Spencer23@.discussions.microsoft.com> wrote in message
news:99A78409-49F2-4DE0-AFB2-5C8B34A8E44D@.microsoft.com...
> Hi,
> I am not sure if this is possible or not, but here it goes.
> I currently have 3 different chart reports, say 1, 2, 3. The users of
> these
> reports pick which report they would like to run from a drop down in the
> application. The remaining parameters for all of the reports are all the
> same, so the only difference is picking the report name itself.
> A user came to me and asked if there was a way to generate all 3 of the
> chart reports at the same time and just have the 3 report names in the
> Document Map, so then they could go from chart to chart just by using the
> map.
> I have one idea of making a new report with all 3 charts in it, but I am
> not
> sure how I would just have the one displaying at a time, and then having
> the
> Document Map with only the 3 chart names.
> Does this make sense and are there any suggestions?
> Thanks
>
>

Pushy Matrix

Hello,

I've encountered an issue with a couple of reports and am wondering if anyone has any information on this. I have found a work-around, but would like to know what causes the issue, so maybe I can address it in another manner.

As standard procedure in all my reports, I have a graphic at the top which is set to Fit Proportional and has a width which is 1.25" shorter than the total width of the report. The same height as the image and filling the remainder of the report width next to it, I place a textbox with a simple expression to provide the time the report was run with a small custom message using the Now() function. Below these two items is another textbox which contains the report title. This textbox typically spans the entire width of the report and is positioned about 1/8" beneath the other two items to avoid incidental contact with the image. In some cases, there will be an additional textbox beneath this with a short description of the report and it's function. Finally, the other report items are displayed with the main content of the report.

In situations where the main content of the report contains a matrix item, I encounter an issue when the report is rendered either through the Preview or a browser. This rendering issue also occurs on occasion when exporting to PDF, though I've not tested other export formats in this situation. What occurs is the textbox which displays the time the report was run ends up being pushed to the far right of the display window beyond the width of the report itself. In Preview or the browser, this is shown on one page with this text box far outside the rest of the report. When the issue impacts exporting to PDF, this sole textbox is pushed to a blank additional page which is obviously not acceptable.

For those who may be wondering, I am working with SQL RS 2000 and VS 2003.

The workaround that I've come up with for this issue is to place both the heading graphic and time textbox within a rectangle. No other adjustments are necessary. For some reason, not what I expected to happen when I tried this, the entire rectangle is left on the main page instead of being pushed to another page as I expected. This works, but seems silly to have to place these items in a rectangle to keep some invisible page break from displacing my textbox.

Again, no rush as I already have a work-around, but just out of curiosity, I wanted to see if anyone else had encountered this. Possibly this will give someone else a work-around if they hadn't found one already.

Thanks

This is actually the correct behavior for all versions of RS. In performing layout, RS decides how items will be pushed around the page by expanding items based on a number of factors. One of those factors is the relative positions of the left edge of the pushed item and the right edge of the pushing item. For example, above, you describe a situation where the left edge of your title textbox is to the right of the matrix's right edge. In this situation, when the matrix expands by X" it causes all items farther right than its right edge to also move by X". Your header image didn't move to the right because its left edge was farther left than the matrix's right edge. When you placed the rectangle around both the image and the textbox, you ensured the rectangle, and therefore the textbox, wouldn't be moved because its left edge was farther left than the matrix's right edge.

This same process also applies to vertical movement. Say you have a page containing a textbox and a matrix side-by-side. If the top edge of the textbox is above the bottom edge of the matrix, the textbox will not be moved down when the matrix expands.

Hopefully this helps explain why your work-around works.

Thanks,

John

|||

Thanks again for the information. That all makes sense, but now it poses another problem. In this situation, I have my same header graphic, time stamp and title, but in the body, I have a matrix and a 100% stacked bar chart sitting next to each other. My report is set to landscape dimensions with 1" margins all around. In design, the matrix is 2.5" wide and the chart is 4.25" wide. There is about a 2" gap between the two items. When I preview this report within VS2003, it appears normal in the standard preview and the print preview. Once I upload the report and view it in Internet Explorer 6, the matrix is pushing the chart over to the right. If I export to PDF from there, it is normal again. When the matrix is completely populated with the most data it could contain, there is still about an inch between it and the chart, EXCEPT when viewing in Internet Explorer.

Any ideas would be greatly appreciated. It is not too likely that anyone would be viewing this particular report from Internet Explorer except to export it to PDF, but I would still like it to look the same when viewing in the browser as it does when exporting.

Thanks In Advance!

|||

I had been playing with this same issue for a few hours, your work-around is exactly what I needed. In my case, my textboxes and matrix were separated by a full-page graph. This makes my report 2 pages, which is what I wanted. The situation where "This is normal rendering" is useless in my case, making it simply more difficult to use. Some days, I miss Crystal Reports. Thankfully, most of our apps use Oracle Reports.

Thanks again! Appreciate the help.

|||I'm having a similar issue. I set up a report with 3 subreports in the detail section. Each subreport is a matrix. I want the 3 matrixes to print one after another without a page break and in Preview, it works fine. When I export to PDF, if the matrix has any data at all, it allocates the entire page and forces everything else onto the next page - even if there's only one line of data. The PageBreakAtEnd and PageBreakAtStart properties are set to false.

Pushy Matrix

Hello,

I've encountered an issue with a couple of reports and am wondering if anyone has any information on this. I have found a work-around, but would like to know what causes the issue, so maybe I can address it in another manner.

As standard procedure in all my reports, I have a graphic at the top which is set to Fit Proportional and has a width which is 1.25" shorter than the total width of the report. The same height as the image and filling the remainder of the report width next to it, I place a textbox with a simple expression to provide the time the report was run with a small custom message using the Now() function. Below these two items is another textbox which contains the report title. This textbox typically spans the entire width of the report and is positioned about 1/8" beneath the other two items to avoid incidental contact with the image. In some cases, there will be an additional textbox beneath this with a short description of the report and it's function. Finally, the other report items are displayed with the main content of the report.

In situations where the main content of the report contains a matrix item, I encounter an issue when the report is rendered either through the Preview or a browser. This rendering issue also occurs on occasion when exporting to PDF, though I've not tested other export formats in this situation. What occurs is the textbox which displays the time the report was run ends up being pushed to the far right of the display window beyond the width of the report itself. In Preview or the browser, this is shown on one page with this text box far outside the rest of the report. When the issue impacts exporting to PDF, this sole textbox is pushed to a blank additional page which is obviously not acceptable.

For those who may be wondering, I am working with SQL RS 2000 and VS 2003.

The workaround that I've come up with for this issue is to place both the heading graphic and time textbox within a rectangle. No other adjustments are necessary. For some reason, not what I expected to happen when I tried this, the entire rectangle is left on the main page instead of being pushed to another page as I expected. This works, but seems silly to have to place these items in a rectangle to keep some invisible page break from displacing my textbox.

Again, no rush as I already have a work-around, but just out of curiosity, I wanted to see if anyone else had encountered this. Possibly this will give someone else a work-around if they hadn't found one already.

Thanks

This is actually the correct behavior for all versions of RS. In performing layout, RS decides how items will be pushed around the page by expanding items based on a number of factors. One of those factors is the relative positions of the left edge of the pushed item and the right edge of the pushing item. For example, above, you describe a situation where the left edge of your title textbox is to the right of the matrix's right edge. In this situation, when the matrix expands by X" it causes all items farther right than its right edge to also move by X". Your header image didn't move to the right because its left edge was farther left than the matrix's right edge. When you placed the rectangle around both the image and the textbox, you ensured the rectangle, and therefore the textbox, wouldn't be moved because its left edge was farther left than the matrix's right edge.

This same process also applies to vertical movement. Say you have a page containing a textbox and a matrix side-by-side. If the top edge of the textbox is above the bottom edge of the matrix, the textbox will not be moved down when the matrix expands.

Hopefully this helps explain why your work-around works.

Thanks,

John

|||

Thanks again for the information. That all makes sense, but now it poses another problem. In this situation, I have my same header graphic, time stamp and title, but in the body, I have a matrix and a 100% stacked bar chart sitting next to each other. My report is set to landscape dimensions with 1" margins all around. In design, the matrix is 2.5" wide and the chart is 4.25" wide. There is about a 2" gap between the two items. When I preview this report within VS2003, it appears normal in the standard preview and the print preview. Once I upload the report and view it in Internet Explorer 6, the matrix is pushing the chart over to the right. If I export to PDF from there, it is normal again. When the matrix is completely populated with the most data it could contain, there is still about an inch between it and the chart, EXCEPT when viewing in Internet Explorer.

Any ideas would be greatly appreciated. It is not too likely that anyone would be viewing this particular report from Internet Explorer except to export it to PDF, but I would still like it to look the same when viewing in the browser as it does when exporting.

Thanks In Advance!

|||

I had been playing with this same issue for a few hours, your work-around is exactly what I needed. In my case, my textboxes and matrix were separated by a full-page graph. This makes my report 2 pages, which is what I wanted. The situation where "This is normal rendering" is useless in my case, making it simply more difficult to use. Some days, I miss Crystal Reports. Thankfully, most of our apps use Oracle Reports.

Thanks again! Appreciate the help.

|||I'm having a similar issue. I set up a report with 3 subreports in the detail section. Each subreport is a matrix. I want the 3 matrixes to print one after another without a page break and in Preview, it works fine. When I export to PDF, if the matrix has any data at all, it allocates the entire page and forces everything else onto the next page - even if there's only one line of data. The PageBreakAtEnd and PageBreakAtStart properties are set to false.sql

Pushy Matrix

Hello,

I've encountered an issue with a couple of reports and am wondering if anyone has any information on this. I have found a work-around, but would like to know what causes the issue, so maybe I can address it in another manner.

As standard procedure in all my reports, I have a graphic at the top which is set to Fit Proportional and has a width which is 1.25" shorter than the total width of the report. The same height as the image and filling the remainder of the report width next to it, I place a textbox with a simple expression to provide the time the report was run with a small custom message using the Now() function. Below these two items is another textbox which contains the report title. This textbox typically spans the entire width of the report and is positioned about 1/8" beneath the other two items to avoid incidental contact with the image. In some cases, there will be an additional textbox beneath this with a short description of the report and it's function. Finally, the other report items are displayed with the main content of the report.

In situations where the main content of the report contains a matrix item, I encounter an issue when the report is rendered either through the Preview or a browser. This rendering issue also occurs on occasion when exporting to PDF, though I've not tested other export formats in this situation. What occurs is the textbox which displays the time the report was run ends up being pushed to the far right of the display window beyond the width of the report itself. In Preview or the browser, this is shown on one page with this text box far outside the rest of the report. When the issue impacts exporting to PDF, this sole textbox is pushed to a blank additional page which is obviously not acceptable.

For those who may be wondering, I am working with SQL RS 2000 and VS 2003.

The workaround that I've come up with for this issue is to place both the heading graphic and time textbox within a rectangle. No other adjustments are necessary. For some reason, not what I expected to happen when I tried this, the entire rectangle is left on the main page instead of being pushed to another page as I expected. This works, but seems silly to have to place these items in a rectangle to keep some invisible page break from displacing my textbox.

Again, no rush as I already have a work-around, but just out of curiosity, I wanted to see if anyone else had encountered this. Possibly this will give someone else a work-around if they hadn't found one already.

Thanks

This is actually the correct behavior for all versions of RS. In performing layout, RS decides how items will be pushed around the page by expanding items based on a number of factors. One of those factors is the relative positions of the left edge of the pushed item and the right edge of the pushing item. For example, above, you describe a situation where the left edge of your title textbox is to the right of the matrix's right edge. In this situation, when the matrix expands by X" it causes all items farther right than its right edge to also move by X". Your header image didn't move to the right because its left edge was farther left than the matrix's right edge. When you placed the rectangle around both the image and the textbox, you ensured the rectangle, and therefore the textbox, wouldn't be moved because its left edge was farther left than the matrix's right edge.

This same process also applies to vertical movement. Say you have a page containing a textbox and a matrix side-by-side. If the top edge of the textbox is above the bottom edge of the matrix, the textbox will not be moved down when the matrix expands.

Hopefully this helps explain why your work-around works.

Thanks,

John

|||

Thanks again for the information. That all makes sense, but now it poses another problem. In this situation, I have my same header graphic, time stamp and title, but in the body, I have a matrix and a 100% stacked bar chart sitting next to each other. My report is set to landscape dimensions with 1" margins all around. In design, the matrix is 2.5" wide and the chart is 4.25" wide. There is about a 2" gap between the two items. When I preview this report within VS2003, it appears normal in the standard preview and the print preview. Once I upload the report and view it in Internet Explorer 6, the matrix is pushing the chart over to the right. If I export to PDF from there, it is normal again. When the matrix is completely populated with the most data it could contain, there is still about an inch between it and the chart, EXCEPT when viewing in Internet Explorer.

Any ideas would be greatly appreciated. It is not too likely that anyone would be viewing this particular report from Internet Explorer except to export it to PDF, but I would still like it to look the same when viewing in the browser as it does when exporting.

Thanks In Advance!

|||

I had been playing with this same issue for a few hours, your work-around is exactly what I needed. In my case, my textboxes and matrix were separated by a full-page graph. This makes my report 2 pages, which is what I wanted. The situation where "This is normal rendering" is useless in my case, making it simply more difficult to use. Some days, I miss Crystal Reports. Thankfully, most of our apps use Oracle Reports.

Thanks again! Appreciate the help.

|||I'm having a similar issue. I set up a report with 3 subreports in the detail section. Each subreport is a matrix. I want the 3 matrixes to print one after another without a page break and in Preview, it works fine. When I export to PDF, if the matrix has any data at all, it allocates the entire page and forces everything else onto the next page - even if there's only one line of data. The PageBreakAtEnd and PageBreakAtStart properties are set to false.

Pulling reports from Reporting server

I have reports posted to my server and need to edit them. My issue is the original rdl has been "misplaced". I do not have a model built for this server so I cannot use the built in report builder. Is there a way to "download" from the reporting server?Yes. Using Report Manager, If you click on the "properties" of the report and go to the "general" tab, there is an "edit" button right below "Report Definition". This should prompt an edit/save dialog box that will let you download the report if you have the appropriate permissions.

Pulling Dates 14 days or more past

Does anyone know a way to get Crystal to look for dates 14 days or more past a given date? I'm using Crystal reports 9 and I've tried using the DateDiff function like so.

DateDiff("d",{?StartDate},{Command.RecDate})<=14

but I'm not getting the results I want. I also tried using it in an SQL command query in my original selection with no luck any ideas?got it resolved thank you.|||In the record selection for your Crystal Report (http://www.shelko.com) you can use a formula similar to:

{myDate} >= ({?Start Date}+14)

Publishing to a remote SSL server

I've set up SQL Reports in 'https://www.projects.com/reports' and added a
reports project to a solution. I used the reports manager to add a folder in
which to deploy the reports, but can't figure out where it is on the server.
When I try to deploy a report to 'https://www.projects.com/reportserver' I
get the following error: 'A connection can not be made to the report server
https://www.projects.com/ReportServer'. Any help to do the following:
1. Set up a folder on the server to deploy the datasource and reports so I
can xcopy
2. Be able to make a connection when I attempt to deploy a report from
VS.NET.
Would be appreciated.
Thanks.
DanI resolved this problem by first installing the data source then the report.
The report runs on the local server, but any attempt to run the report or
sample reports over the internet gives the error: 'Cannot find server or DNS
Error'. I'm publishing behind ISA 2004. Any suggestions?
Thanks.
Dan
"Dan Slaby" <dls@.newsgroup.nospam> wrote in message
news:ucM%23rdOjFHA.3568@.tk2msftngp13.phx.gbl...
> I've set up SQL Reports in 'https://www.projects.com/reports' and added a
> reports project to a solution. I used the reports manager to add a folder
> in which to deploy the reports, but can't figure out where it is on the
> server. When I try to deploy a report to
> 'https://www.projects.com/reportserver' I get the following error: 'A
> connection can not be made to the report server
> https://www.projects.com/ReportServer'. Any help to do the following:
> 1. Set up a folder on the server to deploy the datasource and reports so I
> can xcopy
> 2. Be able to make a connection when I attempt to deploy a report from
> VS.NET.
> Would be appreciated.
> Thanks.
> Dan
>|||Hello,
I'd like to confirm that both report server and SQL server are behind ISA
2004.
Please note that Windows authentication is not supported via Internet
because Kerbose/NTLM authentication need open too many ports via firewall
which is not proper for security purpose.
If you want to run the report over the internet, you may need to enable
anonymous access. You need to configure via report manager to enable
Iusr_<computername> account to have the proper permission to the proper
roles such as browser/content manager etc.
I suggest that you perform the following steps to narrow down the issue:
1. Run the report internally from another client computer with anonymous
access.
If the user can run the report internally successfully with anonymous
access, you may need to check the configuration of the ISA server.
To enable Anonymous Access to work with SQL Server Reporting Services,
enable Anonymous Access under Directory Security in IIS and set the default
account to IWAM_machinename
NOTE: By default SQL Server Reporting Services uses the IWAM_machinename
account to connect.
I hope the information is helpful.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.

Publishing subreports

One of my reports uses a subreport. I use a script that runs under RS.EXE to
publish the reports, with the result that the subreport appears in the list
view where the user may be tempted to go in and try to run it, even though
it's not intended for stand-alone use.
I can hide it by going to Properties/General and checking off "Hide in list
view", but I would prefer to make the setup completely automatic.
Is there any way to set "Hide in list view" directly from the script?
Thanks,
PeterSure. Have a look at the scripts generated by Reporting Services Scripter
for a hidden report
http://www.sqldbatips.com/showarticle.asp?ID=62
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"jpstewart" <jpeterstewart@.hotmail.com.nospam> wrote in message
news:399E98E6-3543-4204-A9F6-484A1C527D99@.microsoft.com...
> One of my reports uses a subreport. I use a script that runs under RS.EXE
> to
> publish the reports, with the result that the subreport appears in the
> list
> view where the user may be tempted to go in and try to run it, even though
> it's not intended for stand-alone use.
> I can hide it by going to Properties/General and checking off "Hide in
> list
> view", but I would prefer to make the setup completely automatic.
> Is there any way to set "Hide in list view" directly from the script?
> Thanks,
> Peter
>|||Did you get an idea of how to access Hide in List view property programatically?. I am also strugling with the same problem. Please send me the reply to my gmail
From http://www.developmentnow.com/g/115_2005_8_0_0_574025/Publishing-subreports.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com

Publishing reports to different versions

I have Visual Studio 2005 and Reporting Services 2005 on my client development machine.

I want to publish the reports to an SQL Server 2000 with Reporting Services 2000 server, is this possible?

I get the following error message:

The report definition is not valid. Please verify that the report definition uses the current report definition namespace (i.e. ‘http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition’). (rsNotACurrentReportDefinition) Get Online Help

Thanks.

Bruce

Unfortunately, you will not be able to use the 2005 report designer to publish directly to a 2000 report server. This is due to the fact that the RDL's (Report Definitions) created are different between Report Server versions. You can however use the 2000 report designer to publish to a 2005 server, as it support auto-upgrade of the reports.

Thanks, Jon

Publishing from RS 2000 to RS 2005

I want to publishing many reports from RS 2000 to RS 2005. These reports have
several server parameters. In order to do it I have used the utility
RSScripter, but this application produces .rss and .cmd files for RS 2000. I
have modified their code to do to function them to publish to RS 2005. Does
exist another version of this utility to do this migration? Does exist
another manner to solve this issue?
Many thanksI prefer to deploy using the report designer. The utility you are speaking
of has a version that supports both 2000 and 2005.
http://www.sqldbatips.com/showarticle.asp?ID=62
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
news:40E876D4-4EE6-4236-A3B3-03EA3960FE3E@.microsoft.com...
>I want to publishing many reports from RS 2000 to RS 2005. These reports
>have
> several server parameters. In order to do it I have used the utility
> RSScripter, but this application produces .rss and .cmd files for RS 2000.
> I
> have modified their code to do to function them to publish to RS 2005.
> Does
> exist another version of this utility to do this migration? Does exist
> another manner to solve this issue?
> Many thanks|||I have tried the version 2.0.0.10 and I have downloaded the next version of
RSScripter. When I launch the cmd files produces for RS 2000 to publish to RS
2005 I have some errors if before I don't modified the scripts. In particular,
I can lost the server parameters of RS 2000 reports. Moreover, there are two
different manners between RS 2000 and RS 2005 to set the data source for a
report. I don't see any option inside RSScripter to produce rdl, rds and cmd
files to RS 2005 but reading RS 2000 reports.
"Bruce L-C [MVP]" wrote:
> I prefer to deploy using the report designer. The utility you are speaking
> of has a version that supports both 2000 and 2005.
> http://www.sqldbatips.com/showarticle.asp?ID=62
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
> news:40E876D4-4EE6-4236-A3B3-03EA3960FE3E@.microsoft.com...
> >I want to publishing many reports from RS 2000 to RS 2005. These reports
> >have
> > several server parameters. In order to do it I have used the utility
> > RSScripter, but this application produces .rss and .cmd files for RS 2000.
> > I
> > have modified their code to do to function them to publish to RS 2005.
> > Does
> > exist another version of this utility to do this migration? Does exist
> > another manner to solve this issue?
> >
> > Many thanks
>
>|||Ahh, it probably works mostly for moving between the same versions.
If you are going between RS 2000 and RS 2005 I suggest you do not do it this
way. Although RS 2005 will run RS 2000 reports I recommend that you convert
your reports to RS 2005 first. I had a few weird little problems that went
away once I did this.
To convert you have to pull up the report in RS2005 report designer, let it
convert and then save. It is a little bit of a pain but the process is
quick. I kept a copy of my RS 2000 version reports around.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
news:6ED58430-5A33-4DC5-B5EE-1C7FB9F1D8D5@.microsoft.com...
>I have tried the version 2.0.0.10 and I have downloaded the next version of
> RSScripter. When I launch the cmd files produces for RS 2000 to publish to
> RS
> 2005 I have some errors if before I don't modified the scripts. In
> particular,
> I can lost the server parameters of RS 2000 reports. Moreover, there are
> two
> different manners between RS 2000 and RS 2005 to set the data source for a
> report. I don't see any option inside RSScripter to produce rdl, rds and
> cmd
> files to RS 2005 but reading RS 2000 reports.
>
> "Bruce L-C [MVP]" wrote:
>> I prefer to deploy using the report designer. The utility you are
>> speaking
>> of has a version that supports both 2000 and 2005.
>> http://www.sqldbatips.com/showarticle.asp?ID=62
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
>> news:40E876D4-4EE6-4236-A3B3-03EA3960FE3E@.microsoft.com...
>> >I want to publishing many reports from RS 2000 to RS 2005. These reports
>> >have
>> > several server parameters. In order to do it I have used the utility
>> > RSScripter, but this application produces .rss and .cmd files for RS
>> > 2000.
>> > I
>> > have modified their code to do to function them to publish to RS 2005.
>> > Does
>> > exist another version of this utility to do this migration? Does exist
>> > another manner to solve this issue?
>> >
>> > Many thanks
>>

Publishing Crystal Reports in Web

Hi,

I'm using CR9. Planning to publish them in the web. Used ASP to publish them

But Is it necessary to instal CR 9 in the server.

My CreateObject("CrystalRuntime.Application.9") Failed because of Invalid ProgId Error.

Have any idea pls tell me,

ThanksI don't know anything about Crystal Reports for the Web, but I think Crystal Enterprise was created for that. Try a search on that for your answer.|||It's working. Installed crystal reports and its corresponding web components.

Anyway, thanks for your response

Publishing CR .rpt file into SSR

I have some crystal reports .rpt files that I'd like to publish to users via
the SSR menu. Is there anyway to do this?
THanks
--
DougThere is nothing built into the product to convert crystal reports to RS
reports. There is at least one consulting company that will convert reports
for you.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Doug Little" <littldo@.yahoo.com.(donotspam)> wrote in message
news:615C9F22-3E66-403B-A762-E3C8D08E4C43@.microsoft.com...
>I have some crystal reports .rpt files that I'd like to publish to users
>via
> the SSR menu. Is there anyway to do this?
> THanks
> --
> Doug

Published Reports in /ReportServer, not in /Reports

I can publish reports to http://myserver/ReportServer just fine, but
when I try to view them through http://myserver/Reports, nothing is
there...no folders, no reports, not even the ability to access the
security. Can you help me?Make sure you are not running Reports website in anonymous.
Also, read up on Roles in RS. You might need to logon as someone in the
adminstrators group (the local machine group). That group automatically is
in a role that will allow you to setup other users/groups into appropriate
roles. However, if you are anonymous then no matter how you log on you will
not have the rights to do this (because everyone is anonymous).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<robbiesmith79@.gmail.com> wrote in message
news:1141055431.139441.263650@.t39g2000cwt.googlegroups.com...
>I can publish reports to http://myserver/ReportServer just fine, but
> when I try to view them through http://myserver/Reports, nothing is
> there...no folders, no reports, not even the ability to access the
> security. Can you help me?
>|||As I bang my head into the computer shouting "Doh!"... I had annoymous
access turned on on the Reports part.
Thanks Bruce!|||hi mr smith how have you been i was wondering if you got the message that i sent you well if you didnt the message was that i am a black belt canidi for 08 i cant believe i have come so far with the help of so many including you well i hope to hear from you soon if you want to give me a call some time my house number is 1512-295-4847 or my cell phone 1512-396-7786 well like to talk to you soon but bye for now
Sincerely
Robert Hunsucke
From http://www.developmentnow.com/g/115_2006_2_0_0_706496/Published-Reports-in-ReportServer-not-in-Reports.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com

Published Reports -- URGENT

Hi
I am trying to supply input parameters to a report from an aspx page. I tried many methods , but none seem to be working.
Can anyone suggest how I can work with parameterized reports from code?
Moreover , Do I have to publish a report to be able to supply Report Parameters from the code?
Thanks
--
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.You always have to publish a report to the server before you can use it. Not
sure what you are trying to do.
Are you using URL Access or the SOAP API? Supplying paramters to each is
described in BOL.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
news:uOaURsuZEHA.3112@.TK2MSFTNGP09.phx.gbl...
> Hi
> I am trying to supply input parameters to a report from an aspx page. I
> tried many methods , but none seem to be working.
> Can anyone suggest how I can work with parameterized reports from code?
> Moreover , Do I have to publish a report to be able to supply Report
> Parameters from the code?
> Thanks
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
> supports Post Alerts, Ratings, and Searching.|||Hi
This is what i think.
1) in your .aspx page, you would have a hyperlink or something that links to the targeted report Eg:
<a href="http://links.10026.com/?link=http://localhost/Reportserver?/report1¶m1=123" >Go to report1</a>
2) In report1.rdl, you would have created a parameter called param1.
3) You definitely need to publish your report. You do this through the report manager: upload.
Chiara
"SqlJunkies User" wrote:
> Hi
> I am trying to supply input parameters to a report from an aspx page. I tried many methods , but none seem to be working.
> Can anyone suggest how I can work with parameterized reports from code?
> Moreover , Do I have to publish a report to be able to supply Report Parameters from the code?
> Thanks
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.
>

Publish to Multiple folders

Is it possible to publish reports in a project to different target folders?
It seem like all of the reports must be sent to the same folder and then
moved, which is quite annoying. Am I missing something?
TIA
DeanI split the reports in the development environment to different projects.
Each project goes to a different folder.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dean" <deanl144@.hotmail.com.nospam> wrote in message
news:OMxvOJpCIHA.748@.TK2MSFTNGP04.phx.gbl...
> Is it possible to publish reports in a project to different target
> folders? It seem like all of the reports must be sent to the same folder
> and then moved, which is quite annoying. Am I missing something?
> TIA
> Dean
>|||I agree that this is rather annoying.
If you have separate projects for each report how do you handle Shared
Data Sources? For instance, if you have 5 reports in 5 individual
projects all using the same shared data source, and that data source
changes, do you need to update all 5 projects, otherwise one will over
write the other?
On Oct 9, 10:33 am, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> I split the reports in the development environment to different projects.
> Each project goes to a different folder.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Dean" <deanl...@.hotmail.com.nospam> wrote in message
> news:OMxvOJpCIHA.748@.TK2MSFTNGP04.phx.gbl...
> > Is it possible to publish reports in a project to different target
> > folders? It seem like all of the reports must be sent to the same folder
> > and then moved, which is quite annoying. Am I missing something?
> > TIA
> > Dean|||I name the shared data source the same name in each project. Yes, I have to
update the data sources in each project but I only have to do it once on the
server. In RS 2005 you have the option of putting all your shared data
sources in one place which I have done. All the folders use the same shared
data sources.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Matt Penner" <mattpenner2007@.gmail.com> wrote in message
news:1191966220.593999.117590@.g4g2000hsf.googlegroups.com...
>I agree that this is rather annoying.
> If you have separate projects for each report how do you handle Shared
> Data Sources? For instance, if you have 5 reports in 5 individual
> projects all using the same shared data source, and that data source
> changes, do you need to update all 5 projects, otherwise one will over
> write the other?
> On Oct 9, 10:33 am, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> wrote:
>> I split the reports in the development environment to different projects.
>> Each project goes to a different folder.
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Dean" <deanl...@.hotmail.com.nospam> wrote in message
>> news:OMxvOJpCIHA.748@.TK2MSFTNGP04.phx.gbl...
>> > Is it possible to publish reports in a project to different target
>> > folders? It seem like all of the reports must be sent to the same
>> > folder
>> > and then moved, which is quite annoying. Am I missing something?
>> > TIA
>> > Dean
>|||Ah, thanks.
On Oct 10, 6:52 am, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> I name the shared data source the same name in each project. Yes, I have to
> update the data sources in each project but I only have to do it once on the
> server. In RS 2005 you have the option of putting all your shared data
> sources in one place which I have done. All the folders use the same shared
> data sources.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Matt Penner" <mattpenner2...@.gmail.com> wrote in message
> news:1191966220.593999.117590@.g4g2000hsf.googlegroups.com...
> >I agree that this is rather annoying.
> > If you have separate projects for each report how do you handle Shared
> > Data Sources? For instance, if you have 5 reports in 5 individual
> > projects all using the same shared data source, and that data source
> > changes, do you need to update all 5 projects, otherwise one will over
> > write the other?
> > On Oct 9, 10:33 am, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> > wrote:
> >> I split the reports in the development environment to different projects.
> >> Each project goes to a different folder.
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >> "Dean" <deanl...@.hotmail.com.nospam> wrote in message
> >>news:OMxvOJpCIHA.748@.TK2MSFTNGP04.phx.gbl...
> >> > Is it possible to publish reports in a project to different target
> >> > folders? It seem like all of the reports must be sent to the same
> >> > folder
> >> > and then moved, which is quite annoying. Am I missing something?
> >> > TIA
> >> > Dean

Publish reports to SQL 2000 RS using VS2005

We are migrating to SQL Server 2005 (and also RS shipped with SQL 2005) but
in the middle of the process we have still some servers still not upgraded
(and running SQL Server 2000 and RS2000).
Can we deploy reports to RS servers running SQL Server 2000 using Visual
Studio 2005? It seems we cannot becasue we receive the following error
message. Is any workaround to this or do we need to mantain a copy of both
RS2000 and RS2005 rdl files and deploy each group of them using VS2003 and
VS2005 respectively? This is somewhat repeat the same job twice, and might
lead to mistakes and differences between the same file of each version.
The error messages are in spanish but an approximated translation is
provided (It probably does not match the real error message in native
english).
Thanks a lot.
===================================
No se pudo establecer una conexión al servidor de informes
https://www.mydomain.com/ReportServer. (Diseñador de informes de Microsoft)
A connection to reports server at https://www.mydomain.com/ReportServer
could not be stablished (Microsoft Form Designer)
===================================
Error al intentar conectar con el servidor de informes. Compruebe la
información de conexión y que la versión del servidor de informes sea
compatible. (Microsoft.ReportingServices.Designer)
An error occurred while trying to connect to reports server. Check the
connection information and reports server version be compatable
(Microsoft.ReportingServices.Designer)
--
Ubicación del programa:
en
Microsoft.SqlServer.ReportingServices2005.RSConnection.MissingEndpointException.ThrowIfEndpointMissing(WebException
e)
en
Microsoft.SqlServer.ReportingServices2005.RSConnection.GetItemType(String
Item)
en
Microsoft.ReportDesigner.Project.ReportServiceClient.GetItemType(String
item)
en Microsoft.ReportDesigner.Project.ReportServiceClient.CheckAuthorized()
en
Microsoft.ReportDesigner.Project.ReportClientManager.GetCredentials(String
url)
en Microsoft.ReportDesigner.Project.ReportProjectDeployer.PrepareDeploy()
===================================
Error de la solicitud con el código de estado HTTP 404: Not Found.
(System.Web.Services)
--
Ubicación del programa:
en
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
message, WebResponse response, Stream responseStream, Boolean asyncCall)
en System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters)
en
Microsoft.SqlServer.ReportingServices2005.ReportingService2005.GetItemType(String
Item)
en
Microsoft.SqlServer.ReportingServices2005.RSConnection.GetItemType(String
Item)You cannot deploy 2005 reports to RS 2000 server. However, you can deploy RS
2000 reports to a RS 2005 server. One caveat. When I did this I had a few
cases of some minor buggy behavior that went away when I converted to RS
2005. But, you might want to try that out.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"jagb" <jagb@.NOSPAM.com> wrote in message
news:utyRqIwfGHA.2456@.TK2MSFTNGP04.phx.gbl...
> We are migrating to SQL Server 2005 (and also RS shipped with SQL 2005)
> but in the middle of the process we have still some servers still not
> upgraded (and running SQL Server 2000 and RS2000).
> Can we deploy reports to RS servers running SQL Server 2000 using Visual
> Studio 2005? It seems we cannot becasue we receive the following error
> message. Is any workaround to this or do we need to mantain a copy of both
> RS2000 and RS2005 rdl files and deploy each group of them using VS2003 and
> VS2005 respectively? This is somewhat repeat the same job twice, and might
> lead to mistakes and differences between the same file of each version.
> The error messages are in spanish but an approximated translation is
> provided (It probably does not match the real error message in native
> english).
> Thanks a lot.
> ===================================> No se pudo establecer una conexión al servidor de informes
> https://www.mydomain.com/ReportServer. (Diseñador de informes de
> Microsoft)
> A connection to reports server at https://www.mydomain.com/ReportServer
> could not be stablished (Microsoft Form Designer)
> ===================================> Error al intentar conectar con el servidor de informes. Compruebe la
> información de conexión y que la versión del servidor de informes sea
> compatible. (Microsoft.ReportingServices.Designer)
> An error occurred while trying to connect to reports server. Check the
> connection information and reports server version be compatable
> (Microsoft.ReportingServices.Designer)
> --
> Ubicación del programa:
> en
> Microsoft.SqlServer.ReportingServices2005.RSConnection.MissingEndpointException.ThrowIfEndpointMissing(WebException
> e)
> en
> Microsoft.SqlServer.ReportingServices2005.RSConnection.GetItemType(String
> Item)
> en
> Microsoft.ReportDesigner.Project.ReportServiceClient.GetItemType(String
> item)
> en
> Microsoft.ReportDesigner.Project.ReportServiceClient.CheckAuthorized()
> en
> Microsoft.ReportDesigner.Project.ReportClientManager.GetCredentials(String
> url)
> en
> Microsoft.ReportDesigner.Project.ReportProjectDeployer.PrepareDeploy()
> ===================================> Error de la solicitud con el código de estado HTTP 404: Not Found.
> (System.Web.Services)
> --
> Ubicación del programa:
> en
> System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
> message, WebResponse response, Stream responseStream, Boolean asyncCall)
> en System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> methodName, Object[] parameters)
> en
> Microsoft.SqlServer.ReportingServices2005.ReportingService2005.GetItemType(String
> Item)
> en
> Microsoft.SqlServer.ReportingServices2005.RSConnection.GetItemType(String
> Item)
>

Publish Reports Server to Internet

Hi all,
I have an external IP for my server and I tried to connect it from out side,
I notice that the link address appear on Status bar is my localhost's name
link ... and that's why it can be accessed to view reports. It just work if I
re-config my IP setting following external IP. Who can expalin me or show me
some addresses to study more about this problem ?
--
Thnx lots,
NgocYour local machine has its IP address and the server has its IP address
accessible from the Internet? Assuming you have configured security so that
the server is accessible from outside, you just need to do
http://<serverIPaddress>/Reports or https://<serverIPaddress>/Reports, right?
If you are doing http://<yourmachine>/Reports, then you will see the local
report server, unless you have used rsconfig.exe to point your local server
to the external server URL. Books Online has details on using rsconfig.exe.
Charles Kangai, MCDBA, MCT
"Phi Ngoc" wrote:
> Hi all,
> I have an external IP for my server and I tried to connect it from out side,
> I notice that the link address appear on Status bar is my localhost's name
> link ... and that's why it can be accessed to view reports. It just work if I
> re-config my IP setting following external IP. Who can expalin me or show me
> some addresses to study more about this problem ?
> --
> Thnx lots,
> Ngoc|||I am having the same problem where I go here http://(fqdn.external.name)
/Reports
The reports are viewable externally, but if I try to export them it reverts
to the computer name (Which happens to be MISERY) like this
http://misery/Reports/Pages/Reports.aspx..etc.etc
Does anyone know how to change this?
Thanks.
--
Message posted via http://www.sqlmonster.com|||Open the RSWebApplication.config file and check the URL inside the
<ReportServerURL> element. Do the same with RSReportServer.config file. The
files are located in the folders <SQL Server Installation>\Reporting
Services\ReportManager and <SQL Server Installation>\Reporting
Services\ReportServer, respectively.
Charles Kangai, MCDBA, MCT
"David Benedict via SQLMonster.com" wrote:
> I am having the same problem where I go here http://(fqdn.external.name)
> /Reports
> The reports are viewable externally, but if I try to export them it reverts
> to the computer name (Which happens to be MISERY) like this
> http://misery/Reports/Pages/Reports.aspx..etc.etc
> Does anyone know how to change this?
> Thanks.
> --
> Message posted via http://www.sqlmonster.com
>