Importing Error: reporting

Showing posts with label reporting. Show all posts

Friday, March 30, 2012

Report Error when 2 pages for multiple records

We have a web app, built in .Net, with reporting services as our reporting
tool. The problem we are having is when we have a report that goes to
numerous people and the report is 2 pages long. When we make it 1 page,
legal size, it works fine (avg records are 500-900). When this report is
generated it is created in a pdf format. I can run it on report services
manager and in the viewer it takes approx 10 secs or less to run and render,
but when we create the pdf it spikes the processor up to 90% and if it's a 2
page report it generates an error.PDF's take significantly longer than HTML but it surprises me that a 2 page
report you see much of a difference. Do you have any service packs
installed. If not, my advice is to install SP2.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"bssolutions" <bssolutions@.discussions.microsoft.com> wrote in message
news:BBA2388F-E062-4368-987A-62CD9298BD14@.microsoft.com...
> We have a web app, built in .Net, with reporting services as our reporting
> tool. The problem we are having is when we have a report that goes to
> numerous people and the report is 2 pages long. When we make it 1 page,
> legal size, it works fine (avg records are 500-900). When this report is
> generated it is created in a pdf format. I can run it on report services
> manager and in the viewer it takes approx 10 secs or less to run and
> render,
> but when we create the pdf it spikes the processor up to 90% and if it's a
> 2
> page report it generates an error.|||I have all of the service packs installed. This is a 2 page report that
generates approx 950 pages. I have similar reports, but set to legal single
page, that generate over 1000 pages in pdf. The error message I get is:
"Server Error in '/' Application.
The underlying connection was closed: An unexpected error occurred on a
receive.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.
Exception Details: System.Net.WebException: The underlying connection was
closed: An unexpected error occurred on a receive.
Source Error:
An unhandled exception was generated during the execution of the current web
request. Information regarding the origin and location of the exception can
be identified using the exception stack trace below.
Stack Trace:
[WebException: The underlying connection was closed: An unexpected error
occurred on a receive.]
System.Web.Services.Protocols.WebClientProtocol.GetWebResponse(WebReques
t request) +58
System.Web.Services.Protocols.HttpWebClientProtocol.GetWebResponse(WebRe
quest request) +5
System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters) +183
LAMS.SQLReportServer.ReportingService.Render(String Report, String
Format, String HistoryID, String DeviceInfo, ParameterValue[] Parameters,
DataSourceCredentials[] Credentials, String ShowHideToggle, String& Encoding,
String& MimeType, ParameterValue[]& ParametersUsed, Warning[]& Warnings,
String[]& StreamIds) +141
LAMS.ReportViewer.RenderPDFReport() +618
LAMS.ReportViewer.Page_Load(Object sender, EventArgs e) +88
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +750"
"Bruce L-C [MVP]" wrote:
> PDF's take significantly longer than HTML but it surprises me that a 2 page
> report you see much of a difference. Do you have any service packs
> installed. If not, my advice is to install SP2.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "bssolutions" <bssolutions@.discussions.microsoft.com> wrote in message
> news:BBA2388F-E062-4368-987A-62CD9298BD14@.microsoft.com...
> > We have a web app, built in .Net, with reporting services as our reporting
> > tool. The problem we are having is when we have a report that goes to
> > numerous people and the report is 2 pages long. When we make it 1 page,
> > legal size, it works fine (avg records are 500-900). When this report is
> > generated it is created in a pdf format. I can run it on report services
> > manager and in the viewer it takes approx 10 secs or less to run and
> > render,
> > but when we create the pdf it spikes the processor up to 90% and if it's a
> > 2
> > page report it generates an error.
>
>|||OK, we had a failure to communicate. You said a 2 page report and I thought
it was 2 pages long. You mean 2 pages per record.
RS renders everything in RAM. Formats make a big difference in CPU
utilizations. CSV, HTML are very fast. PDF and Excel are much slower and
much much more intensive in resources required. My personal feeling is that
when you are talking about that many pages it is an inappropriate use of RS.
It is just not designed to be outputting 1000 pages of PDF. Users cannot
look at that many pages anyway. You should consider drill through technique.
Show the users what they need to see. I do know that sometimes users need to
pull data into another program but that is not what PDF format is used for.
Excel is another matter (although Excel can't handle 100,000 rows either).
For Excel you could use CSV to get around this. For PDF there is no work
around. More RAM helps but you really are overloading the server when you
are doing this.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"bssolutions" <bssolutions@.discussions.microsoft.com> wrote in message
news:790D7C48-1AB7-4F2A-A1C3-A1CF679B9B52@.microsoft.com...
>I have all of the service packs installed. This is a 2 page report that
> generates approx 950 pages. I have similar reports, but set to legal
> single
> page, that generate over 1000 pages in pdf. The error message I get is:
> "Server Error in '/' Application.
> The underlying connection was closed: An unexpected error occurred on a
> receive.
> Description: An unhandled exception occurred during the execution of the
> current web request. Please review the stack trace for more information
> about
> the error and where it originated in the code.
> Exception Details: System.Net.WebException: The underlying connection was
> closed: An unexpected error occurred on a receive.
> Source Error:
> An unhandled exception was generated during the execution of the current
> web
> request. Information regarding the origin and location of the exception
> can
> be identified using the exception stack trace below.
> Stack Trace:
> [WebException: The underlying connection was closed: An unexpected error
> occurred on a receive.]
> System.Web.Services.Protocols.WebClientProtocol.GetWebResponse(WebReques
> t request) +58
> System.Web.Services.Protocols.HttpWebClientProtocol.GetWebResponse(WebRe
> quest request) +5
> System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> methodName, Object[] parameters) +183
> LAMS.SQLReportServer.ReportingService.Render(String Report, String
> Format, String HistoryID, String DeviceInfo, ParameterValue[] Parameters,
> DataSourceCredentials[] Credentials, String ShowHideToggle, String&
> Encoding,
> String& MimeType, ParameterValue[]& ParametersUsed, Warning[]& Warnings,
> String[]& StreamIds) +141
> LAMS.ReportViewer.RenderPDFReport() +618
> LAMS.ReportViewer.Page_Load(Object sender, EventArgs e) +88
> System.Web.UI.Control.OnLoad(EventArgs e) +67
> System.Web.UI.Control.LoadRecursive() +35
> System.Web.UI.Page.ProcessRequestMain() +750"
> "Bruce L-C [MVP]" wrote:
>> PDF's take significantly longer than HTML but it surprises me that a 2
>> page
>> report you see much of a difference. Do you have any service packs
>> installed. If not, my advice is to install SP2.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "bssolutions" <bssolutions@.discussions.microsoft.com> wrote in message
>> news:BBA2388F-E062-4368-987A-62CD9298BD14@.microsoft.com...
>> > We have a web app, built in .Net, with reporting services as our
>> > reporting
>> > tool. The problem we are having is when we have a report that goes to
>> > numerous people and the report is 2 pages long. When we make it 1
>> > page,
>> > legal size, it works fine (avg records are 500-900). When this report
>> > is
>> > generated it is created in a pdf format. I can run it on report
>> > services
>> > manager and in the viewer it takes approx 10 secs or less to run and
>> > render,
>> > but when we create the pdf it spikes the processor up to 90% and if
>> > it's a
>> > 2
>> > page report it generates an error.
>>|||Thanks for the input. The only problem is this is our leasing application
and we have to print mass batch of renewals once a year. I am thinking of
setting it on a schedule but that would remove a data range filter that is in
place and is changable by the user. Any suggestions?
"Bruce L-C [MVP]" wrote:
> OK, we had a failure to communicate. You said a 2 page report and I thought
> it was 2 pages long. You mean 2 pages per record.
> RS renders everything in RAM. Formats make a big difference in CPU
> utilizations. CSV, HTML are very fast. PDF and Excel are much slower and
> much much more intensive in resources required. My personal feeling is that
> when you are talking about that many pages it is an inappropriate use of RS.
> It is just not designed to be outputting 1000 pages of PDF. Users cannot
> look at that many pages anyway. You should consider drill through technique.
> Show the users what they need to see. I do know that sometimes users need to
> pull data into another program but that is not what PDF format is used for.
> Excel is another matter (although Excel can't handle 100,000 rows either).
> For Excel you could use CSV to get around this. For PDF there is no work
> around. More RAM helps but you really are overloading the server when you
> are doing this.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "bssolutions" <bssolutions@.discussions.microsoft.com> wrote in message
> news:790D7C48-1AB7-4F2A-A1C3-A1CF679B9B52@.microsoft.com...
> >I have all of the service packs installed. This is a 2 page report that
> > generates approx 950 pages. I have similar reports, but set to legal
> > single
> > page, that generate over 1000 pages in pdf. The error message I get is:
> >
> > "Server Error in '/' Application.
> > The underlying connection was closed: An unexpected error occurred on a
> > receive.
> > Description: An unhandled exception occurred during the execution of the
> > current web request. Please review the stack trace for more information
> > about
> > the error and where it originated in the code.
> > Exception Details: System.Net.WebException: The underlying connection was
> > closed: An unexpected error occurred on a receive.
> > Source Error:
> > An unhandled exception was generated during the execution of the current
> > web
> > request. Information regarding the origin and location of the exception
> > can
> > be identified using the exception stack trace below.
> >
> > Stack Trace:
> > [WebException: The underlying connection was closed: An unexpected error
> > occurred on a receive.]
> > System.Web.Services.Protocols.WebClientProtocol.GetWebResponse(WebReques
> > t request) +58
> > System.Web.Services.Protocols.HttpWebClientProtocol.GetWebResponse(WebRe
> > quest request) +5
> > System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> > methodName, Object[] parameters) +183
> > LAMS.SQLReportServer.ReportingService.Render(String Report, String
> > Format, String HistoryID, String DeviceInfo, ParameterValue[] Parameters,
> > DataSourceCredentials[] Credentials, String ShowHideToggle, String&
> > Encoding,
> > String& MimeType, ParameterValue[]& ParametersUsed, Warning[]& Warnings,
> > String[]& StreamIds) +141
> > LAMS.ReportViewer.RenderPDFReport() +618
> > LAMS.ReportViewer.Page_Load(Object sender, EventArgs e) +88
> > System.Web.UI.Control.OnLoad(EventArgs e) +67
> > System.Web.UI.Control.LoadRecursive() +35
> > System.Web.UI.Page.ProcessRequestMain() +750"
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> PDF's take significantly longer than HTML but it surprises me that a 2
> >> page
> >> report you see much of a difference. Do you have any service packs
> >> installed. If not, my advice is to install SP2.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "bssolutions" <bssolutions@.discussions.microsoft.com> wrote in message
> >> news:BBA2388F-E062-4368-987A-62CD9298BD14@.microsoft.com...
> >> > We have a web app, built in .Net, with reporting services as our
> >> > reporting
> >> > tool. The problem we are having is when we have a report that goes to
> >> > numerous people and the report is 2 pages long. When we make it 1
> >> > page,
> >> > legal size, it works fine (avg records are 500-900). When this report
> >> > is
> >> > generated it is created in a pdf format. I can run it on report
> >> > services
> >> > manager and in the viewer it takes approx 10 secs or less to run and
> >> > render,
> >> > but when we create the pdf it spikes the processor up to 90% and if
> >> > it's a
> >> > 2
> >> > page report it generates an error.
> >>
> >>
> >>
>
>|||If you can have parameters that allows you to do a subset then schedule the
report multiple times just varying the parameter and print say 100 pages at
a time.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"bssolutions" <bssolutions@.discussions.microsoft.com> wrote in message
news:6B4C566B-C41C-49FD-BF58-2FCD7B9656E3@.microsoft.com...
> Thanks for the input. The only problem is this is our leasing application
> and we have to print mass batch of renewals once a year. I am thinking of
> setting it on a schedule but that would remove a data range filter that is
> in
> place and is changable by the user. Any suggestions?
> "Bruce L-C [MVP]" wrote:
>> OK, we had a failure to communicate. You said a 2 page report and I
>> thought
>> it was 2 pages long. You mean 2 pages per record.
>> RS renders everything in RAM. Formats make a big difference in CPU
>> utilizations. CSV, HTML are very fast. PDF and Excel are much slower and
>> much much more intensive in resources required. My personal feeling is
>> that
>> when you are talking about that many pages it is an inappropriate use of
>> RS.
>> It is just not designed to be outputting 1000 pages of PDF. Users cannot
>> look at that many pages anyway. You should consider drill through
>> technique.
>> Show the users what they need to see. I do know that sometimes users need
>> to
>> pull data into another program but that is not what PDF format is used
>> for.
>> Excel is another matter (although Excel can't handle 100,000 rows
>> either).
>> For Excel you could use CSV to get around this. For PDF there is no work
>> around. More RAM helps but you really are overloading the server when you
>> are doing this.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "bssolutions" <bssolutions@.discussions.microsoft.com> wrote in message
>> news:790D7C48-1AB7-4F2A-A1C3-A1CF679B9B52@.microsoft.com...
>> >I have all of the service packs installed. This is a 2 page report that
>> > generates approx 950 pages. I have similar reports, but set to legal
>> > single
>> > page, that generate over 1000 pages in pdf. The error message I get
>> > is:
>> >
>> > "Server Error in '/' Application.
>> > The underlying connection was closed: An unexpected error occurred on a
>> > receive.
>> > Description: An unhandled exception occurred during the execution of
>> > the
>> > current web request. Please review the stack trace for more information
>> > about
>> > the error and where it originated in the code.
>> > Exception Details: System.Net.WebException: The underlying connection
>> > was
>> > closed: An unexpected error occurred on a receive.
>> > Source Error:
>> > An unhandled exception was generated during the execution of the
>> > current
>> > web
>> > request. Information regarding the origin and location of the exception
>> > can
>> > be identified using the exception stack trace below.
>> >
>> > Stack Trace:
>> > [WebException: The underlying connection was closed: An unexpected
>> > error
>> > occurred on a receive.]
>> > System.Web.Services.Protocols.WebClientProtocol.GetWebResponse(WebReques
>> > t request) +58
>> > System.Web.Services.Protocols.HttpWebClientProtocol.GetWebResponse(WebRe
>> > quest request) +5
>> > System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
>> > methodName, Object[] parameters) +183
>> > LAMS.SQLReportServer.ReportingService.Render(String Report, String
>> > Format, String HistoryID, String DeviceInfo, ParameterValue[]
>> > Parameters,
>> > DataSourceCredentials[] Credentials, String ShowHideToggle, String&
>> > Encoding,
>> > String& MimeType, ParameterValue[]& ParametersUsed, Warning[]&
>> > Warnings,
>> > String[]& StreamIds) +141
>> > LAMS.ReportViewer.RenderPDFReport() +618
>> > LAMS.ReportViewer.Page_Load(Object sender, EventArgs e) +88
>> > System.Web.UI.Control.OnLoad(EventArgs e) +67
>> > System.Web.UI.Control.LoadRecursive() +35
>> > System.Web.UI.Page.ProcessRequestMain() +750"
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> PDF's take significantly longer than HTML but it surprises me that a 2
>> >> page
>> >> report you see much of a difference. Do you have any service packs
>> >> installed. If not, my advice is to install SP2.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "bssolutions" <bssolutions@.discussions.microsoft.com> wrote in message
>> >> news:BBA2388F-E062-4368-987A-62CD9298BD14@.microsoft.com...
>> >> > We have a web app, built in .Net, with reporting services as our
>> >> > reporting
>> >> > tool. The problem we are having is when we have a report that goes
>> >> > to
>> >> > numerous people and the report is 2 pages long. When we make it 1
>> >> > page,
>> >> > legal size, it works fine (avg records are 500-900). When this
>> >> > report
>> >> > is
>> >> > generated it is created in a pdf format. I can run it on report
>> >> > services
>> >> > manager and in the viewer it takes approx 10 secs or less to run and
>> >> > render,
>> >> > but when we create the pdf it spikes the processor up to 90% and if
>> >> > it's a
>> >> > 2
>> >> > page report it generates an error.
>> >>
>> >>
>> >>
>>|||Thanks a bunch for the info Bruce.
"Bruce L-C [MVP]" wrote:
> If you can have parameters that allows you to do a subset then schedule the
> report multiple times just varying the parameter and print say 100 pages at
> a time.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "bssolutions" <bssolutions@.discussions.microsoft.com> wrote in message
> news:6B4C566B-C41C-49FD-BF58-2FCD7B9656E3@.microsoft.com...
> > Thanks for the input. The only problem is this is our leasing application
> > and we have to print mass batch of renewals once a year. I am thinking of
> > setting it on a schedule but that would remove a data range filter that is
> > in
> > place and is changable by the user. Any suggestions?
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> OK, we had a failure to communicate. You said a 2 page report and I
> >> thought
> >> it was 2 pages long. You mean 2 pages per record.
> >>
> >> RS renders everything in RAM. Formats make a big difference in CPU
> >> utilizations. CSV, HTML are very fast. PDF and Excel are much slower and
> >> much much more intensive in resources required. My personal feeling is
> >> that
> >> when you are talking about that many pages it is an inappropriate use of
> >> RS.
> >> It is just not designed to be outputting 1000 pages of PDF. Users cannot
> >> look at that many pages anyway. You should consider drill through
> >> technique.
> >> Show the users what they need to see. I do know that sometimes users need
> >> to
> >> pull data into another program but that is not what PDF format is used
> >> for.
> >> Excel is another matter (although Excel can't handle 100,000 rows
> >> either).
> >> For Excel you could use CSV to get around this. For PDF there is no work
> >> around. More RAM helps but you really are overloading the server when you
> >> are doing this.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "bssolutions" <bssolutions@.discussions.microsoft.com> wrote in message
> >> news:790D7C48-1AB7-4F2A-A1C3-A1CF679B9B52@.microsoft.com...
> >> >I have all of the service packs installed. This is a 2 page report that
> >> > generates approx 950 pages. I have similar reports, but set to legal
> >> > single
> >> > page, that generate over 1000 pages in pdf. The error message I get
> >> > is:
> >> >
> >> > "Server Error in '/' Application.
> >> > The underlying connection was closed: An unexpected error occurred on a
> >> > receive.
> >> > Description: An unhandled exception occurred during the execution of
> >> > the
> >> > current web request. Please review the stack trace for more information
> >> > about
> >> > the error and where it originated in the code.
> >> > Exception Details: System.Net.WebException: The underlying connection
> >> > was
> >> > closed: An unexpected error occurred on a receive.
> >> > Source Error:
> >> > An unhandled exception was generated during the execution of the
> >> > current
> >> > web
> >> > request. Information regarding the origin and location of the exception
> >> > can
> >> > be identified using the exception stack trace below.
> >> >
> >> > Stack Trace:
> >> > [WebException: The underlying connection was closed: An unexpected
> >> > error
> >> > occurred on a receive.]
> >> > System.Web.Services.Protocols.WebClientProtocol.GetWebResponse(WebReques
> >> > t request) +58
> >> > System.Web.Services.Protocols.HttpWebClientProtocol.GetWebResponse(WebRe
> >> > quest request) +5
> >> > System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> >> > methodName, Object[] parameters) +183
> >> > LAMS.SQLReportServer.ReportingService.Render(String Report, String
> >> > Format, String HistoryID, String DeviceInfo, ParameterValue[]
> >> > Parameters,
> >> > DataSourceCredentials[] Credentials, String ShowHideToggle, String&
> >> > Encoding,
> >> > String& MimeType, ParameterValue[]& ParametersUsed, Warning[]&
> >> > Warnings,
> >> > String[]& StreamIds) +141
> >> > LAMS.ReportViewer.RenderPDFReport() +618
> >> > LAMS.ReportViewer.Page_Load(Object sender, EventArgs e) +88
> >> > System.Web.UI.Control.OnLoad(EventArgs e) +67
> >> > System.Web.UI.Control.LoadRecursive() +35
> >> > System.Web.UI.Page.ProcessRequestMain() +750"
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> PDF's take significantly longer than HTML but it surprises me that a 2
> >> >> page
> >> >> report you see much of a difference. Do you have any service packs
> >> >> installed. If not, my advice is to install SP2.
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >> "bssolutions" <bssolutions@.discussions.microsoft.com> wrote in message
> >> >> news:BBA2388F-E062-4368-987A-62CD9298BD14@.microsoft.com...
> >> >> > We have a web app, built in .Net, with reporting services as our
> >> >> > reporting
> >> >> > tool. The problem we are having is when we have a report that goes
> >> >> > to
> >> >> > numerous people and the report is 2 pages long. When we make it 1
> >> >> > page,
> >> >> > legal size, it works fine (avg records are 500-900). When this
> >> >> > report
> >> >> > is
> >> >> > generated it is created in a pdf format. I can run it on report
> >> >> > services
> >> >> > manager and in the viewer it takes approx 10 secs or less to run and
> >> >> > render,
> >> >> > but when we create the pdf it spikes the processor up to 90% and if
> >> >> > it's a
> >> >> > 2
> >> >> > page report it generates an error.
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>sql

Report Designer VS. 2003 Interface Failure

Our current VS2003 installed on 2000 Sever sp4 and Reporting Service
will not longer interface.
When trying to open a report project we recieve the error "Th
application for Project XXX.rptproj is not installed" "Make sure th
application for project type (.rptproj) is installed".
Has anyone ever seen this error before or have any suggestions?
We have built a number of reports and deployed them, but we are n
longer able to open the project to make modifications. We are als
unable to create a new report project without receiving the sam
errorDid you install or remove any software recently? Did you try reinstalling
Report Designer?
--
Albert Yen
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"kucerakk" <kris.kucera@.ps-dot-net.no-spam.invalid> wrote in message
news:pr2dnce98v9d4BDfRVn_vg@.giganews.com...
> Our current VS2003 installed on 2000 Sever sp4 and Reporting Services
> will not longer interface.
> When trying to open a report project we recieve the error "The
> application for Project XXX.rptproj is not installed" "Make sure the
> application for project type (.rptproj) is installed".
> Has anyone ever seen this error before or have any suggestions?
> We have built a number of reports and deployed them, but we are no
> longer able to open the project to make modifications. We are also
> unable to create a new report project without receiving the same
> error.
>

Report designer not working

Hello everyone. I'm trying to work with Visual Basic 2005 Express Edition
and Reporting Services. I downloaded and installed sample project, but no
matter what I do I can not see reports in designer. They openning as xml
files only. Any idea?
Thank you, YuriSorry, please disregard my message. I forgot to install Microsoft SQL Server
2005 Express Edition Toolkit
"Yuri" <ykasan@.fojp.com> wrote in message
news:%23%23YP9oetGHA.1512@.TK2MSFTNGP03.phx.gbl...
> Hello everyone. I'm trying to work with Visual Basic 2005 Express Edition
> and Reporting Services. I downloaded and installed sample project, but no
> matter what I do I can not see reports in designer. They openning as xml
> files only. Any idea?
> Thank you, Yuri
>|||Sorry, toolkit is installed, but problem is still there. Any idea? Thank you
"Yuri" <ykasan@.fojp.com> wrote in message
news:%23%23YP9oetGHA.1512@.TK2MSFTNGP03.phx.gbl...
> Hello everyone. I'm trying to work with Visual Basic 2005 Express Edition
> and Reporting Services. I downloaded and installed sample project, but no
> matter what I do I can not see reports in designer. They openning as xml
> files only. Any idea?
> Thank you, Yuri
>|||Which kind of project you created? Can you see the Business Intelligence
Projects under the project types list in the Visaul Stadio?
"Yuri" <ykasan@.fojp.com> wrote in message
news:%23%23YP9oetGHA.1512@.TK2MSFTNGP03.phx.gbl...
> Hello everyone. I'm trying to work with Visual Basic 2005 Express Edition
> and Reporting Services. I downloaded and installed sample project, but no
> matter what I do I can not see reports in designer. They openning as xml
> files only. Any idea?
> Thank you, Yuri
>|||No, I see the all the usual templates and Reports For Windows Sample
Application.
This template was added after I run sample application from Microsoft
download.
"Patrick" <feng_online@.hotmail.com> wrote in message
news:%236U2vLitGHA.2036@.TK2MSFTNGP05.phx.gbl...
> Which kind of project you created? Can you see the Business Intelligence
> Projects under the project types list in the Visaul Stadio?
> "Yuri" <ykasan@.fojp.com> wrote in message
> news:%23%23YP9oetGHA.1512@.TK2MSFTNGP03.phx.gbl...
>> Hello everyone. I'm trying to work with Visual Basic 2005 Express Edition
>> and Reporting Services. I downloaded and installed sample project, but no
>> matter what I do I can not see reports in designer. They openning as xml
>> files only. Any idea?
>> Thank you, Yuri
>|||Thank you for fast response, Patrick.
Should I have a Business Int. template in my project templates?
I did install SQL 2005 toolkit for my Visual Basic Express.
"Patrick" <feng_online@.hotmail.com> wrote in message
news:%236U2vLitGHA.2036@.TK2MSFTNGP05.phx.gbl...
> Which kind of project you created? Can you see the Business Intelligence
> Projects under the project types list in the Visaul Stadio?
> "Yuri" <ykasan@.fojp.com> wrote in message
> news:%23%23YP9oetGHA.1512@.TK2MSFTNGP03.phx.gbl...
>> Hello everyone. I'm trying to work with Visual Basic 2005 Express Edition
>> and Reporting Services. I downloaded and installed sample project, but no
>> matter what I do I can not see reports in designer. They openning as xml
>> files only. Any idea?
>> Thank you, Yuri
>|||I am sorry. I never used this way. Both I installed in my machine are VS.net
and SQL Server 2005
"Yuriy" <ykasan@.fojp.com> wrote in message
news:OI6pZwjtGHA.2448@.TK2MSFTNGP06.phx.gbl...
> Thank you for fast response, Patrick.
> Should I have a Business Int. template in my project templates?
> I did install SQL 2005 toolkit for my Visual Basic Express.
> "Patrick" <feng_online@.hotmail.com> wrote in message
> news:%236U2vLitGHA.2036@.TK2MSFTNGP05.phx.gbl...
>> Which kind of project you created? Can you see the Business Intelligence
>> Projects under the project types list in the Visaul Stadio?
>> "Yuri" <ykasan@.fojp.com> wrote in message
>> news:%23%23YP9oetGHA.1512@.TK2MSFTNGP03.phx.gbl...
>> Hello everyone. I'm trying to work with Visual Basic 2005 Express
>> Edition and Reporting Services. I downloaded and installed sample
>> project, but no matter what I do I can not see reports in designer. They
>> openning as xml files only. Any idea?
>> Thank you, Yuri
>>
>sql

Wednesday, March 28, 2012

Report designer not in VS 2003

I have Reporting services 2000 (Version 8.00.1038.00) installed (installed with installation of MS CRM) and visual studio 2003 installed however, do not have the business intelligence report designer available. Where can I obtain the report designer addin? We don't have a RD 2000 CD. Is what I need available via download?

Thanks

Try getting the trial version of reporting services & installing the developer components. Not sure if these expire though. You may need to purchase a license for Reporting Services if you would like to use in a production environment. There doesn't appear to be a download for just the designer components for vs 2003, only 2005 Express.

http://www.microsoft.com/downloads/details.aspx?familyid=BA517C01-2E2F-4BC7-84AF-149B7637F807&displaylang=en

Or you may be able to use fyiReporting or a "common text editor" though I'm not sure who has enough time to edit RDL by hand.

from the CRM tutorial:

For information on installing Report Designer, see Chapter 24 of the Microsoft CRM 3.0 Implementation Guide.

http://www.microsoft.com/dynamics/crm/using/customizing/reporttutorial.mspx

From Chapter 24.

For instructions on writing Reporting Services reports for Microsoft CRM, see the Report Writers Guide
section in the Microsoft CRM 3.0 Software Development Kit (SDK).

From the Report Writers Guide:

To write reports, Visual Studio .NET 2003 (or Visual Studio 2005) and Report Designer (a component of SQL Reporting Services) is the recommended development environment. These tools must be installed on the computer where the reports are authored. Visual Studio is the primary tool used to create or modify reports. You must also have access to Microsoft CRM to deploy the report.

Not a lot of help there! Did you try using CRM CD?

cheers,

Andrew

|||Thank you Andrew

Report Designer installation location

We are installing Reporting Services 2000 on a new SQL Server 2000 box and
get a message indicating that Visual Studio 2003 needs to be installed,
otherwise it will install RS2000 without Report Designer.
We currently have RS2000 installed on a SQL Server box with VS2003 and it
works fine.
This time we would like to do it differently and install RS2000 on a SQL
Server 2000 box, but install VS2003 on a development workstation. How can we
do this and still get Report Designer installed on the workstation? Don't we
need RD to get all the RS controls, etc?
Thanks,
SteveOn Aug 1, 12:50 pm, Steve <MyNoS...@.NoSpam.org> wrote:
> We are installing Reporting Services 2000 on a new SQL Server 2000 box and
> get a message indicating that Visual Studio 2003 needs to be installed,
> otherwise it will install RS2000 without Report Designer.
> We currently have RS2000 installed on a SQL Server box with VS2003 and it
> works fine.
> This time we would like to do it differently and install RS2000 on a SQL
> Server 2000 box, but install VS2003 on a development workstation. How can we
> do this and still get Report Designer installed on the workstation? Don't we
> need RD to get all the RS controls, etc?
> Thanks,
> Steve
If I recall, the Report Designer for the 2000 version requires Visual
Studio to be installed on the same box. This is not the case in SSRS
2005, since it installs the Business Intelligence Development Studio
Environment (which includes the Report Designer) as long as SQL Server
2005 is on the local box. Most likely, you will need to install VS
2003. Sorry that I could not be of greater assistance.
Regards,
Enrique Martinez
Sr. Software Consultant

Report Designer for Reporting Services

Sorry if this is well known now but...

If a customer of ours installed Reporting Services on their SQL Server 2000 machine how do they design reports, assuming they do not own a copy of Visual Studio .NET 2003? Is there some form of report designer?

It is my understanding that Sql 2005 DOES come with a report designer is VS is not installed.

Regards
GrahamIn SQL Server 2000 Reporting Services, there is no Report Designer outside of the one hosted in VS 2003 (VB Standard will do). SQL 2005 comes with a version of the Visual Studio shell to host Report Designer. It also comes with Report Builder, which does not require VS at all.|||Having the components used withing Report Builder would be nice. Or being able to modify Report Builder (given the source) would even be nicer.|||

Is it possible to host the Report Designer in a custom application ? Maby like hosting the Forms Designer in a custom application.

http://msdn.microsoft.com/msdnmag/issues/06/03/DesignerHosting/default.aspx

|||Yes, yes, I've seen examples like this. But without spending an inordinate amount of time to research and test, is it possible to host the report designer in the same way? The Winforms designer, yes. But the report designer?

Report Designer for Reporting Services

Sorry if this is well known now but...

It is my understanding that Sql 2005 DOES come with a report designer is VS is not installed.

Is it possible to host the Report Designer in a custom application ? Maby like hosting the Forms Designer in a custom application.

http://msdn.microsoft.com/msdnmag/issues/06/03/DesignerHosting/default.aspx

Report Designer for Reporting Services

Sorry if this is well known now but...

It is my understanding that Sql 2005 DOES come with a report designer is VS is not installed.

Is it possible to host the Report Designer in a custom application ? Maby like hosting the Forms Designer in a custom application.

http://msdn.microsoft.com/msdnmag/issues/06/03/DesignerHosting/default.aspx

Report Designer best practice

Hi
When creating a best practice enterprise reporting solution, would you
normally create report models first, use these as datasources in Report
Designer, andd create datasets on top of these? Or would you create datasets
using SQL queries directly from Report Designer?
What is the preferred/best practice way of creating the datasets ?
Kind Regards,
Torkild HagenOn Mar 22, 2:15 am, thagen <tha...@.discussions.microsoft.com> wrote:
> Hi
> When creating a best practice enterprise reporting solution, would you
> normally create report models first, use these as datasources in Report
> Designer, andd create datasets on top of these? Or would you create datasets
> using SQL queries directly from Report Designer?
> What is the preferred/best practice way of creating the datasets ?
> Kind Regards,
> Torkild Hagen
My preference is to create stored procedures first and then create
datasets based on those stored procedures in the Report Designer, etc;
since, stored procedures generally have better performance. Just my
thoughts. Hope this is helpful.
Regards,
Enrique Martinez
Sr. SQL Server Developer|||You can use report model as Datasource but this is meant for RB, for normal
reports, it is advisable to create stored proc and then create dataset. For
queries returning very small no of records, direct query will be good. As a
best Practise use shared datasource as far as possible, so that later if you
want to change any thing related to data source can be changed at one place
instead of many places.
Amarnath, MCTS
"thagen" wrote:
> Hi
> When creating a best practice enterprise reporting solution, would you
> normally create report models first, use these as datasources in Report
> Designer, andd create datasets on top of these? Or would you create datasets
> using SQL queries directly from Report Designer?
> What is the preferred/best practice way of creating the datasets ?
> Kind Regards,
> Torkild Hagen

Report Designer 2005 and 2003 side by side?

When I installed SQL Server 2005 on my machine, VisualStudio 2005 was also
installed. I now have both 2003 and 2005 running. However, reporting service
projects are no longer available in the VS 2003 environment. Is it possible
to use both side by side?
TIA
HowardYes you can use VS2005 and VS2003 side by side. When you install VS2005
all the VS2003 project files icons turned into VS2005 icons but no
worrys. When you open your VS2003 solution file it opens in VS2003.
As far as the reports is it Crystal Reports that no longer exists?
Thanks
-L
My Quote : Trouble brings experience and experience wisdom.|||Yes you can use VS2005 and VS2003 side by side. When you install VS2005
all the VS2003 project files icons turned into VS2005 icons but no
worrys. When you open your VS2003 solution file it opens in VS2003.
As far as the reports is it Crystal Reports that no longer exists?
Thanks
-L
My Quote : Trouble brings experience and experience wisdom.|||Yes you can use VS2005 and VS2003 side by side. When you install VS2005
all the VS2003 project files icons turned into VS2005 icons but no
worrys. When you open your VS2003 solution file it opens in VS2003.
As far as the reports is it Crystal Reports that no longer exists?
Thanks
-L
My Quote : Trouble brings experience and experience wisdom.|||No it is the reporting services projects that are no longer available in
VS2003. Now I can only create / edit .rdl files with VS2005. Since it is
using a different version of the report designer I can no longer work on
reporting service projects without upgrading them. This is unacceptable for
a particular project on which I am working. I was hoping there might be a
way to run old version and new version side by side.
<pradev@.gmail.com> wrote in message
news:1138917796.740022.70600@.g49g2000cwa.googlegroups.com...
> Yes you can use VS2005 and VS2003 side by side. When you install VS2005
> all the VS2003 project files icons turned into VS2005 icons but no
> worrys. When you open your VS2003 solution file it opens in VS2003.
>
> As far as the reports is it Crystal Reports that no longer exists?
> Thanks
> -L
> My Quote : Trouble brings experience and experience wisdom.
>|||You can definitely do this. I just doubled checked. As long as you do not
open and convert the rdl files in RS 2005 designer you can still open and
edit them. What is happening is that the extensions are being registered for
RS 2005 designer. If you just double click on the solution or the project it
will open up RS 2005 designer. However, if you open up VS 2003 and select
open project and go to your project you can open and edit RS 2000 reports.
What I did was leave my RS 2000 project alone. Copied them over to another
directory and then opened all the reports and converted them to RS 2005.
Side by side definitely works.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Howard Swope" <swopehATgigamotoDOTcom> wrote in message
news:uES3Zv0KGHA.3164@.TK2MSFTNGP11.phx.gbl...
> No it is the reporting services projects that are no longer available in
> VS2003. Now I can only create / edit .rdl files with VS2005. Since it is
> using a different version of the report designer I can no longer work on
> reporting service projects without upgrading them. This is unacceptable
> for a particular project on which I am working. I was hoping there might
> be a way to run old version and new version side by side.
> <pradev@.gmail.com> wrote in message
> news:1138917796.740022.70600@.g49g2000cwa.googlegroups.com...
>> Yes you can use VS2005 and VS2003 side by side. When you install VS2005
>> all the VS2003 project files icons turned into VS2005 icons but no
>> worrys. When you open your VS2003 solution file it opens in VS2003.
>>
>> As far as the reports is it Crystal Reports that no longer exists?
>> Thanks
>> -L
>> My Quote : Trouble brings experience and experience wisdom.
>|||The Reporting Services 2005 install seemed to remove the Report
Designer in Visual Studio 2003.
So I just re-installed this designer after installing Visual Studio
2005.
Now to Design for SQL 2000 you use VS2003 and for SQL 2005 use VS 2005
all on the same box.
Have been successfully writing SQL 2000 reports in VS2003 since.
Having a nightmare trying to run the report manager for 2005 on my PC
after all of this as it won't let me deploy report models!
One of the other guys at work reckon it's due to sp2 for XP but have
tried and googled all ov er the place...|||Sorry, can't help you there.
Hmm, not sure why you ended up with the 2000 report designer removed. I
didn't have any of that happen to me.
Sorry, I can't help you with the report models. It very well could be
something with the firewall in SP2 on XP.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"SmartbizAustralia" <tom@.smartbiz.com.au> wrote in message
news:1139307968.314418.149120@.o13g2000cwo.googlegroups.com...
> The Reporting Services 2005 install seemed to remove the Report
> Designer in Visual Studio 2003.
> So I just re-installed this designer after installing Visual Studio
> 2005.
> Now to Design for SQL 2000 you use VS2003 and for SQL 2005 use VS 2005
> all on the same box.
> Have been successfully writing SQL 2000 reports in VS2003 since.
> Having a nightmare trying to run the report manager for 2005 on my PC
> after all of this as it won't let me deploy report models!
> One of the other guys at work reckon it's due to sp2 for XP but have
> tried and googled all ov er the place...
>|||I reinstalled the client portion of the sql 2000 reporting services and
everything is working well.
Thanks
"Howard Swope" <swopehATgigamotoDOTcom> wrote in message
news:ONce2MEKGHA.3200@.tk2msftngp13.phx.gbl...
> When I installed SQL Server 2005 on my machine, VisualStudio 2005 was also
> installed. I now have both 2003 and 2005 running. However, reporting
> service projects are no longer available in the VS 2003 environment. Is it
> possible to use both side by side?
> TIA
> Howard
>

Report Designer

My company just installed SQL Reporting Services and they've given me
permissions to where I can view the home page of the Reporting Services site.
I'm using Visual Studio.net to develop in but I'm unclear on what I need to
install on my end to create the reports and deploy to the report server.
I've gone through RS demos and have seen the option to create a new report
but I don't appear to have that option so I must need a plug in of some sort.
Any help would be appreciated.In order to write reports you need to install Reporting Services on your
local PC. Once you do, you will see a new folder called Business
Intelligence. This is where you can create new reports.
Good luck.
Michael
"yrmeyer" wrote:
> My company just installed SQL Reporting Services and they've given me
> permissions to where I can view the home page of the Reporting Services site.
> I'm using Visual Studio.net to develop in but I'm unclear on what I need to
> install on my end to create the reports and deploy to the report server.
> I've gone through RS demos and have seen the option to create a new report
> but I don't appear to have that option so I must need a plug in of some sort.
> Any help would be appreciated.|||You can create your reports with out designer using the RDL reader/writer
http://www.rdlcomponents.com
Jerry
"MAGrimsley" wrote:
> In order to write reports you need to install Reporting Services on your
> local PC. Once you do, you will see a new folder called Business
> Intelligence. This is where you can create new reports.
> Good luck.
> Michael
> "yrmeyer" wrote:
> > My company just installed SQL Reporting Services and they've given me
> > permissions to where I can view the home page of the Reporting Services site.
> > I'm using Visual Studio.net to develop in but I'm unclear on what I need to
> > install on my end to create the reports and deploy to the report server.
> > I've gone through RS demos and have seen the option to create a new report
> > but I don't appear to have that option so I must need a plug in of some sort.
> > Any help would be appreciated.|||Thank you.
I've downloaded the Evaluation copy of RS until I can get the software sent
to me by my company. I'm unable to get past the screen where it asks for the
SQL Server Instance. Not sure what it's asking for.
"MAGrimsley" wrote:
> In order to write reports you need to install Reporting Services on your
> local PC. Once you do, you will see a new folder called Business
> Intelligence. This is where you can create new reports.
> Good luck.
> Michael
> "yrmeyer" wrote:
> > My company just installed SQL Reporting Services and they've given me
> > permissions to where I can view the home page of the Reporting Services site.
> > I'm using Visual Studio.net to develop in but I'm unclear on what I need to
> > install on my end to create the reports and deploy to the report server.
> > I've gone through RS demos and have seen the option to create a new report
> > but I don't appear to have that option so I must need a plug in of some sort.
> > Any help would be appreciated.|||You will see this is SQL Server is not installed on the local machine.
"yrmeyer" wrote:
> Thank you.
> I've downloaded the Evaluation copy of RS until I can get the software sent
> to me by my company. I'm unable to get past the screen where it asks for the
> SQL Server Instance. Not sure what it's asking for.
>
> "MAGrimsley" wrote:
> > In order to write reports you need to install Reporting Services on your
> > local PC. Once you do, you will see a new folder called Business
> > Intelligence. This is where you can create new reports.
> >
> > Good luck.
> >
> > Michael
> >
> > "yrmeyer" wrote:
> >
> > > My company just installed SQL Reporting Services and they've given me
> > > permissions to where I can view the home page of the Reporting Services site.
> > > I'm using Visual Studio.net to develop in but I'm unclear on what I need to
> > > install on my end to create the reports and deploy to the report server.
> > > I've gone through RS demos and have seen the option to create a new report
> > > but I don't appear to have that option so I must need a plug in of some sort.
> > > Any help would be appreciated.|||the url of homepage of reporting services site should be looking like
http://server1/reports
Once you've created report in Report Designer you need to open project
properties and specify location of reporting services server which should be
http://server1/reportserver
After specifying the rs server location you can try deploying your report to
report server (search for Deploy command in rep designer menu).
You should also be able to preview your report in report designer preview
tab without deploying.
If it fails to deploy it'll be one of two problems: either rs location is
invalid or you do not have permission to deploy reports on the report server
you specified.
In the second case you need to talk to admin and ask him to give you such
permission.
--
Alex Mineev
Software Design Engineer. Report expressions; Code Access Security; Xml;
SQE.
This posting is provided "AS IS" with no warranties, and confers no rights
"yrmeyer" <yrmeyer@.discussions.microsoft.com> wrote in message
news:79F0319C-587D-46AF-B631-1A7DB2E4AFA7@.microsoft.com...
> My company just installed SQL Reporting Services and they've given me
> permissions to where I can view the home page of the Reporting Services
site.
> I'm using Visual Studio.net to develop in but I'm unclear on what I need
to
> install on my end to create the reports and deploy to the report server.
> I've gone through RS demos and have seen the option to create a new report
> but I don't appear to have that option so I must need a plug in of some
sort.
> Any help would be appreciated.

Report Designer

Hi
After a month long evaluation of Reporting Services my company has only one
more question left. Will there ever be a stand alone Report Designer for
Reporting Services (one that can be used without VS)?
Thanks a lot
ShawnKindof. You will not be required to buy VS. Yukon will ship with VS/Report
Designer combo. So, VS will still be there it is just that Yukon ships with
the VS/Report Designer installation.
Keep in mind that even today it can be any version of VS. For instance if
you buy VB.net it is only $100.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Shawn Kralj" <ShawnKralj@.discussions.microsoft.com> wrote in message
news:AE69518F-5BA7-4B80-B0C5-5F8572FD59F0@.microsoft.com...
> Hi
> After a month long evaluation of Reporting Services my company has only
one
> more question left. Will there ever be a stand alone Report Designer for
> Reporting Services (one that can be used without VS)?
> Thanks a lot
> Shawn|||Additional comments to what Bruce said:
Some of our partners have developed / are developing various stand-alone
applications for designing reports:
http://www.microsoft.com/sql/reporting/partners/softwareapps.asp
RS2005 will have a new component called Report Builder in addition to Report
Designer. More information on Report Builder is available here:
http://www.microsoft.com/sql/reporting/productinfo/av_activeviews.asp
More detailed information on Report Builder will be available closer to RS
2005 Beta 3.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:%23tzY%23$v1EHA.1524@.TK2MSFTNGP09.phx.gbl...
> Kindof. You will not be required to buy VS. Yukon will ship with VS/Report
> Designer combo. So, VS will still be there it is just that Yukon ships
with
> the VS/Report Designer installation.
> Keep in mind that even today it can be any version of VS. For instance if
> you buy VB.net it is only $100.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Shawn Kralj" <ShawnKralj@.discussions.microsoft.com> wrote in message
> news:AE69518F-5BA7-4B80-B0C5-5F8572FD59F0@.microsoft.com...
> > Hi
> >
> > After a month long evaluation of Reporting Services my company has only
> one
> > more question left. Will there ever be a stand alone Report Designer for
> > Reporting Services (one that can be used without VS)?
> >
> > Thanks a lot
> >
> > Shawn
>|||And to add to the discussion, SQL 2005 is slated to include an ad hoc
reporting tool, ActiveViews, which can be used to build reports:
http://www.microsoft.com/sql/reporting/productinfo/av_activeviews.asp
Cheers,
--
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:%23FVw5Kw1EHA.3408@.tk2msftngp13.phx.gbl...
> Additional comments to what Bruce said:
> Some of our partners have developed / are developing various stand-alone
> applications for designing reports:
> http://www.microsoft.com/sql/reporting/partners/softwareapps.asp
> RS2005 will have a new component called Report Builder in addition to
> Report
> Designer. More information on Report Builder is available here:
> http://www.microsoft.com/sql/reporting/productinfo/av_activeviews.asp
> More detailed information on Report Builder will be available closer to RS
> 2005 Beta 3.
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:%23tzY%23$v1EHA.1524@.TK2MSFTNGP09.phx.gbl...
>> Kindof. You will not be required to buy VS. Yukon will ship with
>> VS/Report
>> Designer combo. So, VS will still be there it is just that Yukon ships
> with
>> the VS/Report Designer installation.
>> Keep in mind that even today it can be any version of VS. For instance if
>> you buy VB.net it is only $100.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Shawn Kralj" <ShawnKralj@.discussions.microsoft.com> wrote in message
>> news:AE69518F-5BA7-4B80-B0C5-5F8572FD59F0@.microsoft.com...
>> > Hi
>> >
>> > After a month long evaluation of Reporting Services my company has only
>> one
>> > more question left. Will there ever be a stand alone Report Designer
>> > for
>> > Reporting Services (one that can be used without VS)?
>> >
>> > Thanks a lot
>> >
>> > Shawn
>>
>|||You can create your Reports Programmatically, no VS, no Designers, no
XMLknowledgment required!
http://www.rdlcomponents.com
Jerry
"Shawn Kralj" wrote:
> Hi
> After a month long evaluation of Reporting Services my company has only one
> more question left. Will there ever be a stand alone Report Designer for
> Reporting Services (one that can be used without VS)?
> Thanks a lot
> Shawn

Report designer

Hi,
Do I need the full visual studio 2003 to design reporting services forms?
Can I maybe use a cut down version to design forms, as we cannot afford the
upgrade fees.
ThanksMinimal configuration should be enough
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"James Wakefield" <wakey_99@.yahoo.com> wrote in message
news:%23EbRdSHxEHA.1524@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Do I need the full visual studio 2003 to design reporting services forms?
> Can I maybe use a cut down version to design forms, as we cannot afford
> the upgrade fees.
> Thanks
>|||Thanks but I'm not sure what you mean by minimal configuration?
Is that a download instead of full visual studio?
"Lev Semenets [MSFT]" wrote:
> Minimal configuration should be enough
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "James Wakefield" <wakey_99@.yahoo.com> wrote in message
> news:%23EbRdSHxEHA.1524@.TK2MSFTNGP09.phx.gbl...
> > Hi,
> >
> > Do I need the full visual studio 2003 to design reporting services forms?
> > Can I maybe use a cut down version to design forms, as we cannot afford
> > the upgrade fees.
> >
> > Thanks
> >
>
>|||Visual Basic.NET 2003 version should be enough
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"James Wakefield" <James Wakefield@.discussions.microsoft.com> wrote in
message news:D7715297-FAB9-477D-9DB8-F17AD0C1BBFF@.microsoft.com...
> Thanks but I'm not sure what you mean by minimal configuration?
> Is that a download instead of full visual studio?
> "Lev Semenets [MSFT]" wrote:
>> Minimal configuration should be enough
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "James Wakefield" <wakey_99@.yahoo.com> wrote in message
>> news:%23EbRdSHxEHA.1524@.TK2MSFTNGP09.phx.gbl...
>> > Hi,
>> >
>> > Do I need the full visual studio 2003 to design reporting services
>> > forms?
>> > Can I maybe use a cut down version to design forms, as we cannot afford
>> > the upgrade fees.
>> >
>> > Thanks
>> >
>>

report designer

Hi there. Please understand, I am very new to reporting services. I
upgraded from VS 2003 to VS 2005 last week, and now I am struggling to even
get to the projects/reports I had already created. The layout, the start
page -- everything is pretty different, old or new, I can't even open Report
Designer or view report layout. All I've got is my solution explorer, my
.rds and .rdl's open in xml version and I've got my data sources on the far
left. In the previous version I was able to go up top to the menu items and
pull down/select the Report dialogue box. First, can anybody let me know how
to open report designer and/or Report Layout? Also, does anybody have some
good references other than BOL that I could use for reporting services? I've
gotten one report deployed successfully, but that was because it had a single
resultset. ALL of my other reports have mulitple result sets, I am currently
running via stored procedure and distributing results via email. As you
know, tsql is not a reporting tool at all, and I need to migrate to something
a bit more robust, as in Reporting Services. But, I'm struggling quite a
bit. Any links or references?
-- LynnI found the report layout -- what's this '.rdlc' extension ? Also, '.xsd' ?
In v2003 I just remember the Data Set and Layout options, I don't recall
these extensions. But, as I said, I'm very new to RS, so I may have missed
them.
-- Lynn
"Lynn" wrote:
> Hi there. Please understand, I am very new to reporting services. I
> upgraded from VS 2003 to VS 2005 last week, and now I am struggling to even
> get to the projects/reports I had already created. The layout, the start
> page -- everything is pretty different, old or new, I can't even open Report
> Designer or view report layout. All I've got is my solution explorer, my
> .rds and .rdl's open in xml version and I've got my data sources on the far
> left. In the previous version I was able to go up top to the menu items and
> pull down/select the Report dialogue box. First, can anybody let me know how
> to open report designer and/or Report Layout? Also, does anybody have some
> good references other than BOL that I could use for reporting services? I've
> gotten one report deployed successfully, but that was because it had a single
> resultset. ALL of my other reports have mulitple result sets, I am currently
> running via stored procedure and distributing results via email. As you
> know, tsql is not a reporting tool at all, and I need to migrate to something
> a bit more robust, as in Reporting Services. But, I'm struggling quite a
> bit. Any links or references?
> -- Lynn|||If you don't install the designer all you get for report design are tools
that work standalone (a new report format allows using reports with no
server). What you need to do is to install the Designer from the SQL Server
2005 media. This will integrate with VS 2005.
Indeed, unless you are doing custom assemblies you did not need to upgrade
to VS 2005. RS 2005 comes with a version of VS to host the development
environment.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Lynn" <Lynn@.discussions.microsoft.com> wrote in message
news:841B2C0B-E566-42A1-944F-94D9EF1C99EF@.microsoft.com...
>I found the report layout -- what's this '.rdlc' extension ? Also, '.xsd'
>?
> In v2003 I just remember the Data Set and Layout options, I don't recall
> these extensions. But, as I said, I'm very new to RS, so I may have
> missed
> them.
> -- Lynn
>
> "Lynn" wrote:
>> Hi there. Please understand, I am very new to reporting services. I
>> upgraded from VS 2003 to VS 2005 last week, and now I am struggling to
>> even
>> get to the projects/reports I had already created. The layout, the start
>> page -- everything is pretty different, old or new, I can't even open
>> Report
>> Designer or view report layout. All I've got is my solution explorer, my
>> .rds and .rdl's open in xml version and I've got my data sources on the
>> far
>> left. In the previous version I was able to go up top to the menu items
>> and
>> pull down/select the Report dialogue box. First, can anybody let me know
>> how
>> to open report designer and/or Report Layout? Also, does anybody have
>> some
>> good references other than BOL that I could use for reporting services?
>> I've
>> gotten one report deployed successfully, but that was because it had a
>> single
>> resultset. ALL of my other reports have mulitple result sets, I am
>> currently
>> running via stored procedure and distributing results via email. As you
>> know, tsql is not a reporting tool at all, and I need to migrate to
>> something
>> a bit more robust, as in Reporting Services. But, I'm struggling quite a
>> bit. Any links or references?
>> -- Lynn|||I'm running sql v2000, I upgraded vs to v2005, as i was having rather
unexplained problems. i had been working with a RS person who is quite
versed, but he, too, was unable to resolve the problems I was having with all
the multiple resultset reports. He suggested I upgrade, I did, and now I'm
having a pretty difficult time getting my hands back around this.
Can I get the Designer w/out going to sql v2005?
-- Lynn
"Bruce L-C [MVP]" wrote:
> If you don't install the designer all you get for report design are tools
> that work standalone (a new report format allows using reports with no
> server). What you need to do is to install the Designer from the SQL Server
> 2005 media. This will integrate with VS 2005.
> Indeed, unless you are doing custom assemblies you did not need to upgrade
> to VS 2005. RS 2005 comes with a version of VS to host the development
> environment.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Lynn" <Lynn@.discussions.microsoft.com> wrote in message
> news:841B2C0B-E566-42A1-944F-94D9EF1C99EF@.microsoft.com...
> >I found the report layout -- what's this '.rdlc' extension ? Also, '.xsd'
> >?
> > In v2003 I just remember the Data Set and Layout options, I don't recall
> > these extensions. But, as I said, I'm very new to RS, so I may have
> > missed
> > them.
> > -- Lynn
> >
> >
> > "Lynn" wrote:
> >
> >> Hi there. Please understand, I am very new to reporting services. I
> >> upgraded from VS 2003 to VS 2005 last week, and now I am struggling to
> >> even
> >> get to the projects/reports I had already created. The layout, the start
> >> page -- everything is pretty different, old or new, I can't even open
> >> Report
> >> Designer or view report layout. All I've got is my solution explorer, my
> >> .rds and .rdl's open in xml version and I've got my data sources on the
> >> far
> >> left. In the previous version I was able to go up top to the menu items
> >> and
> >> pull down/select the Report dialogue box. First, can anybody let me know
> >> how
> >> to open report designer and/or Report Layout? Also, does anybody have
> >> some
> >> good references other than BOL that I could use for reporting services?
> >> I've
> >> gotten one report deployed successfully, but that was because it had a
> >> single
> >> resultset. ALL of my other reports have mulitple result sets, I am
> >> currently
> >> running via stored procedure and distributing results via email. As you
> >> know, tsql is not a reporting tool at all, and I need to migrate to
> >> something
> >> a bit more robust, as in Reporting Services. But, I'm struggling quite a
> >> bit. Any links or references?
> >> -- Lynn
>
>|||RS 2000 designer will not work with VS 2005. VS 2005 is based on the 2.0
framework. RS 2000 is a 1.1 app. Plus all the other integration issues with
the IDE. You can have VS 2003 and VS 2005 side by side. You need to
reinstall VS 2003 and most likely reinstall the RS 2000 report designer.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Lynn" <Lynn@.discussions.microsoft.com> wrote in message
news:2230700F-0B0E-4BDF-981B-17CF8EFFF57C@.microsoft.com...
> I'm running sql v2000, I upgraded vs to v2005, as i was having rather
> unexplained problems. i had been working with a RS person who is quite
> versed, but he, too, was unable to resolve the problems I was having with
> all
> the multiple resultset reports. He suggested I upgrade, I did, and now
> I'm
> having a pretty difficult time getting my hands back around this.
> Can I get the Designer w/out going to sql v2005?
> -- Lynn
>
> "Bruce L-C [MVP]" wrote:
>> If you don't install the designer all you get for report design are tools
>> that work standalone (a new report format allows using reports with no
>> server). What you need to do is to install the Designer from the SQL
>> Server
>> 2005 media. This will integrate with VS 2005.
>> Indeed, unless you are doing custom assemblies you did not need to
>> upgrade
>> to VS 2005. RS 2005 comes with a version of VS to host the development
>> environment.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Lynn" <Lynn@.discussions.microsoft.com> wrote in message
>> news:841B2C0B-E566-42A1-944F-94D9EF1C99EF@.microsoft.com...
>> >I found the report layout -- what's this '.rdlc' extension ? Also,
>> >'.xsd'
>> >?
>> > In v2003 I just remember the Data Set and Layout options, I don't
>> > recall
>> > these extensions. But, as I said, I'm very new to RS, so I may have
>> > missed
>> > them.
>> > -- Lynn
>> >
>> >
>> > "Lynn" wrote:
>> >
>> >> Hi there. Please understand, I am very new to reporting services. I
>> >> upgraded from VS 2003 to VS 2005 last week, and now I am struggling to
>> >> even
>> >> get to the projects/reports I had already created. The layout, the
>> >> start
>> >> page -- everything is pretty different, old or new, I can't even open
>> >> Report
>> >> Designer or view report layout. All I've got is my solution explorer,
>> >> my
>> >> .rds and .rdl's open in xml version and I've got my data sources on
>> >> the
>> >> far
>> >> left. In the previous version I was able to go up top to the menu
>> >> items
>> >> and
>> >> pull down/select the Report dialogue box. First, can anybody let me
>> >> know
>> >> how
>> >> to open report designer and/or Report Layout? Also, does anybody have
>> >> some
>> >> good references other than BOL that I could use for reporting
>> >> services?
>> >> I've
>> >> gotten one report deployed successfully, but that was because it had a
>> >> single
>> >> resultset. ALL of my other reports have mulitple result sets, I am
>> >> currently
>> >> running via stored procedure and distributing results via email. As
>> >> you
>> >> know, tsql is not a reporting tool at all, and I need to migrate to
>> >> something
>> >> a bit more robust, as in Reporting Services. But, I'm struggling
>> >> quite a
>> >> bit. Any links or references?
>> >> -- Lynn
>>|||I didn't expect that the solution would require side by side instances of the
software, two different versions.
-- Lynn
"Bruce L-C [MVP]" wrote:
> RS 2000 designer will not work with VS 2005. VS 2005 is based on the 2.0
> framework. RS 2000 is a 1.1 app. Plus all the other integration issues with
> the IDE. You can have VS 2003 and VS 2005 side by side. You need to
> reinstall VS 2003 and most likely reinstall the RS 2000 report designer.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Lynn" <Lynn@.discussions.microsoft.com> wrote in message
> news:2230700F-0B0E-4BDF-981B-17CF8EFFF57C@.microsoft.com...
> > I'm running sql v2000, I upgraded vs to v2005, as i was having rather
> > unexplained problems. i had been working with a RS person who is quite
> > versed, but he, too, was unable to resolve the problems I was having with
> > all
> > the multiple resultset reports. He suggested I upgrade, I did, and now
> > I'm
> > having a pretty difficult time getting my hands back around this.
> >
> > Can I get the Designer w/out going to sql v2005?
> > -- Lynn
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> If you don't install the designer all you get for report design are tools
> >> that work standalone (a new report format allows using reports with no
> >> server). What you need to do is to install the Designer from the SQL
> >> Server
> >> 2005 media. This will integrate with VS 2005.
> >>
> >> Indeed, unless you are doing custom assemblies you did not need to
> >> upgrade
> >> to VS 2005. RS 2005 comes with a version of VS to host the development
> >> environment.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Lynn" <Lynn@.discussions.microsoft.com> wrote in message
> >> news:841B2C0B-E566-42A1-944F-94D9EF1C99EF@.microsoft.com...
> >> >I found the report layout -- what's this '.rdlc' extension ? Also,
> >> >'.xsd'
> >> >?
> >> > In v2003 I just remember the Data Set and Layout options, I don't
> >> > recall
> >> > these extensions. But, as I said, I'm very new to RS, so I may have
> >> > missed
> >> > them.
> >> > -- Lynn
> >> >
> >> >
> >> > "Lynn" wrote:
> >> >
> >> >> Hi there. Please understand, I am very new to reporting services. I
> >> >> upgraded from VS 2003 to VS 2005 last week, and now I am struggling to
> >> >> even
> >> >> get to the projects/reports I had already created. The layout, the
> >> >> start
> >> >> page -- everything is pretty different, old or new, I can't even open
> >> >> Report
> >> >> Designer or view report layout. All I've got is my solution explorer,
> >> >> my
> >> >> .rds and .rdl's open in xml version and I've got my data sources on
> >> >> the
> >> >> far
> >> >> left. In the previous version I was able to go up top to the menu
> >> >> items
> >> >> and
> >> >> pull down/select the Report dialogue box. First, can anybody let me
> >> >> know
> >> >> how
> >> >> to open report designer and/or Report Layout? Also, does anybody have
> >> >> some
> >> >> good references other than BOL that I could use for reporting
> >> >> services?
> >> >> I've
> >> >> gotten one report deployed successfully, but that was because it had a
> >> >> single
> >> >> resultset. ALL of my other reports have mulitple result sets, I am
> >> >> currently
> >> >> running via stored procedure and distributing results via email. As
> >> >> you
> >> >> know, tsql is not a reporting tool at all, and I need to migrate to
> >> >> something
> >> >> a bit more robust, as in Reporting Services. But, I'm struggling
> >> >> quite a
> >> >> bit. Any links or references?
> >> >> -- Lynn
> >>
> >>
> >>
>
>sql

Report Design Question

Hi everyone!
I am developing a Work Order report similar to the "Adventure Works Cycles"
sample provided with Reporting Services. What I would like to do is repeat
the "Header" information on each page. I am looking at the samples for an
example on how to do this but no luck. I even reduced the height of the
"Adventure Works Cycles" sample report to see if it's Header data is carried
over and it isn't.
How do I get my "Header" data to carry over to the next page. I tried adding
it to the page Header but it doesn't like field data in it.
Thanks in advance,
YoshiLook at the Header attibute for the Table. It can be set to repeat on each
page.
--
| From: "Yoshi" <yoshi@.home.com>
| Subject: Report Design Question
| Date: Wed, 17 Nov 2004 10:06:03 -0600
| Lines: 17
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
| X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
| X-RFC2646: Format=Flowed; Original
| Message-ID: <#YmgY9LzEHA.1292@.TK2MSFTNGP10.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: cs24174142-174.satx.rr.com 24.174.142.174
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTFEED02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10|||My header data is not in the table as I am confined to the column width. I
placed the header data in the body of the report above the table. I used the
"Adventure Works Cycles" sample provided by Microsoft, as my guide.
My problem is when the detail lines carry over to the next page. I would
like page 2 to have the same header data that page 1 has. In fact, I want
subsequent pages to look like page 1 with the header data.
Make sense?
Thanks,
Yoshi
""Brad Syputa - MS"" <bradsy@.Online.Microsoft.com> wrote in message
news:wbVFvhNzEHA.2916@.cpmsftngxa10.phx.gbl...
> Look at the Header attibute for the Table. It can be set to repeat on each
> page.
> --
> | From: "Yoshi" <yoshi@.home.com>
> | Subject: Report Design Question
> | Date: Wed, 17 Nov 2004 10:06:03 -0600
> | Lines: 17
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
> | X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
> | X-RFC2646: Format=Flowed; Original
> | Message-ID: <#YmgY9LzEHA.1292@.TK2MSFTNGP10.phx.gbl>
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: cs24174142-174.satx.rr.com 24.174.142.174
> | Path:
> cpmsftngxa10.phx.gbl!TK2MSFTFEED02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10
> phx.gbl
> | Xref: cpmsftngxa10.phx.gbl
> microsoft.public.sqlserver.reportingsvcs:35173
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | Hi everyone!
> |
> | I am developing a Work Order report similar to the "Adventure Works
> Cycles"
> | sample provided with Reporting Services. What I would like to do is
> repeat
> | the "Header" information on each page. I am looking at the samples for
> an
> | example on how to do this but no luck. I even reduced the height of the
> | "Adventure Works Cycles" sample report to see if it's Header data is
> carried
> | over and it isn't.
> |
> | How do I get my "Header" data to carry over to the next page. I tried
> adding
> | it to the page Header but it doesn't like field data in it.
> |
> | Thanks in advance,
> |
> | Yoshi
> |
> |
> |
>|||Place the header in a table group - go to Edit Group and select the
"Repeat Header" option.|||Unfortunately, my header will not work in the "Table" header row. The
columns do not allow for the correct width.
Thanks for the response.
"papaboom" <smith.jamie@.gmail.com> wrote in message
news:1100725306.172333.164530@.z14g2000cwz.googlegroups.com...
> Place the header in a table group - go to Edit Group and select the
> "Repeat Header" option.
>|||Techinically - Yoshi - you are not confined to keeping your header
outside the table. If this is the problem - then place the header back
in the header (or group header) section of the table. If for example
this is a single header in the header section of the table then you can
put the header in the left-most cell then select the adjacent cells in
the header row (by pressing Ctrl-click.) Once all the cells from that
row are selected - right-click the slected cells and select the "Merge
Cells" option. This will merger the cels an that row only - and will
leave the Details section rows intact.
Lastly if this is a stand alone text-object over a table - then right
click the textbox you want to repeat and select Properties. Then select
the Advanced button at the bottom left corner - on the General tab
there should be an option selected called "Repeat report item..." and
beneath it is a drop-down - select the table you wish the object to
repoeat with in each page and you should be in business. If your table
is named Table1 - then select Table1.
Let us know how it turns out.|||I really appreciate everyone's input. Thank you!
Hi. I tried the 2nd suggestion where I selected my stand alone text-object
that is over my table.
I right clicked the textbox and selected Properties. I then clicked the the
Advanced button at the bottom left corner on the General tab. I then clicked
the "Repeat report item with data region on every page" and selected the
"table 1" Data region in the drop down.
I run the report and it doesn't repeat the header textbox on the subsequent
pages. I believe this is all I need to do. This should repeat the text box
for the data region when it spans multiple pages, correct?
Basically, I want my header text boxes to repeat on each page. Just as if I
placed then in the Group header row in the table. Unfortunately, the header
data is formatted in such a way that the table does not lend itself for this
design.
Thanks again!
Yosh
"papaboom" <smith.jamie@.gmail.com> wrote in message
news:1100731569.214512.82360@.z14g2000cwz.googlegroups.com...
> Techinically - Yoshi - you are not confined to keeping your header
> outside the table. If this is the problem - then place the header back
> in the header (or group header) section of the table. If for example
> this is a single header in the header section of the table then you can
> put the header in the left-most cell then select the adjacent cells in
> the header row (by pressing Ctrl-click.) Once all the cells from that
> row are selected - right-click the slected cells and select the "Merge
> Cells" option. This will merger the cels an that row only - and will
> leave the Details section rows intact.
> Lastly if this is a stand alone text-object over a table - then right
> click the textbox you want to repeat and select Properties. Then select
> the Advanced button at the bottom left corner - on the General tab
> there should be an option selected called "Repeat report item..." and
> beneath it is a drop-down - select the table you wish the object to
> repoeat with in each page and you should be in business. If your table
> is named Table1 - then select Table1.
> Let us know how it turns out.
>|||The textbox will only repeat each time the table repeats - so if it's
one table spanning multiple pages then you may be SOL with option 2.
How is the header formatted in such a way that it cannot be displayed
in a table header? Unfortunately I think you are going to have to put
that header in the table if you want to see it repeat across multiple
pages - if option 2 didnt work.|||It seems that if the table itself repeats then the text box will repeat
- but since it is a single table spanning mulitple pages that it will
not repeat. What is special about the header that it can't be placed in
the table itself? Because it seems at this point that you will have to
go with option A (header in the table) if you want this to work.|||Option 2 was a great suggestion but your right, it's not working because of
what you said.
Option 1 will have to do. I will need to change the format of the header so
that it works and looks nice. I hope the client says it's ok.
Thank you for being so patient and persistant with my questions/posts. I
really appreciate it!
Take care,
Yosh
"papaboom" <smith.jamie@.gmail.com> wrote in message
news:1100733672.095005.163320@.z14g2000cwz.googlegroups.com...
> The textbox will only repeat each time the table repeats - so if it's
> one table spanning multiple pages then you may be SOL with option 2.
> How is the header formatted in such a way that it cannot be displayed
> in a table header? Unfortunately I think you are going to have to put
> that header in the table if you want to see it repeat across multiple
> pages - if option 2 didnt work.
>|||I believe part of the problem is the original "report" was done in Excel. I
come from the Crystal Report side of development where I could put data
fields pretty much anywhere using "free-form" placement.
I am not used to inserting column after column and merging cells to get a
very wide data field to look right in a table? That make sense?
Learning curve I guess. =0}
"papaboom" <smith.jamie@.gmail.com> wrote in message
news:1100734006.823128.176120@.z14g2000cwz.googlegroups.com...
> It seems that if the table itself repeats then the text box will repeat
> - but since it is a single table spanning mulitple pages that it will
> not repeat. What is special about the header that it can't be placed in
> the table itself? Because it seems at this point that you will have to
> go with option A (header in the table) if you want this to work.
>|||Absolutely - I come from Crystal Reports side also. I have just started
with this Reporting Services stuff about a month ago. The learning
curve can be steep here. All I can say is get ready for some more pain.
This table header business you will find to be the least of your
problems.|||Hey... Thanks Papaboom! =0}
Reporting Services makes me appreciate Crystal alot more. However, I do see
how powerful Reporting Services can become. I am very excited about the ease
of use.
Maybe you can answer this question. I have a page footer that has 1 textbox
with today's date. When I export the report, the page footer is left out.
It's not exported.
I don't know why this is happening.
Thanks so much!
Y
"papaboom" <smith.jamie@.gmail.com> wrote in message
news:1100795491.349175.78160@.f14g2000cwb.googlegroups.com...
> Absolutely - I come from Crystal Reports side also. I have just started
> with this Reporting Services stuff about a month ago. The learning
> curve can be steep here. All I can say is get ready for some more pain.
> This table header business you will find to be the least of your
> problems.
>|||Sorry Yosh - on this one I havent the slightest. The most I've done
with exporting is export a couple of reports to PDF.

Report Desginer Requirements?

Good da
Does anyone know if Report Designer for Reporting Services requires the full Visual Studio .NET 2003 suite, or will it run under Visual Basic .NET soo3
Thank
MattWhen you run the setup for Reporting Services, there should be a check which
requires VS.NET 2003 (any edition) to use the Report Designer. VB.NET, by
itself is not enough.
--
- Anith
( Please reply to newsgroups only )|||"Anith Sen" wrote:
> When you run the setup for Reporting Services, there should be a check
which
> requires VS.NET 2003 (any edition) to use the Report Designer. VB.NET, by
> itself is not enough.
I guess the SBS (and like) crowd must love this:~).
Happy Holidays,
www.rac4sql.net|||Right, any .NET thingy ought to be enough, remember, there are always
incentives for complexity :-)
--
- Anith
( Please reply to newsgroups only )|||"Anith Sen" wrote:
> ...there are always incentives for complexity :-)
Hmm...I remember recently reading just that phrase :~)sql

Monday, March 26, 2012

Report deploment to multiple servers SQL Reporting 2005

Another issue I would like your help:

We are writing reports for different clients. We need to deploy the same reports to different clients (thus also different DataSources). What is the best way to handle this? The folder names would probably be the same.

Andre

Sounds like you need a custom installer that will accept the required input (database name, credentials, folder path) and deploy the reports by calling down to the Report Server APIs. Or, you can script the objects and use the rs.exe utility to deploy. You may also find the RSScripter utility useful.sql

Report Delivery Option Missing

I have a SQL 2005 Reporting Server, and notice the only report delivery option
I see is 'export to a file share'. How to I enable the email option? Did
I perhaps miss something during installation?
Regards,
Pete Zerger, MCSE(Messaging), MVP - MOM
Co-founder and Webmaster, MOMResources.org
URL:http://www.momresources.org
BLOG: http://www.it-jedi.net/
mailto:pete.zerger@.gmail.com
...or find me in the forums at http://momcommunity.coAre your e-mail setting configured for ReportServer? You can check by going
to Report Services Configuration from Configuration Tools Under SqlServer2005.
"Pete Zerger" wrote:
> I have a SQL 2005 Reporting Server, and notice the only report delivery option
> I see is 'export to a file share'. How to I enable the email option? Did
> I perhaps miss something during installation?
> Regards,
> Pete Zerger, MCSE(Messaging), MVP - MOM
> Co-founder and Webmaster, MOMResources.org
> URL:http://www.momresources.org
> BLOG: http://www.it-jedi.net/
> mailto:pete.zerger@.gmail.com
> ...or find me in the forums at http://momcommunity.com
>
>

Report definitions - changes not apparent after upload/deploy.

We have SQL 2000 Reporting Services. There are a couple of reports that have been changed several times in the past, with no problems.

Now when we change these same reports, the new report definitions get successfully uploaded (as evidenced by the time stamp), but the old report definitions still show up.

We have tried the following.

1) Deleting the report from Reporting Services.

2) Recreating the report from scratch, then uploading the new report (w/ same name)

3) Uploading the desired report with a different name, then changing it to the desired name. (We have links and legacy applications that point to these reports). When we do this, the old version reappears.

This appears to be a caching problem. I have verified the caching option in the Properties > Data Execution [tab] is not selected. I have tried bouncing the SQL database, IIS services, and Reporting Services (let me know if there is a prescribed order).

Whatever we try, the old definitions remains persistently there.

Help!

Thanks in advance .

gmctech

Could this be client caching or proxy caching?

Friday, March 30, 2012

Report Error when 2 pages for multiple records

Report Designer VS. 2003 Interface Failure

Report designer not working

Wednesday, March 28, 2012

Report designer not in VS 2003

Report Designer installation location

Report Designer for Reporting Services

Report Designer for Reporting Services

Report Designer for Reporting Services

Report Designer best practice

Report Designer 2005 and 2003 side by side?

Report Designer

Report Designer

Report designer

report designer

Report Design Question

Report Desginer Requirements?

Monday, March 26, 2012

Report deploment to multiple servers SQL Reporting 2005

Report Delivery Option Missing

Report definitions - changes not apparent after upload/deploy.

Importing Error

Blog Archive

About Me