Problem in creating endpoint

Hello Everybody,

I dont know whether this is right forum to post these type of query or not. but please help me in solving this problem.

I am creating Endpoint in sql server 2005.

but in very first line its giving error.

plz let me know whats wrong with this code.

USE [Northwind]

GO

CREATE ENDPOINT customer_endpoint

STATE=STARTED

AS HTTP (

PATH='/sql',

AUTHENTICATION= (INTEGRATED),

PORTS = (CLEAR),

SITE = '*'

)

FOR SOAP (

WEBMETHOD 'http://tempUri.org'.'GetCustomerInfo'

(

NAME='Northwind.dbo.upGetCustomer', FORMAT=ROWSETS_ONLY,

schema=STANDARD

),

WSDL=DEFAULT,

BATCHES=ENABLED,

DATABASE='Northwind'

)

GO

and the Error i am getting is:

Msg 170, Level 15, State 1, Line 2

Line 2: Incorrect syntax near 'ENDPOINT'.

Please Help me ASAP.

Regards,

Vineet

I just did a cut and paste of the DDL and it worked for me. I ran it against SQL2K5 RTM build. The Northwind database is not available by default with SQL2K5, even then it should merely fail by saying "Database not found".

Problem in creating endpoint

Hello Everybody,

I dont know whether this is right forum to post these type of query or not. but please help me in solving this problem.

I am creating Endpoint in sql server 2005.

but in very first line its giving error.

plz let me know whats wrong with this code.

USE [Northwind]

GO

CREATE ENDPOINT customer_endpoint

STATE=STARTED

AS HTTP (

PATH='/sql',

AUTHENTICATION= (INTEGRATED),

PORTS = (CLEAR),

SITE = '*'

)

FOR SOAP (

WEBMETHOD 'http://tempUri.org'.'GetCustomerInfo'

(

NAME='Northwind.dbo.upGetCustomer', FORMAT=ROWSETS_ONLY,

schema=STANDARD

),

WSDL=DEFAULT,

BATCHES=ENABLED,

DATABASE='Northwind'

)

GO

and the Error i am getting is:

Msg 170, Level 15, State 1, Line 2

Line 2: Incorrect syntax near 'ENDPOINT'.

Please Help me ASAP.

Regards,

Vineet

I just did a cut and paste of the DDL and it worked for me. I ran it against SQL2K5 RTM build. The Northwind database is not available by default with SQL2K5, even then it should merely fail by saying "Database not found".

sql

Problem in Calculating Total

Hi Everybody,

I need to generate report for all the days in a current month. I have to display the total in the folg. way.

Day1 Day2 etc.
Group Name sum of amount sum of amount
from day1 to end from day2 to end
of month of month

upto end of month.

I had a problem in setting the columns. And is there any way to calculate the group wise sum with out creating groups.

If you have any idea, pls. help me

Thanks,
harmonycitraHi,
I dont think it is possible to have groupwise total without creating group. You can group,find sum and suppress group header.

Madhivanan|||Thanks,

But I'd done it by Cross tab. The only difference is,

instead of starting from 1st to 31st, I reversed the order from end of month to beg. of month. So I'm calculating running total easily.

Any way, thank you!

Problem exporting to PDF

Hello everybody,
I can't render a report to PDF
and I get the following error :
"Internet Explorer cannot download Format=PDF from server
Internet Explorer was not able to open this Internet site. The requested
site is either unavailable or canot be found. Please try again later."
What it's weird is that other reports rendered to PDF, but this one!
Thanks for your help.
DomenicoWhat error do you see in the log file in your /ReportServer/LogFiles
directory? There should be a stack trace in there that you can will give us
more information.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Riddick" <Riddick@.discussions.microsoft.com> wrote in message
news:34B670EF-FB0D-4B31-9422-32DEDD7EB5B3@.microsoft.com...
> Hello everybody,
> I can't render a report to PDF
> and I get the following error :
> "Internet Explorer cannot download Format=PDF from server
> Internet Explorer was not able to open this Internet site. The requested
> site is either unavailable or canot be found. Please try again later."
> What it's weird is that other reports rendered to PDF, but this one!
> Thanks for your help.
> Domenico
>|||I thank you for your help.
Domenico
here below the stack trace of the error :
aspnet_wp!webserver!11c!04/22/2005-08:27:11:: e ERROR: Reporting Services
error
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. -->
Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. --> System.ArgumentOutOfRangeException: Index and length must refer
to a location within the string.
Parameter name: length
at System.String.Substring(Int32 startIndex, Int32 length)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.ProcessString(TextBox
context, String text, CanvasFontPDF font, CanvasPenPDF pen, Double left,
Double top, Double paddingTop, Double width, Double height, Boolean wordTrim,
String fontLanguage, Int32& charactersFitted, Int32& linesFilled, String&
streamString)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.DrawString(TextBox
context, OutlineObjects outlines, Boolean wordTrim, String text, CanvasFont
font, CanvasPen pen, Double left, Double top, Double paddingTop, Double
width, Double height, String fontLanguage, ReportUrl hyperLinkURL)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.TextBox.RenderToPage(Measurement parentClipBorder)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement parentClipBorder)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.TableCell.RenderToPage(Measurement parentClipBorder)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement parentClipBorder)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.TableRow.RenderToPage(Measurement parentClipBorder)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement parentClipBorder)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.Table.RenderToPage(Measurement parentClipBorder)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement parentClipBorder)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.Rectangle.RenderToPage(Measurement parentClipBorder)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement parentClipBorder)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.ProcessPages(CompositionBase
theComposition, Report theReport, Boolean needTotalPages, Int32 startPage,
Int32 endPage, Boolean render)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.PdfReport.RenderReport(Report
report, NameValueCollection deviceInfo, EvaluateHeaderFooterExpressions
evaluateHeaderFooterExpressions, CreateAndRegisterStream
createAndRegisterStreamCallback)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
report, NameValueCollection reportServerParameters, NameValueCollection
deviceInfo, NameValueCollection clientCapabilities,
EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
CreateAndRegisterStream createAndRegisterStream)
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
report, NameValueCollection reportServerParameters, NameValueCollection
deviceInfo, NameValueCollection clientCapabilities,
EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
CreateAndRegisterStream createAndRegisterStream)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk
createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk
createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
at
Microsoft.ReportingServices.Library.RSService.RenderFromSessionNoCache(CatalogItemContext reportContext, ClientRequest session, RenderingResult& result)
at
Microsoft.ReportingServices.Library.RSService.RenderFromSession(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters)
at
Microsoft.ReportingServices.Library.RSService.RenderNext(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effecectiveParameters, String[]&
secondaryStreamNames)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
"Donovan Smith [MSFT]" wrote:
> What error do you see in the log file in your /ReportServer/LogFiles
> directory? There should be a stack trace in there that you can will give us
> more information.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Riddick" <Riddick@.discussions.microsoft.com> wrote in message
> news:34B670EF-FB0D-4B31-9422-32DEDD7EB5B3@.microsoft.com...
> > Hello everybody,
> > I can't render a report to PDF
> > and I get the following error :
> >
> > "Internet Explorer cannot download Format=PDF from server
> > Internet Explorer was not able to open this Internet site. The requested
> > site is either unavailable or canot be found. Please try again later."
> >
> > What it's weird is that other reports rendered to PDF, but this one!
> >
> > Thanks for your help.
> > Domenico
> >
> >
>
>|||Please email me a copy of your .rdl and .rdl.data file. I'm curious why
you're hitting that.
Thank you.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Riddick" <Riddick@.discussions.microsoft.com> wrote in message
news:9D929115-2AD2-4570-ADDD-6CA362787AB6@.microsoft.com...
> I thank you for your help.
> Domenico
> here below the stack trace of the error :
> aspnet_wp!webserver!11c!04/22/2005-08:27:11:: e ERROR: Reporting Services
> error
> Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. -->
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. --> System.ArgumentOutOfRangeException: Index and length must
> refer
> to a location within the string.
> Parameter name: length
> at System.String.Substring(Int32 startIndex, Int32 length)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.ProcessString(TextBox
> context, String text, CanvasFontPDF font, CanvasPenPDF pen, Double left,
> Double top, Double paddingTop, Double width, Double height, Boolean
> wordTrim,
> String fontLanguage, Int32& charactersFitted, Int32& linesFilled, String&
> streamString)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.DrawString(TextBox
> context, OutlineObjects outlines, Boolean wordTrim, String text,
> CanvasFont
> font, CanvasPen pen, Double left, Double top, Double paddingTop, Double
> width, Double height, String fontLanguage, ReportUrl hyperLinkURL)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.TextBox.RenderToPage(Measurement
> parentClipBorder)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
> parentClipBorder)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.TableCell.RenderToPage(Measurement
> parentClipBorder)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
> parentClipBorder)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.TableRow.RenderToPage(Measurement
> parentClipBorder)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
> parentClipBorder)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.Table.RenderToPage(Measurement
> parentClipBorder)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
> parentClipBorder)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.Rectangle.RenderToPage(Measurement
> parentClipBorder)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
> parentClipBorder)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.ProcessPages(CompositionBase
> theComposition, Report theReport, Boolean needTotalPages, Int32 startPage,
> Int32 endPage, Boolean render)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.PdfReport.RenderReport(Report
> report, NameValueCollection deviceInfo, EvaluateHeaderFooterExpressions
> evaluateHeaderFooterExpressions, CreateAndRegisterStream
> createAndRegisterStreamCallback)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
> report, NameValueCollection reportServerParameters, NameValueCollection
> deviceInfo, NameValueCollection clientCapabilities,
> EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
> CreateAndRegisterStream createAndRegisterStream)
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
> report, NameValueCollection reportServerParameters, NameValueCollection
> deviceInfo, NameValueCollection clientCapabilities,
> EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
> CreateAndRegisterStream createAndRegisterStream)
> at
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk
> createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk
> createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
> at
> Microsoft.ReportingServices.Library.RSService.RenderFromSessionNoCache(CatalogItemContext
> reportContext, ClientRequest session, RenderingResult& result)
> at
> Microsoft.ReportingServices.Library.RSService.RenderFromSession(CatalogItemContext
> reportContext, ClientRequest session, Warning[]& warnings,
> ParameterInfoCollection& effectiveParameters)
> at
> Microsoft.ReportingServices.Library.RSService.RenderNext(CatalogItemContext
> reportContext, ClientRequest session, Warning[]& warnings,
> ParameterInfoCollection& effecectiveParameters, String[]&
> secondaryStreamNames)
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory
> streamFactory)
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType
> itemType)
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
>
> "Donovan Smith [MSFT]" wrote:
>> What error do you see in the log file in your /ReportServer/LogFiles
>> directory? There should be a stack trace in there that you can will give
>> us
>> more information.
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Riddick" <Riddick@.discussions.microsoft.com> wrote in message
>> news:34B670EF-FB0D-4B31-9422-32DEDD7EB5B3@.microsoft.com...
>> > Hello everybody,
>> > I can't render a report to PDF
>> > and I get the following error :
>> >
>> > "Internet Explorer cannot download Format=PDF from server
>> > Internet Explorer was not able to open this Internet site. The
>> > requested
>> > site is either unavailable or canot be found. Please try again later."
>> >
>> > What it's weird is that other reports rendered to PDF, but this one!
>> >
>> > Thanks for your help.
>> > Domenico
>> >
>> >
>>|||I'm sorry but I had been waiting for your answer for some days. Then I
decided to design again the same report from scratch and this time were not
problem.
Thank you
"Donovan Smith [MSFT]" wrote:
> Please email me a copy of your .rdl and .rdl.data file. I'm curious why
> you're hitting that.
> Thank you.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Riddick" <Riddick@.discussions.microsoft.com> wrote in message
> news:9D929115-2AD2-4570-ADDD-6CA362787AB6@.microsoft.com...
> >
> > I thank you for your help.
> > Domenico
> >
> > here below the stack trace of the error :
> >
> > aspnet_wp!webserver!11c!04/22/2005-08:27:11:: e ERROR: Reporting Services
> > error
> > Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
> > Exception of type
> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> > thrown. -->
> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
> > Exception of type
> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> > thrown. --> System.ArgumentOutOfRangeException: Index and length must
> > refer
> > to a location within the string.
> >
> > Parameter name: length
> >
> > at System.String.Substring(Int32 startIndex, Int32 length)
> >
> > at
> > Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.ProcessString(TextBox
> > context, String text, CanvasFontPDF font, CanvasPenPDF pen, Double left,
> > Double top, Double paddingTop, Double width, Double height, Boolean
> > wordTrim,
> > String fontLanguage, Int32& charactersFitted, Int32& linesFilled, String&
> > streamString)
> >
> > at
> > Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.DrawString(TextBox
> > context, OutlineObjects outlines, Boolean wordTrim, String text,
> > CanvasFont
> > font, CanvasPen pen, Double left, Double top, Double paddingTop, Double
> > width, Double height, String fontLanguage, ReportUrl hyperLinkURL)
> >
> > at
> > Microsoft.ReportingServices.Rendering.ImageRenderer.TextBox.RenderToPage(Measurement
> > parentClipBorder)
> >
> > at
> > Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
> > parentClipBorder)
> >
> > at
> > Microsoft.ReportingServices.Rendering.ImageRenderer.TableCell.RenderToPage(Measurement
> > parentClipBorder)
> >
> > at
> > Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
> > parentClipBorder)
> >
> > at
> > Microsoft.ReportingServices.Rendering.ImageRenderer.TableRow.RenderToPage(Measurement
> > parentClipBorder)
> >
> > at
> > Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
> > parentClipBorder)
> >
> > at
> > Microsoft.ReportingServices.Rendering.ImageRenderer.Table.RenderToPage(Measurement
> > parentClipBorder)
> >
> > at
> > Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
> > parentClipBorder)
> >
> > at
> > Microsoft.ReportingServices.Rendering.ImageRenderer.Rectangle.RenderToPage(Measurement
> > parentClipBorder)
> >
> > at
> > Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
> > parentClipBorder)
> >
> > at
> > Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.ProcessPages(CompositionBase
> > theComposition, Report theReport, Boolean needTotalPages, Int32 startPage,
> > Int32 endPage, Boolean render)
> >
> > at
> > Microsoft.ReportingServices.Rendering.ImageRenderer.PdfReport.RenderReport(Report
> > report, NameValueCollection deviceInfo, EvaluateHeaderFooterExpressions
> > evaluateHeaderFooterExpressions, CreateAndRegisterStream
> > createAndRegisterStreamCallback)
> >
> > at
> > Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
> > report, NameValueCollection reportServerParameters, NameValueCollection
> > deviceInfo, NameValueCollection clientCapabilities,
> > EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
> > CreateAndRegisterStream createAndRegisterStream)
> >
> > -- End of inner exception stack trace --
> >
> > at
> > Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
> > report, NameValueCollection reportServerParameters, NameValueCollection
> > deviceInfo, NameValueCollection clientCapabilities,
> > EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
> > CreateAndRegisterStream createAndRegisterStream)
> >
> > at
> > Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk
> > createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
> >
> > -- End of inner exception stack trace --
> >
> > at
> > Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk
> > createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
> >
> > at
> > Microsoft.ReportingServices.Library.RSService.RenderFromSessionNoCache(CatalogItemContext
> > reportContext, ClientRequest session, RenderingResult& result)
> >
> > at
> > Microsoft.ReportingServices.Library.RSService.RenderFromSession(CatalogItemContext
> > reportContext, ClientRequest session, Warning[]& warnings,
> > ParameterInfoCollection& effectiveParameters)
> >
> > at
> > Microsoft.ReportingServices.Library.RSService.RenderNext(CatalogItemContext
> > reportContext, ClientRequest session, Warning[]& warnings,
> > ParameterInfoCollection& effecectiveParameters, String[]&
> > secondaryStreamNames)
> >
> > at
> > Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory
> > streamFactory)
> >
> > at
> > Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
> >
> > at
> > Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType
> > itemType)
> >
> > at
> > Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
> >
> > at
> > Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
> >
> >
> >
> > "Donovan Smith [MSFT]" wrote:
> >
> >> What error do you see in the log file in your /ReportServer/LogFiles
> >> directory? There should be a stack trace in there that you can will give
> >> us
> >> more information.
> >>
> >> --
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "Riddick" <Riddick@.discussions.microsoft.com> wrote in message
> >> news:34B670EF-FB0D-4B31-9422-32DEDD7EB5B3@.microsoft.com...
> >> > Hello everybody,
> >> > I can't render a report to PDF
> >> > and I get the following error :
> >> >
> >> > "Internet Explorer cannot download Format=PDF from server
> >> > Internet Explorer was not able to open this Internet site. The
> >> > requested
> >> > site is either unavailable or canot be found. Please try again later."
> >> >
> >> > What it's weird is that other reports rendered to PDF, but this one!
> >> >
> >> > Thanks for your help.
> >> > Domenico
> >> >
> >> >
> >>
> >>
> >>
>
>|||Odd. :) Well, if you encounter it again, please send me those files so I
can take a look.
Thanks.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Riddick" <Riddick@.discussions.microsoft.com> wrote in message
news:C15ABB0A-7178-4ACD-BF85-5A47C1FC6EED@.microsoft.com...
> I'm sorry but I had been waiting for your answer for some days. Then I
> decided to design again the same report from scratch and this time were
> not
> problem.
> Thank you
>
> "Donovan Smith [MSFT]" wrote:
>> Please email me a copy of your .rdl and .rdl.data file. I'm curious why
>> you're hitting that.
>> Thank you.
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Riddick" <Riddick@.discussions.microsoft.com> wrote in message
>> news:9D929115-2AD2-4570-ADDD-6CA362787AB6@.microsoft.com...
>> >
>> > I thank you for your help.
>> > Domenico
>> >
>> > here below the stack trace of the error :
>> >
>> > aspnet_wp!webserver!11c!04/22/2005-08:27:11:: e ERROR: Reporting
>> > Services
>> > error
>> > Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
>> > Exception of type
>> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException
>> > was
>> > thrown. -->
>> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
>> > Exception of type
>> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException
>> > was
>> > thrown. --> System.ArgumentOutOfRangeException: Index and length must
>> > refer
>> > to a location within the string.
>> >
>> > Parameter name: length
>> >
>> > at System.String.Substring(Int32 startIndex, Int32 length)
>> >
>> > at
>> > Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.ProcessString(TextBox
>> > context, String text, CanvasFontPDF font, CanvasPenPDF pen, Double
>> > left,
>> > Double top, Double paddingTop, Double width, Double height, Boolean
>> > wordTrim,
>> > String fontLanguage, Int32& charactersFitted, Int32& linesFilled,
>> > String&
>> > streamString)
>> >
>> > at
>> > Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.DrawString(TextBox
>> > context, OutlineObjects outlines, Boolean wordTrim, String text,
>> > CanvasFont
>> > font, CanvasPen pen, Double left, Double top, Double paddingTop, Double
>> > width, Double height, String fontLanguage, ReportUrl hyperLinkURL)
>> >
>> > at
>> > Microsoft.ReportingServices.Rendering.ImageRenderer.TextBox.RenderToPage(Measurement
>> > parentClipBorder)
>> >
>> > at
>> > Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
>> > parentClipBorder)
>> >
>> > at
>> > Microsoft.ReportingServices.Rendering.ImageRenderer.TableCell.RenderToPage(Measurement
>> > parentClipBorder)
>> >
>> > at
>> > Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
>> > parentClipBorder)
>> >
>> > at
>> > Microsoft.ReportingServices.Rendering.ImageRenderer.TableRow.RenderToPage(Measurement
>> > parentClipBorder)
>> >
>> > at
>> > Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
>> > parentClipBorder)
>> >
>> > at
>> > Microsoft.ReportingServices.Rendering.ImageRenderer.Table.RenderToPage(Measurement
>> > parentClipBorder)
>> >
>> > at
>> > Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
>> > parentClipBorder)
>> >
>> > at
>> > Microsoft.ReportingServices.Rendering.ImageRenderer.Rectangle.RenderToPage(Measurement
>> > parentClipBorder)
>> >
>> > at
>> > Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
>> > parentClipBorder)
>> >
>> > at
>> > Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.ProcessPages(CompositionBase
>> > theComposition, Report theReport, Boolean needTotalPages, Int32
>> > startPage,
>> > Int32 endPage, Boolean render)
>> >
>> > at
>> > Microsoft.ReportingServices.Rendering.ImageRenderer.PdfReport.RenderReport(Report
>> > report, NameValueCollection deviceInfo, EvaluateHeaderFooterExpressions
>> > evaluateHeaderFooterExpressions, CreateAndRegisterStream
>> > createAndRegisterStreamCallback)
>> >
>> > at
>> > Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
>> > report, NameValueCollection reportServerParameters, NameValueCollection
>> > deviceInfo, NameValueCollection clientCapabilities,
>> > EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
>> > CreateAndRegisterStream createAndRegisterStream)
>> >
>> > -- End of inner exception stack trace --
>> >
>> > at
>> > Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
>> > report, NameValueCollection reportServerParameters, NameValueCollection
>> > deviceInfo, NameValueCollection clientCapabilities,
>> > EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
>> > CreateAndRegisterStream createAndRegisterStream)
>> >
>> > at
>> > Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk
>> > createChunkCallback, RenderingContext rc, GetResource
>> > getResourceCallback)
>> >
>> > -- End of inner exception stack trace --
>> >
>> > at
>> > Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk
>> > createChunkCallback, RenderingContext rc, GetResource
>> > getResourceCallback)
>> >
>> > at
>> > Microsoft.ReportingServices.Library.RSService.RenderFromSessionNoCache(CatalogItemContext
>> > reportContext, ClientRequest session, RenderingResult& result)
>> >
>> > at
>> > Microsoft.ReportingServices.Library.RSService.RenderFromSession(CatalogItemContext
>> > reportContext, ClientRequest session, Warning[]& warnings,
>> > ParameterInfoCollection& effectiveParameters)
>> >
>> > at
>> > Microsoft.ReportingServices.Library.RSService.RenderNext(CatalogItemContext
>> > reportContext, ClientRequest session, Warning[]& warnings,
>> > ParameterInfoCollection& effecectiveParameters, String[]&
>> > secondaryStreamNames)
>> >
>> > at
>> > Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory
>> > streamFactory)
>> >
>> > at
>> > Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
>> >
>> > at
>> > Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType
>> > itemType)
>> >
>> > at
>> > Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
>> >
>> > at
>> > Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
>> >
>> >
>> >
>> > "Donovan Smith [MSFT]" wrote:
>> >
>> >> What error do you see in the log file in your /ReportServer/LogFiles
>> >> directory? There should be a stack trace in there that you can will
>> >> give
>> >> us
>> >> more information.
>> >>
>> >> --
>> >> This posting is provided "AS IS" with no warranties, and confers no
>> >> rights.
>> >>
>> >>
>> >> "Riddick" <Riddick@.discussions.microsoft.com> wrote in message
>> >> news:34B670EF-FB0D-4B31-9422-32DEDD7EB5B3@.microsoft.com...
>> >> > Hello everybody,
>> >> > I can't render a report to PDF
>> >> > and I get the following error :
>> >> >
>> >> > "Internet Explorer cannot download Format=PDF from server
>> >> > Internet Explorer was not able to open this Internet site. The
>> >> > requested
>> >> > site is either unavailable or canot be found. Please try again
>> >> > later."
>> >> >
>> >> > What it's weird is that other reports rendered to PDF, but this one!
>> >> >
>> >> > Thanks for your help.
>> >> > Domenico
>> >> >
>> >> >
>> >>
>> >>
>> >>
>>|||You bet ! :)
Thanks.
"Donovan Smith [MSFT]" wrote:
> Odd. :) Well, if you encounter it again, please send me those files so I
> can take a look.
> Thanks.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Riddick" <Riddick@.discussions.microsoft.com> wrote in message
> news:C15ABB0A-7178-4ACD-BF85-5A47C1FC6EED@.microsoft.com...
> >
> > I'm sorry but I had been waiting for your answer for some days. Then I
> > decided to design again the same report from scratch and this time were
> > not
> > problem.
> >
> > Thank you
> >
> >
> > "Donovan Smith [MSFT]" wrote:
> >
> >> Please email me a copy of your .rdl and .rdl.data file. I'm curious why
> >> you're hitting that.
> >>
> >> Thank you.
> >>
> >> --
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "Riddick" <Riddick@.discussions.microsoft.com> wrote in message
> >> news:9D929115-2AD2-4570-ADDD-6CA362787AB6@.microsoft.com...
> >> >
> >> > I thank you for your help.
> >> > Domenico
> >> >
> >> > here below the stack trace of the error :
> >> >
> >> > aspnet_wp!webserver!11c!04/22/2005-08:27:11:: e ERROR: Reporting
> >> > Services
> >> > error
> >> > Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
> >> > Exception of type
> >> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException
> >> > was
> >> > thrown. -->
> >> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
> >> > Exception of type
> >> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException
> >> > was
> >> > thrown. --> System.ArgumentOutOfRangeException: Index and length must
> >> > refer
> >> > to a location within the string.
> >> >
> >> > Parameter name: length
> >> >
> >> > at System.String.Substring(Int32 startIndex, Int32 length)
> >> >
> >> > at
> >> > Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.ProcessString(TextBox
> >> > context, String text, CanvasFontPDF font, CanvasPenPDF pen, Double
> >> > left,
> >> > Double top, Double paddingTop, Double width, Double height, Boolean
> >> > wordTrim,
> >> > String fontLanguage, Int32& charactersFitted, Int32& linesFilled,
> >> > String&
> >> > streamString)
> >> >
> >> > at
> >> > Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.DrawString(TextBox
> >> > context, OutlineObjects outlines, Boolean wordTrim, String text,
> >> > CanvasFont
> >> > font, CanvasPen pen, Double left, Double top, Double paddingTop, Double
> >> > width, Double height, String fontLanguage, ReportUrl hyperLinkURL)
> >> >
> >> > at
> >> > Microsoft.ReportingServices.Rendering.ImageRenderer.TextBox.RenderToPage(Measurement
> >> > parentClipBorder)
> >> >
> >> > at
> >> > Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
> >> > parentClipBorder)
> >> >
> >> > at
> >> > Microsoft.ReportingServices.Rendering.ImageRenderer.TableCell.RenderToPage(Measurement
> >> > parentClipBorder)
> >> >
> >> > at
> >> > Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
> >> > parentClipBorder)
> >> >
> >> > at
> >> > Microsoft.ReportingServices.Rendering.ImageRenderer.TableRow.RenderToPage(Measurement
> >> > parentClipBorder)
> >> >
> >> > at
> >> > Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
> >> > parentClipBorder)
> >> >
> >> > at
> >> > Microsoft.ReportingServices.Rendering.ImageRenderer.Table.RenderToPage(Measurement
> >> > parentClipBorder)
> >> >
> >> > at
> >> > Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
> >> > parentClipBorder)
> >> >
> >> > at
> >> > Microsoft.ReportingServices.Rendering.ImageRenderer.Rectangle.RenderToPage(Measurement
> >> > parentClipBorder)
> >> >
> >> > at
> >> > Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
> >> > parentClipBorder)
> >> >
> >> > at
> >> > Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.ProcessPages(CompositionBase
> >> > theComposition, Report theReport, Boolean needTotalPages, Int32
> >> > startPage,
> >> > Int32 endPage, Boolean render)
> >> >
> >> > at
> >> > Microsoft.ReportingServices.Rendering.ImageRenderer.PdfReport.RenderReport(Report
> >> > report, NameValueCollection deviceInfo, EvaluateHeaderFooterExpressions
> >> > evaluateHeaderFooterExpressions, CreateAndRegisterStream
> >> > createAndRegisterStreamCallback)
> >> >
> >> > at
> >> > Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
> >> > report, NameValueCollection reportServerParameters, NameValueCollection
> >> > deviceInfo, NameValueCollection clientCapabilities,
> >> > EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
> >> > CreateAndRegisterStream createAndRegisterStream)
> >> >
> >> > -- End of inner exception stack trace --
> >> >
> >> > at
> >> > Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
> >> > report, NameValueCollection reportServerParameters, NameValueCollection
> >> > deviceInfo, NameValueCollection clientCapabilities,
> >> > EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
> >> > CreateAndRegisterStream createAndRegisterStream)
> >> >
> >> > at
> >> > Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk
> >> > createChunkCallback, RenderingContext rc, GetResource
> >> > getResourceCallback)
> >> >
> >> > -- End of inner exception stack trace --
> >> >
> >> > at
> >> > Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk
> >> > createChunkCallback, RenderingContext rc, GetResource
> >> > getResourceCallback)
> >> >
> >> > at
> >> > Microsoft.ReportingServices.Library.RSService.RenderFromSessionNoCache(CatalogItemContext
> >> > reportContext, ClientRequest session, RenderingResult& result)
> >> >
> >> > at
> >> > Microsoft.ReportingServices.Library.RSService.RenderFromSession(CatalogItemContext
> >> > reportContext, ClientRequest session, Warning[]& warnings,
> >> > ParameterInfoCollection& effectiveParameters)
> >> >
> >> > at
> >> > Microsoft.ReportingServices.Library.RSService.RenderNext(CatalogItemContext
> >> > reportContext, ClientRequest session, Warning[]& warnings,
> >> > ParameterInfoCollection& effecectiveParameters, String[]&
> >> > secondaryStreamNames)
> >> >
> >> > at
> >> > Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory
> >> > streamFactory)
> >> >
> >> > at
> >> > Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
> >> >
> >> > at
> >> > Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType
> >> > itemType)
> >> >
> >> > at
> >> > Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
> >> >
> >> > at
> >> > Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
> >> >
> >> >
> >> >
> >> > "Donovan Smith [MSFT]" wrote:
> >> >
> >> >> What error do you see in the log file in your /ReportServer/LogFiles
> >> >> directory? There should be a stack trace in there that you can will
> >> >> give
> >> >> us
> >> >> more information.
> >> >>
> >> >> --
> >> >> This posting is provided "AS IS" with no warranties, and confers no
> >> >> rights.
> >> >>
> >> >>
> >> >> "Riddick" <Riddick@.discussions.microsoft.com> wrote in message
> >> >> news:34B670EF-FB0D-4B31-9422-32DEDD7EB5B3@.microsoft.com...
> >> >> > Hello everybody,
> >> >> > I can't render a report to PDF
> >> >> > and I get the following error :
> >> >> >
> >> >> > "Internet Explorer cannot download Format=PDF from server
> >> >> > Internet Explorer was not able to open this Internet site. The
> >> >> > requested
> >> >> > site is either unavailable or canot be found. Please try again
> >> >> > later."
> >> >> >
> >> >> > What it's weird is that other reports rendered to PDF, but this one!
> >> >> >
> >> >> > Thanks for your help.
> >> >> > Domenico
> >> >> >
> >> >> >
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>

Problem creating database dynamically

Hi everybody,

I have a problem. When I try to create a database with this code:

strConnection = "server=(local);Integrated Security=SSPI"
objConnection = New SqlConnection(strConnection)
objConnection.Open()
Dim strSQL = "CREATE DATABASE xxxxxx ON PRIMARY"
strSQL += "(Name=test_data, filename = 'xxxxx.mdf', size=3,"
strSQL += "maxsize=5, filegrowth=10%)log on"
strSQL += "(name=mydbb_log, filename='xxxxx.ldf',size=3,"
strSQL += "maxsize=20,filegrowth=1)"
objCommand = New SqlCommand(strSQL, objConnection)
objCommand.ExecuteNonQuery()

it usually works, except when the name of the database (xxxxxx) contains a number in the beginning of the name or if it is all made up completely by numbers. I also converted the database name into a string, but it doesn't work either.

What is the problem?
How can I solve it?

Thanks in advanceEither don't allow all digits or the first character to be a digit or you might try using [] around then database name. Works for fields, may work for the database name.