rsInternalError Reporting Server error !

Salam,

I get this error, if any one can help me

An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get For more information about this error navigate to the report server on the local server machine, or enable remote errors

But I could solve the problem by restarting the IIS , so each time this message appear I restart the IIS and the ReportServer's will work but after some time the problem again will appear . I think the problem with cache in IIS because the session still opened and not closed so how I can solve this

Hi,

Try to set up the "Recycle worker process (in minutes)" to shorter frequency in the report server application pool.

Also, you will be able to find detaild information about the service health in the log files at "Microsoft SQL Server\MSSQL.n\Reporting Services\LogFiles" folder.

Regards,

Janos

|||

Thanks,

I set up the "Recycle worker process (in minutes)" to 60 minutes and I will see .

and this is the log file for today

<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.3042.00</Product>
<Locale>en-US</Locale>
<TimeZone>Jerusalem Standard Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServer__07_04_2007_12_56_21.log</Path>
<SystemName>PAYROLL</SystemName>
<OSName>Microsoft Windows NT 5.2.3790 Service Pack 2, v.4035</OSName>
<OSVersion>5.2.3790.131072</OSVersion>
</Header>
w3wp!webserver!1!04/07/2007-12:56:21:: i INFO: Reporting Web Server started
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!resourceutilities!1!04/07/2007-12:56:22:: i INFO: Reporting Services starting SKU: Developer
w3wp!resourceutilities!1!04/07/2007-12:56:22:: i INFO: Evaluation copy: 0 days left
w3wp!runningjobs!1!04/07/2007-12:56:22:: i INFO: Database Cleanup (Web Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
w3wp!runningjobs!1!04/07/2007-12:56:22:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!1!04/07/2007-12:56:22:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!1!04/07/2007-12:56:22:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!library!1!07/04/2007-12:56:24:: Call to GetPermissionsAction(/).
w3wp!library!1!07/04/2007-12:56:24:: i INFO: Catalog SQL Server Edition = Developer
w3wp!library!1!07/04/2007-12:56:24:: Call to GetPropertiesAction(/, PathBased).
w3wp!library!5!07/04/2007-12:56:24:: Call to GetSystemPermissionsAction().
w3wp!library!7!07/04/2007-12:56:24:: Call to ListChildrenAction(/, False).
w3wp!library!6!07/04/2007-12:56:24:: Call to GetSystemPropertiesAction().
w3wp!library!7!07/04/2007-12:56:39:: Call to GetPermissionsAction(/Payroll).
w3wp!library!7!07/04/2007-12:56:39:: Call to GetPropertiesAction(/Payroll, PathBased).
w3wp!library!7!07/04/2007-12:56:39:: Call to GetSystemPermissionsAction().
w3wp!library!6!07/04/2007-12:56:39:: Call to ListChildrenAction(/Payroll, False).
w3wp!library!6!07/04/2007-12:56:39:: Call to GetSystemPropertiesAction().
w3wp!library!7!07/04/2007-12:56:44:: Call to GetPermissionsAction(/Payroll/Company).
w3wp!library!7!07/04/2007-12:56:44:: Call to GetPropertiesAction(/Payroll/Company, PathBased).
w3wp!library!7!07/04/2007-12:56:44:: Call to GetSystemPermissionsAction().
w3wp!library!7!07/04/2007-12:56:44:: Call to ListChildrenAction(/Payroll/Company, False).
w3wp!library!6!07/04/2007-12:56:44:: Call to GetSystemPropertiesAction().
w3wp!library!5!07/04/2007-12:56:46:: Call to GetPermissionsAction(/Payroll/Company/ASU-HR).
w3wp!library!7!07/04/2007-12:56:46:: Call to GetSystemPermissionsAction().
w3wp!library!7!07/04/2007-12:56:48:: Call to GetDataSourceContentsAction(/Payroll/Company/ASU-HR).
w3wp!library!5!07/04/2007-12:56:48:: Call to GetPropertiesAction(/Payroll/Company/ASU-HR, PathBased).
w3wp!library!6!07/04/2007-12:56:48:: Call to ListChildrenAction(/, False).
w3wp!library!6!07/04/2007-12:56:48:: Call to ListChildrenAction(/Payroll, False).
w3wp!library!6!07/04/2007-12:56:49:: Call to ListChildrenAction(/Payroll/Company, False).
w3wp!library!7!07/04/2007-12:56:49:: Call to ListChildrenAction(/, False).
w3wp!library!7!07/04/2007-12:56:49:: Call to ListChildrenAction(/Payroll, False).
w3wp!library!7!07/04/2007-12:56:49:: Call to ListChildrenAction(/Payroll/Company, False).
w3wp!library!5!07/04/2007-12:56:49:: Call to GetSystemPropertiesAction().
w3wp!library!7!07/04/2007-12:59:05:: Call to GetItemTypeAction(/Payroll/Company/rpt_EmployeeInsuranceCard).
w3wp!library!7!07/04/2007-12:59:05:: i INFO: Call to RenderFirst( '/Payroll/Company/rpt_EmployeeInsuranceCard' )
w3wp!library!7!07/04/2007-12:59:09:: Using folder C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\RSTempFiles for temporary files.
w3wp!webserver!7!07/04/2007-12:59:10:: i INFO: Processed report. Report='/Payroll/Company/rpt_EmployeeInsuranceCard', Stream=''
w3wp!library!5!07/04/2007-12:59:11:: Call to GetItemTypeAction(/Payroll/Company/rpt_EmployeeInsuranceCard).
w3wp!library!5!07/04/2007-12:59:11:: i INFO: Call to RenderNext( '/Payroll/Company/rpt_EmployeeInsuranceCard' )
w3wp!cache!5!07/04/2007-12:59:11:: i INFO: Session live: /Payroll/Company/rpt_EmployeeInsuranceCard
w3wp!webserver!5!07/04/2007-12:59:11:: i INFO: Processed report. Report='/Payroll/Company/rpt_EmployeeInsuranceCard', Stream=''
w3wp!library!6!07/04/2007-12:59:19:: Call to GetItemTypeAction(/Payroll/Company/rpt_EmployeeInsuranceCard).
w3wp!library!6!07/04/2007-12:59:19:: i INFO: Call to RenderNext( '/Payroll/Company/rpt_EmployeeInsuranceCard' )
w3wp!cache!6!07/04/2007-12:59:19:: i INFO: Session live: /Payroll/Company/rpt_EmployeeInsuranceCard
w3wp!webserver!6!07/04/2007-12:59:22:: i INFO: Processed report. Report='/Payroll/Company/rpt_EmployeeInsuranceCard', Stream=''
w3wp!library!6!07/04/2007-13:04:10:: Call to GetItemTypeAction(/Payroll/Company/rpt_EmployeeTranspotationCard).
w3wp!library!6!07/04/2007-13:04:10:: i INFO: Call to RenderFirst( '/Payroll/Company/rpt_EmployeeTranspotationCard' )
w3wp!webserver!6!07/04/2007-13:04:11:: i INFO: Processed report. Report='/Payroll/Company/rpt_EmployeeTranspotationCard', Stream=''
w3wp!library!7!07/04/2007-13:04:17:: Call to GetItemTypeAction(/Payroll/Company/rpt_EmployeeTranspotationCard).
w3wp!library!7!07/04/2007-13:04:17:: i INFO: Call to RenderNext( '/Payroll/Company/rpt_EmployeeTranspotationCard' )
w3wp!cache!7!07/04/2007-13:04:17:: i INFO: Session live: /Payroll/Company/rpt_EmployeeTranspotationCard
w3wp!webserver!7!07/04/2007-13:04:17:: i INFO: Processed report. Report='/Payroll/Company/rpt_EmployeeTranspotationCard', Stream=''
w3wp!library!6!7/4/2007-13:06:22:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams

|||

again the problem still exist even after I set up the Recycle worker process to 60 m .

what I can do to solve this problem.

|||Well, you must check the log files for more details to this error. Please check all log files in the directory I specified before. (just the today's file )|||

which log files there is a lot of todays files .

|||Try to check the ReportServerService_main.log, ReportServerWebApp.log.

rsInternalError

I get this error message while deploying report:
An internal error occurred on the report server.
See the error log for more details. (rsInternalError)
Invalid text, ntext, or image pointer value
0xFDFF7F5F000000000303000001000200.
The statement has been terminated.
This happens to all reports I am trying to deploy either through VS.NET or
froom rds file
How do I resolve it?
Thanks,
-StanHI,
Did you ever resolve this issue? I'm getting the same message. Just
started during my last attempt to deploy.
thanks
"Stan" wrote:
> I get this error message while deploying report:
> An internal error occurred on the report server.
> See the error log for more details. (rsInternalError)
> Invalid text, ntext, or image pointer value
> 0xFDFF7F5F000000000303000001000200.
> The statement has been terminated.
> This happens to all reports I am trying to deploy either through VS.NET or
> froom rds file
> How do I resolve it?
>
> Thanks,
> -Stan
>
>

RS.exe

I have a web based application that allows users to apply for
employment via the web. Once the appllcaition is submitted I want to
send the details to HR via email using SSRS 2005.
I'm not very familiar with rs.exe utility which is the tool I think I
need to use.
I would appreciate it if anyone has done something like this before
and can point me in the right direction it would be greatly
appreciated.On Sep 14, 4:51 pm, NC3 <ncolem...@.yahoo.com> wrote:
> I have a web based application that allows users to apply for
> employment via the web. Once the appllcaition is submitted I want to
> send the details to HR via email using SSRS 2005.
> I'm not very familiar with rs.exe utility which is the tool I think I
> need to use.
> I would appreciate it if anyone has done something like this before
> and can point me in the right direction it would be greatly
> appreciated.
One alternative is to design an ASP.NET application that sends emails
and then attach a URL to the email that basically allows the user to
export the report to a standard format (i.e., PDF). An example of a
URL to send in an email is as follows:
http://ServerA/reportserver?/ExampleReportFolderName/ExampleReportName&rs:Command=Render&ParameterName=xxxxx&rs:Format=PDF
In this example, the format is as follows:
http://<ServerName>/reportserver?/<Directory>/<ReportName>&rs:Command=Render&<ParameterName>=<ParameterValue>&rs:Format=<PDF/CSV/XML/Excel/MHTML>
Of course, if you have multiple parameters you would include extra '&'
symbols and parameter values; and, you could change the export format.
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||On Sep 14, 10:49 pm, EMartinez <emartinez...@.gmail.com> wrote:
> On Sep 14, 4:51 pm, NC3 <ncolem...@.yahoo.com> wrote:
> > I have a web based application that allows users to apply for
> > employment via the web. Once the appllcaition is submitted I want to
> > send the details to HR via email using SSRS 2005.
> > I'm not very familiar with rs.exe utility which is the tool I think I
> > need to use.
> > I would appreciate it if anyone has done something like this before
> > and can point me in the right direction it would be greatly
> > appreciated.
> One alternative is to design an ASP.NET application that sends emails
> and then attach a URL to the email that basically allows the user to
> export the report to a standard format (i.e., PDF). An example of a
> URL to send in an email is as follows:http://ServerA/reportserver?/Exampl=
eReportFolderName/ExampleReportNam...
> In this example, the format is as follows:
> http://<ServerName>/reportserver?/<Directory>/<ReportName>&rs:Command=3DR=
ende=ADr&<ParameterName>=3D<ParameterValue>&rs:Format=3D<PDF/CSV/XML/Excel/=MHTML>
> Of course, if you have multiple parameters you would include extra '&'
> symbols and parameter values; and, you could change the export format.
> Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
Thanks for the response...
One important detail I did not mention is we have security concerns
sending plain text emails from the Internet. I want to send the email
after the DB is updated so the email is secure in transmission.|||On Sep 17, 2:54 pm, NC3 <ncolem...@.yahoo.com> wrote:
> On Sep 14, 10:49 pm, EMartinez <emartinez...@.gmail.com> wrote:
>
> > On Sep 14, 4:51 pm, NC3 <ncolem...@.yahoo.com> wrote:
> > > I have a web based application that allows users to apply for
> > > employment via the web. Once the appllcaition is submitted I want to
> > > send the details to HR via email using SSRS 2005.
> > > I'm not very familiar with rs.exe utility which is the tool I think I
> > > need to use.
> > > I would appreciate it if anyone has done something like this before
> > > and can point me in the right direction it would be greatly
> > > appreciated.
> > One alternative is to design an ASP.NET application that sends emails
> > and then attach a URL to the email that basically allows the user to
> > export the report to a standard format (i.e., PDF). An example of a
> > URL to send in an email is as follows:http://ServerA/reportserver?/Exam=
pleReportFolderName/ExampleReportNam...
> > In this example, the format is as follows:
> > http://<ServerName>/reportserver?/<Directory>/<ReportName>&rs:Command=
=3DRende=ADr&<ParameterName>=3D<ParameterValue>&rs:Format=3D<PDF/CSV/XML/Ex=cel/MHTML>
> > Of course, if you have multiple parameters you would include extra '&'
> > symbols and parameter values; and, you could change the export format.
> > Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
> Thanks for the response...
> One important detail I did not mention is we have security concerns
> sending plain text emails from the Internet. I want to send the email
> after the DB is updated so the email is secure in transmission.
Have you considered an SSL certificate? This should secure the
download part of the process. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||On Sep 17, 9:08 pm, EMartinez <emartinez...@.gmail.com> wrote:
> On Sep 17, 2:54 pm, NC3 <ncolem...@.yahoo.com> wrote:
>
>
> > On Sep 14, 10:49 pm, EMartinez <emartinez...@.gmail.com> wrote:
> > > On Sep 14, 4:51 pm, NC3 <ncolem...@.yahoo.com> wrote:
> > > > I have a web based application that allows users to apply for
> > > > employment via the web. Once the appllcaition is submitted I want to
> > > > send the details to HR via email using SSRS 2005.
> > > > I'm not very familiar with rs.exe utility which is the tool I think= I
> > > > need to use.
> > > > I would appreciate it if anyone has done something like this before
> > > > and can point me in the right direction it would be greatly
> > > > appreciated.
> > > One alternative is to design an ASP.NET application that sends emails
> > > and then attach a URL to the email that basically allows the user to
> > > export the report to a standard format (i.e., PDF). An example of a
> > > URL to send in an email is as follows:http://ServerA/reportserver?/Ex=
ampleReportFolderName/ExampleReportNam...
> > > In this example, the format is as follows:
> > > http://<ServerName>/reportserver?/<Directory>/<ReportName>&rs:Command=
=3DRende=AD=ADr&<ParameterName>=3D<ParameterValue>&rs:Format=3D<PDF/CSV/XML=/Excel/MHTML>
> > > Of course, if you have multiple parameters you would include extra '&'
> > > symbols and parameter values; and, you could change the export format.
> > > Hope this helps.
> > > Regards,
> > > Enrique Martinez
> > > Sr. Software Consultant
> > Thanks for the response...
> > One important detail I did not mention is we have security concerns
> > sending plain text emails from the Internet. I want to send the email
> > after the DB is updated so the email is secure in transmission.
> Have you considered an SSL certificate? This should secure the
> download part of the process. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant- Hide quoted text -
> - Show quoted text -
Will having an SSL in place secure an email from an ASP.NET
application in transit? That's our true concern...securing the data in
transit.
Thanks again for you help.|||On Sep 18, 1:03 pm, NC3 <ncolem...@.yahoo.com> wrote:
> On Sep 17, 9:08 pm, EMartinez <emartinez...@.gmail.com> wrote:
>
> > On Sep 17, 2:54 pm, NC3 <ncolem...@.yahoo.com> wrote:
> > > On Sep 14, 10:49 pm, EMartinez <emartinez...@.gmail.com> wrote:
> > > > On Sep 14, 4:51 pm, NC3 <ncolem...@.yahoo.com> wrote:
> > > > > I have a web based application that allows users to apply for
> > > > > employment via the web. Once the appllcaition is submitted I want= to
> > > > > send the details to HR via email using SSRS 2005.
> > > > > I'm not very familiar with rs.exe utility which is the tool I thi=nk I
> > > > > need to use.
> > > > > I would appreciate it if anyone has done something like this befo=re
> > > > > and can point me in the right direction it would be greatly
> > > > > appreciated.
> > > > One alternative is to design an ASP.NET application that sends emai=ls
> > > > and then attach a URL to the email that basically allows the user to
> > > > export the report to a standard format (i.e., PDF). An example of a
> > > > URL to send in an email is as follows:http://ServerA/reportserver?/=
ExampleReportFolderName/ExampleReportNam...
> > > > In this example, the format is as follows:
> > > > http://<ServerName>/reportserver?/<Directory>/<ReportName>&rs:Comma=
nd=3DRende=AD=ADr&<ParameterName>=3D<ParameterValue>&rs:Format=3D<PDF/CSV/X=ML/Excel/MHTML>
> > > > Of course, if you have multiple parameters you would include extra ='&'
> > > > symbols and parameter values; and, you could change the export form=at.
> > > > Hope this helps.
> > > > Regards,
> > > > Enrique Martinez
> > > > Sr. Software Consultant
> > > Thanks for the response...
> > > One important detail I did not mention is we have security concerns
> > > sending plain text emails from the Internet. I want to send the email
> > > after the DB is updated so the email is secure in transmission.
> > Have you considered an SSL certificate? This should secure the
> > download part of the process. Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant- Hide quoted text -
> > - Show quoted text -
> Will having an SSL in place secure an email from an ASP.NET
> application in transit? That's our true concern...securing the data in
> transit.
> Thanks again for you help.
For the email itself, I'm not completely sure; however, an SSL
certificate will improve security at the website level. In terms of
the exported report, you might want to look into some 3rd party PGP/
Encryption tools. There are a couple available that are open source
and some that aren't. This option should provide protection in
transit. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||On Sep 19, 8:28 am, EMartinez <emartinez...@.gmail.com> wrote:
> On Sep 18, 1:03 pm, NC3 <ncolem...@.yahoo.com> wrote:
>
>
> > On Sep 17, 9:08 pm, EMartinez <emartinez...@.gmail.com> wrote:
> > > On Sep 17, 2:54 pm, NC3 <ncolem...@.yahoo.com> wrote:
> > > > On Sep 14, 10:49 pm, EMartinez <emartinez...@.gmail.com> wrote:
> > > > > On Sep 14, 4:51 pm, NC3 <ncolem...@.yahoo.com> wrote:
> > > > > > I have a web based application that allows users to apply for
> > > > > > employment via the web. Once the appllcaition is submitted I wa=nt to
> > > > > > send the details to HR via email using SSRS 2005.
> > > > > > I'm not very familiar with rs.exe utility which is the tool I t=hink I
> > > > > > need to use.
> > > > > > I would appreciate it if anyone has done something like this be=fore
> > > > > > and can point me in the right direction it would be greatly
> > > > > > appreciated.
> > > > > One alternative is to design an ASP.NET application that sends em=ails
> > > > > and then attach a URL to the email that basically allows the user= to
> > > > > export the report to a standard format (i.e., PDF). An example of= a
> > > > > URL to send in an email is as follows:http://ServerA/reportserver=
?/ExampleReportFolderName/ExampleReportNam...
> > > > > In this example, the format is as follows:
> > > > > http://<ServerName>/reportserver?/<Directory>/<ReportName>&rs:Com=
mand=3DRende=AD=AD=ADr&<ParameterName>=3D<ParameterValue>&rs:Format=3D<PDF/=CSV/XML/Excel/MHTML>
> > > > > Of course, if you have multiple parameters you would include extr=a '&'
> > > > > symbols and parameter values; and, you could change the export fo=rmat.
> > > > > Hope this helps.
> > > > > Regards,
> > > > > Enrique Martinez
> > > > > Sr. Software Consultant
> > > > Thanks for the response...
> > > > One important detail I did not mention is we have security concerns
> > > > sending plain text emails from the Internet. I want to send the ema=il
> > > > after the DB is updated so the email is secure in transmission.
> > > Have you considered an SSL certificate? This should secure the
> > > download part of the process. Hope this helps.
> > > Regards,
> > > Enrique Martinez
> > > Sr. Software Consultant- Hide quoted text -
> > > - Show quoted text -
> > Will having an SSL in place secure an email from an ASP.NET
> > application in transit? That's our true concern...securing the data in
> > transit.
> > Thanks again for you help.
> For the email itself, I'm not completely sure; however, an SSL
> certificate will improve security at the website level. In terms of
> the exported report, you might want to look into some 3rd party PGP/
> Encryption tools. There are a couple available that are open source
> and some that aren't. This option should provide protection in
> transit. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant- Hide quoted text -
> - Show quoted text -
Your responses have been a big help. Thanks for the advice!|||On Sep 19, 4:07 pm, NC3 <ncolem...@.yahoo.com> wrote:
> On Sep 19, 8:28 am, EMartinez <emartinez...@.gmail.com> wrote:
>
> > On Sep 18, 1:03 pm, NC3 <ncolem...@.yahoo.com> wrote:
> > > On Sep 17, 9:08 pm, EMartinez <emartinez...@.gmail.com> wrote:
> > > > On Sep 17, 2:54 pm, NC3 <ncolem...@.yahoo.com> wrote:
> > > > > On Sep 14, 10:49 pm, EMartinez <emartinez...@.gmail.com> wrote:
> > > > > > On Sep 14, 4:51 pm, NC3 <ncolem...@.yahoo.com> wrote:
> > > > > > > I have a web based application that allows users to apply for
> > > > > > > employment via the web. Once the appllcaition is submitted I =want to
> > > > > > > send the details to HR via email using SSRS 2005.
> > > > > > > I'm not very familiar with rs.exe utility which is the tool I= think I
> > > > > > > need to use.
> > > > > > > I would appreciate it if anyone has done something like this =before
> > > > > > > and can point me in the right direction it would be greatly
> > > > > > > appreciated.
> > > > > > One alternative is to design an ASP.NET application that sends =emails
> > > > > > and then attach a URL to the email that basically allows the us=er to
> > > > > > export the report to a standard format (i.e., PDF). An example =of a
> > > > > > URL to send in an email is as follows:http://ServerA/reportserv=
er?/ExampleReportFolderName/ExampleReportNam...
> > > > > > In this example, the format is as follows:
> > > > > > http://<ServerName>/reportserver?/<Directory>/<ReportName>&rs:C=
ommand=3DRende=AD=AD=ADr&<ParameterName>=3D<ParameterValue>&rs:Format=3D<PD=F/CSV/XML/Excel/MHTML>
> > > > > > Of course, if you have multiple parameters you would include ex=tra '&'
> > > > > > symbols and parameter values; and, you could change the export =format.
> > > > > > Hope this helps.
> > > > > > Regards,
> > > > > > Enrique Martinez
> > > > > > Sr. Software Consultant
> > > > > Thanks for the response...
> > > > > One important detail I did not mention is we have security concer=ns
> > > > > sending plain text emails from the Internet. I want to send the e=mail
> > > > > after the DB is updated so the email is secure in transmission.
> > > > Have you considered an SSL certificate? This should secure the
> > > > download part of the process. Hope this helps.
> > > > Regards,
> > > > Enrique Martinez
> > > > Sr. Software Consultant- Hide quoted text -
> > > > - Show quoted text -
> > > Will having an SSL in place secure an email from an ASP.NET
> > > application in transit? That's our true concern...securing the data in
> > > transit.
> > > Thanks again for you help.
> > For the email itself, I'm not completely sure; however, an SSL
> > certificate will improve security at the website level. In terms of
> > the exported report, you might want to look into some 3rd party PGP/
> > Encryption tools. There are a couple available that are open source
> > and some that aren't. This option should provide protection in
> > transit. Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant- Hide quoted text -
> > - Show quoted text -
> Your responses have been a big help. Thanks for the advice!
You're welcome. Glad I could be of assistance. Let me know if I can be
of further assistance.
Regards,
Enrique Martinez
Sr. Software Consultant

RS inserts improper page breaks in report

Hi guys,
I try to find for an answer for this problem, but to no available, it drives
me crazy now.
I am getting a page break on each details row in a table. The table has 3
headers, one is a subreport, and a details row which contains a subreport;
there is no footers. The subreport in the details row contains another
subreport that has a table with 1 header and 1 details row, each has a
subreport. It's like so 3 levels deep.
My problem occurs in the first table, the subreport in the details line is
always generated on a new line. I check all the option with BreakPageAt End
and such, but everything is unchecked.
Any ideas.
Thanks!
RobertDo you have any grouping going on in the table? If so check the
grouping properties and see if you any of the 'page break' before or
after options set...
Cheers,
Ben|||There is the default group that is created but nothing is group on and both
'page break at start' and 'page break at bottom' are unchecked.
I don't know if it is relevant, but the page break only occurs when the
report is in 'print layout' mode.
Thanks!
Robert
sullins602 wrote:
>Do you have any grouping going on in the table? If so check the
>grouping properties and see if you any of the 'page break' before or
>after options set...
>Cheers,
>Ben|||Well, I did some more testing. By observation, it looks to me like RS
calculates all the rows in all my nested subreports, and if the number of
rows is bigger than the space left on the page, it assumes a break is needed.
Ouch.
Anybody else encoutered that?|||Yes we have this behaviour all the time and we raised a support incident with
Microsoft. They didn't want to know - as far as they are concerned it is
working as designed. They told us there is an implicit keeptogether on
anything within list but that using tables should be ok. Are you using lists
anywhere in your sub-reports?
"R Jakubowicz" wrote:
> Well, I did some more testing. By observation, it looks to me like RS
> calculates all the rows in all my nested subreports, and if the number of
> rows is bigger than the space left on the page, it assumes a break is needed.
>
> Ouch.
> Anybody else encoutered that?
>|||Hi Tom,
Yeah tell me about it.
Did you find a hack for it?
And no, i'm not using lists at all, I use tables though.
Tom wrote:
>Yes we have this behaviour all the time and we raised a support incident with
>Microsoft. They didn't want to know - as far as they are concerned it is
>working as designed. They told us there is an implicit keeptogether on
>anything within list but that using tables should be ok. Are you using lists
>anywhere in your sub-reports?
>> Well, I did some more testing. By observation, it looks to me like RS
>> calculates all the rows in all my nested subreports, and if the number of
>[quoted text clipped - 3 lines]
>> Anybody else encoutered that?
--
Message posted via http://www.sqlmonster.com