Showing posts with label services. Show all posts
Showing posts with label services. 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 Engine

Does Report Services 2005 have a Report Distribution engine. So that I
can for instance say; I want user 'A' to get report 'B' in a format of
'C' at 17:05 every day.
Many thanks
DavidYes, it is called Subscriptions. You can specify all of that. It is
available both Standard and Enterprise. However, Enterprise adds data driven
subscriptions.
Here is from books online about data driven subscriptions:
>>>
A data-driven subscription provides a way to deliver reports to a list of
subscribers that is determined at run time. You can use data-driven
subscriptions as follows:
a.. Customize report output at run time for each recipient of a delivery.
b.. Support the wide distribution of a report with a fluctuating list of
subscribers. For example, you can use data-driven subscriptions to
distribute a report throughout a large organization where subscribers vary
from one month to the next, or use other criteria that determines group
membership from an existing set of users.
A data-driven subscription differs from a standard subscription in the way
it gets subscription information. A data-driven subscription gets some
settings from a data source at run time, and other settings from the
subscription definition. Fixed aspects of a data-driven subscription include
the report that is delivered, the delivery extension, connection information
to an external data source that contains subscriber data, and a query that
retrieves subscription information. Dynamic settings of the subscription are
obtained from the query, including a subscriber list and user-specific
delivery extension preferences or parameter values. This data is retrieved
from a data source each time the subscription is processed.
>>>>>
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<davidswain2005@.yahoo.co.uk> wrote in message
news:1141318397.513927.57680@.i39g2000cwa.googlegroups.com...
> Does Report Services 2005 have a Report Distribution engine. So that I
> can for instance say; I want user 'A' to get report 'B' in a format of
> 'C' at 17:05 every day.
>
> Many thanks
> David
>|||Yes, it's called creating a subscription
"davidswain2005@.yahoo.co.uk" wrote:
> Does Report Services 2005 have a Report Distribution engine. So that I
> can for instance say; I want user 'A' to get report 'B' in a format of
> 'C' at 17:05 every day.
>
> Many thanks
> David
>

Report Dev

Hello,
I'am developping a report.
In this report, I have a big table.
I want to only one record per page.
How can tell Report Services ti put the second table on the second page,
the third ... ?
Thx
GaelSet up grouping so that each group only has one record. (group by the
primary key field) Then, just turn on page breaks after each group.
Mike G.
"Gael Le Mouhaer" <gael.lemouhaer@.linum.fr> wrote in message
news:XnF965AA802E5A0Egaellemouhaerlinumfr@.207.46.248.16...
> Hello,
> I'am developping a report.
> In this report, I have a big table.
> I want to only one record per page.
> How can tell Report Services ti put the second table on the second page,
> the third ... ?
> Thx
> Gael

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...

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...

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 Client software

I've loaded the Report Services from Microsoft unto our server. How do I get the Client Designer tool loaded on other boxes. Does anyone know where the Install is to install the report designer into a Client machine?

Thanks
AlFound the answer already - You run the Report Services Install disk and disable the report services part of the install and only install the report designer.. dah.. Anyway it took me about a half hour to remember that SQL makes you run through the SQL Server install disk to load just the client. That was my clue to install the Designer portion of the software.

Thanks anyway.

ALsql

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 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?

Report Cover?

Is it possible to create a cover sheet for my report in Reporting Services? If so, how would I go about doing that?

Thanks for your help!!

Uh, there's no such cover sheet tool if that's what you're asking for. You could add a table or matrix before the rest of the report and check page break after table (or matrix). Then just add the content to the table that you would want to see on the "cover page".

Friday, March 23, 2012

Report connect to AS cube

I cannot get my report to connect to my datacube. I've got RS running on a
web server and Analysis Services running on another server. The two servers
have an established relationship as i am currently able to run RS reports
against the SQL Server relational db's that exist on the server that is
running AS.
When i try to execute a report against a cube i get "cannot connect to the
server {myserver}. the server is either too busy or not started".
The connection string i am using is:
Provider=MSOLAP.2;Client Cache Size=25;Data Source={myserver};Auto Synch
Period=10000;Initial Catalog={mycatalog}
This all works fine in my dev environment where AS and RS run on the same
server.
What extra step am i missing to get my RS Web server to talk to my AS DB
server?
Thanks for any info.Sorry i do not know the answer for your question. But i am facing one
problem.I am unable to get the query designer, to type the MDX query to get
reports from my analysis server. I am using the Analysis server and web
server on the same machine.
When i am trying to create the report using SQL server relational db, i
am able to get the query designer. Please help me..
Dhar.
"JeffW" wrote:
> I cannot get my report to connect to my datacube. I've got RS running on a
> web server and Analysis Services running on another server. The two servers
> have an established relationship as i am currently able to run RS reports
> against the SQL Server relational db's that exist on the server that is
> running AS.
> When i try to execute a report against a cube i get "cannot connect to the
> server {myserver}. the server is either too busy or not started".
> The connection string i am using is:
> Provider=MSOLAP.2;Client Cache Size=25;Data Source={myserver};Auto Synch
> Period=10000;Initial Catalog={mycatalog}
> This all works fine in my dev environment where AS and RS run on the same
> server.
> What extra step am i missing to get my RS Web server to talk to my AS DB
> server?
> Thanks for any info.
>|||Dahr:
I was able to solve my problem. Turns out, port 2725 was not open between
my web and db servers. once i opened up that port everything runs fine.
As for your issue, if you are running version 1 of RS with sp1, it does not
support an mdx query designer. i believe that capability is scheduled for
the next release of Reporting services. For now, you just have to type the
mdx in, or use another mdx builder to get the query you need, and then
copy/paste it into rs.
Hope that helps.
JeffW
"Dhar" wrote:
> Sorry i do not know the answer for your question. But i am facing one
> problem.I am unable to get the query designer, to type the MDX query to get
> reports from my analysis server. I am using the Analysis server and web
> server on the same machine.
> When i am trying to create the report using SQL server relational db, i
> am able to get the query designer. Please help me..
>
> Dhar.
>
> "JeffW" wrote:
> > I cannot get my report to connect to my datacube. I've got RS running on a
> > web server and Analysis Services running on another server. The two servers
> > have an established relationship as i am currently able to run RS reports
> > against the SQL Server relational db's that exist on the server that is
> > running AS.
> >
> > When i try to execute a report against a cube i get "cannot connect to the
> > server {myserver}. the server is either too busy or not started".
> >
> > The connection string i am using is:
> > Provider=MSOLAP.2;Client Cache Size=25;Data Source={myserver};Auto Synch
> > Period=10000;Initial Catalog={mycatalog}
> >
> > This all works fine in my dev environment where AS and RS run on the same
> > server.
> >
> > What extra step am i missing to get my RS Web server to talk to my AS DB
> > server?
> >
> > Thanks for any info.
> >
> >

Report Bursting

Hello,
Is there a possibillity to use Report Bursting in reporting services ?Not in RS 2000. Don't know if in 2005 but I don't think so.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"oscar" <oscar@.discussions.microsoft.com> wrote in message
news:E6B6F6F5-C934-4B94-AA57-D5271DA7BCA3@.microsoft.com...
> Hello,
> Is there a possibillity to use Report Bursting in reporting services ?