Looking under Locks/Object I noticed the following items:
master.dbo.spt_values
tempdb.dbo.##lockinfo75
The lock mode is X (Exclusive Insert/delete or update)
Process details show 'sa' as the user
The Databases are all working okay (with 80+ users)
Is there any way of checking what this is (presumably a temp table was created as part of the process) ?
Also what is spt_values used for ?
thanks
Gerry
This is a temp table used by one of the stored procedures EM calls when you
look up information such as locks. It's nothing to worry about.
Andrew J. Kelly
SQL Server MVP
"Gerry" <anonymous@.discussions.microsoft.com> wrote in message
news:6F9059D0-29EF-4B05-B8FF-92388071AC37@.microsoft.com...
> Looking under Locks/Object I noticed the following items:
> master.dbo.spt_values
> tempdb.dbo.##lockinfo75
> The lock mode is X (Exclusive Insert/delete or update)
> Process details show 'sa' as the user
> The Databases are all working okay (with 80+ users)
> Is there any way of checking what this is (presumably a temp table was
created as part of the process) ?
> Also what is spt_values used for ?
> thanks
> Gerry
Showing posts with label mode. Show all posts
Showing posts with label mode. Show all posts
Friday, March 23, 2012
Lock Information
Looking under Locks/Object I noticed the following items:
master.dbo.spt_values
tempdb.dbo.##lockinfo75
The lock mode is X (Exclusive Insert/delete or update)
Process details show 'sa' as the user
The Databases are all working okay (with 80+ users)
Is there any way of checking what this is (presumably a temp table was creat
ed as part of the process) ?
Also what is spt_values used for ?
thanks
GerryThis is a temp table used by one of the stored procedures EM calls when you
look up information such as locks. It's nothing to worry about.
Andrew J. Kelly
SQL Server MVP
"Gerry" <anonymous@.discussions.microsoft.com> wrote in message
news:6F9059D0-29EF-4B05-B8FF-92388071AC37@.microsoft.com...
> Looking under Locks/Object I noticed the following items:
> master.dbo.spt_values
> tempdb.dbo.##lockinfo75
> The lock mode is X (Exclusive Insert/delete or update)
> Process details show 'sa' as the user
> The Databases are all working okay (with 80+ users)
> Is there any way of checking what this is (presumably a temp table was
created as part of the process) ?
> Also what is spt_values used for ?
> thanks
> Gerry
master.dbo.spt_values
tempdb.dbo.##lockinfo75
The lock mode is X (Exclusive Insert/delete or update)
Process details show 'sa' as the user
The Databases are all working okay (with 80+ users)
Is there any way of checking what this is (presumably a temp table was creat
ed as part of the process) ?
Also what is spt_values used for ?
thanks
GerryThis is a temp table used by one of the stored procedures EM calls when you
look up information such as locks. It's nothing to worry about.
Andrew J. Kelly
SQL Server MVP
"Gerry" <anonymous@.discussions.microsoft.com> wrote in message
news:6F9059D0-29EF-4B05-B8FF-92388071AC37@.microsoft.com...
> Looking under Locks/Object I noticed the following items:
> master.dbo.spt_values
> tempdb.dbo.##lockinfo75
> The lock mode is X (Exclusive Insert/delete or update)
> Process details show 'sa' as the user
> The Databases are all working okay (with 80+ users)
> Is there any way of checking what this is (presumably a temp table was
created as part of the process) ?
> Also what is spt_values used for ?
> thanks
> Gerry
Wednesday, March 7, 2012
Local Report Processing mode
Hi,
We have a scenario where we want to test the <a href> url generated
by parsing the <Hyperlink> element present in the rdl file
This check needs to be done without deploying the rdl file on the
report server. So we are planning to use Local processing mode of the
report view control.
I wanted to ask on whether there are any differences between the
conversion of <Hyperlink> element to <a href> when checked in local
processing mode and when checked in remote processing mode (i.e when
the conversion is done by report server by using reporting server web
services).
Thanks in advancewhat do you mean by "test the <a href>?
do you want to validate that the URL works fine before deploying the report?
the local processing mode of the report viewer can't use an RDL file. you
have to convert it to RDLC. but you also have to execute the query in your
code.
the report viewer just render the report and can't execute the query
statements.
but...
you can validate the hyperlink objects in the RDL file
directly, if the hyperlink is hardcoded. (you can simply use the XML
Document object model to do this)
another option is to publish the report in report server, then execute the
report by code and retrieve the URLS generated in the HTML content to
validate them.
hope this will help you.
"Amit" <amits.84@.gmail.com> wrote in message
news:1182624675.249537.176170@.x35g2000prf.googlegroups.com...
> Hi,
> We have a scenario where we want to test the <a href> url generated
> by parsing the <Hyperlink> element present in the rdl file
> This check needs to be done without deploying the rdl file on the
> report server. So we are planning to use Local processing mode of the
> report view control.
> I wanted to ask on whether there are any differences between the
> conversion of <Hyperlink> element to <a href> when checked in local
> processing mode and when checked in remote processing mode (i.e when
> the conversion is done by report server by using reporting server web
> services).
> Thanks in advance
>|||Thanks for the reply.
I want to validate 2 things with the Hyperlink element which would
contain complex expressions and calls to custom assemblies.
1. Whether the rdl file deploys correctly
2. Whether the url generated is right
This needs to be done without any interaction with the report server.
Hence we wanted to try out local report processing mode. Can you
please guide whether I will be able to validate the above mentioned
scenarios using local processing mode ?
For validating the second scenario I would need to generate an event
of clicking the hyperlink. Is that possible in local report processing
mode ?
I will convert the rdl file to rdlc file. As only <Hyperlink>
scenarios needs to be test I would create a rdl file which contains
only <Hyperlink> element. Renaming this rdl file to rdlc would work as
the schema for both are same. right ?
On Jun 24, 2:33 am, "Jeje" <willg...@.hotmail.com> wrote:
> what do you mean by "test the <a href>?
> do you want to validate that the URL works fine before deploying thereport?
> thelocalprocessingmodeof thereportviewer can't use an RDL file. you
> have to convert it to RDLC. but you also have to execute the query in your
> code.
> thereportviewer just render thereportand can't execute the query
> statements.
> but...
> you can validate the hyperlink objects in the RDL file
> directly, if the hyperlink is hardcoded. (you can simply use the XML
> Document object model to do this)
> another option is to publish thereportinreportserver, then execute thereportby code and retrieve the URLS generated in the HTML content to
> validate them.
> hope this will help you.
> "Amit" <amits...@.gmail.com> wrote in message
> news:1182624675.249537.176170@.x35g2000prf.googlegroups.com...
> > Hi,
> > We have a scenario where we want to test the <a href> url generated
> > by parsing the <Hyperlink> element present in the rdl file
> > This check needs to be done without deploying the rdl file on the
> >reportserver. So we are planning to useLocalprocessingmodeof the
> >reportview control.
> > I wanted to ask on whether there are any differences between the
> > conversion of <Hyperlink> element to <a href> when checked inlocal
> >processingmodeand when checked in remoteprocessingmode(i.e when
> > the conversion is done byreportserver by using reporting server web
> > services).
> > Thanks in advance|||All the above testing scenarios should be done programmatically.
On Jun 24, 6:47 pm, Amit <amits...@.gmail.com> wrote:
> Thanks for the reply.
> I want to validate 2 things with the Hyperlink element which would
> contain complex expressions and calls to custom assemblies.
> 1. Whether the rdl file deploys correctly
> 2. Whether the url generated is right
> This needs to be done without any interaction with thereportserver.
> Hence we wanted to try outlocalreportprocessingmode. Can you
> please guide whether I will be able to validate the above mentioned
> scenarios usinglocalprocessingmode?
> For validating the second scenario I would need to generate an event
> of clicking the hyperlink. Is that possible inlocalreportprocessingmode?
> I will convert the rdl file to rdlc file. As only <Hyperlink>
> scenarios needs to be test I would create a rdl file which contains
> only <Hyperlink> element. Renaming this rdl file to rdlc would work as
> the schema for both are same. right ?
> On Jun 24, 2:33 am, "Jeje" <willg...@.hotmail.com> wrote:
> > what do you mean by "test the <a href>?
> > do you want to validate that the URL works fine before deploying thereport?
> > thelocalprocessingmodeof thereportviewer can't use an RDL file. you
> > have to convert it to RDLC. but you also have to execute the query in your
> > code.
> > thereportviewer just render thereportand can't execute the query
> > statements.
> > but...
> > you can validate the hyperlink objects in the RDL file
> > directly, if the hyperlink is hardcoded. (you can simply use the XML
> > Document object model to do this)
> > another option is to publish thereportinreportserver, then execute thereportby code and retrieve the URLS generated in the HTML content to
> > validate them.
> > hope this will help you.
> > "Amit" <amits...@.gmail.com> wrote in message
> >news:1182624675.249537.176170@.x35g2000prf.googlegroups.com...
> > > Hi,
> > > We have a scenario where we want to test the <a href> url generated
> > > by parsing the <Hyperlink> element present in the rdl file
> > > This check needs to be done without deploying the rdl file on the
> > >reportserver. So we are planning to useLocalprocessingmodeof the
> > >reportview control.
> > > I wanted to ask on whether there are any differences between the
> > > conversion of <Hyperlink> element to <a href> when checked inlocal
> > >processingmodeand when checked in remoteprocessingmode(i.e when
> > > the conversion is done byreportserver by using reporting server web
> > > services).
> > > Thanks in advance|||converting an RDL file to RDLC + code based dataset execution could be
possible, but complicated regarding your development constraints.
also, testing a report should be done 1 time only, after this you can't test
all the cases (I mean you can't test all the possible resultsets coming from
the database)
So, I recommend to spread your code in 2:
1. predeploy testing
2. deploy
the step 1 can be done by deploying the report in a test report server or an
hidden folder in RS. when you publish a report the publish process returns
the warnings and other errors found in the report. (so you can stop the
process here if there is warning, and if there is errors the report is not
deployed)
When this step pass the deployment, you can now execute the report a first
time and scan the resulting HTML content by code.
so you can retrieve all the <a href statements and verify by code if these
links works fine (using the webrequest object in .NET)
and finally, remove the tested report from report server.
now the report is approved for deployment and can be added in your
deployment process.
converting an RDL report to RDLC can be complex because you have to extract
the SQL queries and connections from the report, create and populate a
dataset on the fly and execute the report on the fly. what's appends if
there is parameters?
you can't simulate a direct "click" event on an hyperlink in any scenario.
you can just extract and test the generated HTML content.
but can you explain who creates the reports and how?
because Visual Studio can validate the deployment himself and can "compile"
the report to identify warnings and errors.
also, can you explain how the hyperlinks are created in the reports?
does it's hardcoded (fixed) links? or does the links come from a database?
or does the links is a formula result? (a concatenation of something like:
"http://myserver/myfolder/mypage.aspx?id=" & Datasetfield.Value)
Jerome.
"Amit" <amits.84@.gmail.com> wrote in message
news:1182692843.900480.295280@.e16g2000pri.googlegroups.com...
> Thanks for the reply.
> I want to validate 2 things with the Hyperlink element which would
> contain complex expressions and calls to custom assemblies.
> 1. Whether the rdl file deploys correctly
> 2. Whether the url generated is right
> This needs to be done without any interaction with the report server.
> Hence we wanted to try out local report processing mode. Can you
> please guide whether I will be able to validate the above mentioned
> scenarios using local processing mode ?
> For validating the second scenario I would need to generate an event
> of clicking the hyperlink. Is that possible in local report processing
> mode ?
> I will convert the rdl file to rdlc file. As only <Hyperlink>
> scenarios needs to be test I would create a rdl file which contains
> only <Hyperlink> element. Renaming this rdl file to rdlc would work as
> the schema for both are same. right ?
> On Jun 24, 2:33 am, "Jeje" <willg...@.hotmail.com> wrote:
>> what do you mean by "test the <a href>?
>> do you want to validate that the URL works fine before deploying
>> thereport?
>> thelocalprocessingmodeof thereportviewer can't use an RDL file. you
>> have to convert it to RDLC. but you also have to execute the query in
>> your
>> code.
>> thereportviewer just render thereportand can't execute the query
>> statements.
>> but...
>> you can validate the hyperlink objects in the RDL file
>> directly, if the hyperlink is hardcoded. (you can simply use the XML
>> Document object model to do this)
>> another option is to publish thereportinreportserver, then execute
>> thereportby code and retrieve the URLS generated in the HTML content to
>> validate them.
>> hope this will help you.
>> "Amit" <amits...@.gmail.com> wrote in message
>> news:1182624675.249537.176170@.x35g2000prf.googlegroups.com...
>> > Hi,
>> > We have a scenario where we want to test the <a href> url generated
>> > by parsing the <Hyperlink> element present in the rdl file
>> > This check needs to be done without deploying the rdl file on the
>> >reportserver. So we are planning to useLocalprocessingmodeof the
>> >reportview control.
>> > I wanted to ask on whether there are any differences between the
>> > conversion of <Hyperlink> element to <a href> when checked inlocal
>> >processingmodeand when checked in remoteprocessingmode(i.e when
>> > the conversion is done byreportserver by using reporting server web
>> > services).
>> > Thanks in advance
>
We have a scenario where we want to test the <a href> url generated
by parsing the <Hyperlink> element present in the rdl file
This check needs to be done without deploying the rdl file on the
report server. So we are planning to use Local processing mode of the
report view control.
I wanted to ask on whether there are any differences between the
conversion of <Hyperlink> element to <a href> when checked in local
processing mode and when checked in remote processing mode (i.e when
the conversion is done by report server by using reporting server web
services).
Thanks in advancewhat do you mean by "test the <a href>?
do you want to validate that the URL works fine before deploying the report?
the local processing mode of the report viewer can't use an RDL file. you
have to convert it to RDLC. but you also have to execute the query in your
code.
the report viewer just render the report and can't execute the query
statements.
but...
you can validate the hyperlink objects in the RDL file
directly, if the hyperlink is hardcoded. (you can simply use the XML
Document object model to do this)
another option is to publish the report in report server, then execute the
report by code and retrieve the URLS generated in the HTML content to
validate them.
hope this will help you.
"Amit" <amits.84@.gmail.com> wrote in message
news:1182624675.249537.176170@.x35g2000prf.googlegroups.com...
> Hi,
> We have a scenario where we want to test the <a href> url generated
> by parsing the <Hyperlink> element present in the rdl file
> This check needs to be done without deploying the rdl file on the
> report server. So we are planning to use Local processing mode of the
> report view control.
> I wanted to ask on whether there are any differences between the
> conversion of <Hyperlink> element to <a href> when checked in local
> processing mode and when checked in remote processing mode (i.e when
> the conversion is done by report server by using reporting server web
> services).
> Thanks in advance
>|||Thanks for the reply.
I want to validate 2 things with the Hyperlink element which would
contain complex expressions and calls to custom assemblies.
1. Whether the rdl file deploys correctly
2. Whether the url generated is right
This needs to be done without any interaction with the report server.
Hence we wanted to try out local report processing mode. Can you
please guide whether I will be able to validate the above mentioned
scenarios using local processing mode ?
For validating the second scenario I would need to generate an event
of clicking the hyperlink. Is that possible in local report processing
mode ?
I will convert the rdl file to rdlc file. As only <Hyperlink>
scenarios needs to be test I would create a rdl file which contains
only <Hyperlink> element. Renaming this rdl file to rdlc would work as
the schema for both are same. right ?
On Jun 24, 2:33 am, "Jeje" <willg...@.hotmail.com> wrote:
> what do you mean by "test the <a href>?
> do you want to validate that the URL works fine before deploying thereport?
> thelocalprocessingmodeof thereportviewer can't use an RDL file. you
> have to convert it to RDLC. but you also have to execute the query in your
> code.
> thereportviewer just render thereportand can't execute the query
> statements.
> but...
> you can validate the hyperlink objects in the RDL file
> directly, if the hyperlink is hardcoded. (you can simply use the XML
> Document object model to do this)
> another option is to publish thereportinreportserver, then execute thereportby code and retrieve the URLS generated in the HTML content to
> validate them.
> hope this will help you.
> "Amit" <amits...@.gmail.com> wrote in message
> news:1182624675.249537.176170@.x35g2000prf.googlegroups.com...
> > Hi,
> > We have a scenario where we want to test the <a href> url generated
> > by parsing the <Hyperlink> element present in the rdl file
> > This check needs to be done without deploying the rdl file on the
> >reportserver. So we are planning to useLocalprocessingmodeof the
> >reportview control.
> > I wanted to ask on whether there are any differences between the
> > conversion of <Hyperlink> element to <a href> when checked inlocal
> >processingmodeand when checked in remoteprocessingmode(i.e when
> > the conversion is done byreportserver by using reporting server web
> > services).
> > Thanks in advance|||All the above testing scenarios should be done programmatically.
On Jun 24, 6:47 pm, Amit <amits...@.gmail.com> wrote:
> Thanks for the reply.
> I want to validate 2 things with the Hyperlink element which would
> contain complex expressions and calls to custom assemblies.
> 1. Whether the rdl file deploys correctly
> 2. Whether the url generated is right
> This needs to be done without any interaction with thereportserver.
> Hence we wanted to try outlocalreportprocessingmode. Can you
> please guide whether I will be able to validate the above mentioned
> scenarios usinglocalprocessingmode?
> For validating the second scenario I would need to generate an event
> of clicking the hyperlink. Is that possible inlocalreportprocessingmode?
> I will convert the rdl file to rdlc file. As only <Hyperlink>
> scenarios needs to be test I would create a rdl file which contains
> only <Hyperlink> element. Renaming this rdl file to rdlc would work as
> the schema for both are same. right ?
> On Jun 24, 2:33 am, "Jeje" <willg...@.hotmail.com> wrote:
> > what do you mean by "test the <a href>?
> > do you want to validate that the URL works fine before deploying thereport?
> > thelocalprocessingmodeof thereportviewer can't use an RDL file. you
> > have to convert it to RDLC. but you also have to execute the query in your
> > code.
> > thereportviewer just render thereportand can't execute the query
> > statements.
> > but...
> > you can validate the hyperlink objects in the RDL file
> > directly, if the hyperlink is hardcoded. (you can simply use the XML
> > Document object model to do this)
> > another option is to publish thereportinreportserver, then execute thereportby code and retrieve the URLS generated in the HTML content to
> > validate them.
> > hope this will help you.
> > "Amit" <amits...@.gmail.com> wrote in message
> >news:1182624675.249537.176170@.x35g2000prf.googlegroups.com...
> > > Hi,
> > > We have a scenario where we want to test the <a href> url generated
> > > by parsing the <Hyperlink> element present in the rdl file
> > > This check needs to be done without deploying the rdl file on the
> > >reportserver. So we are planning to useLocalprocessingmodeof the
> > >reportview control.
> > > I wanted to ask on whether there are any differences between the
> > > conversion of <Hyperlink> element to <a href> when checked inlocal
> > >processingmodeand when checked in remoteprocessingmode(i.e when
> > > the conversion is done byreportserver by using reporting server web
> > > services).
> > > Thanks in advance|||converting an RDL file to RDLC + code based dataset execution could be
possible, but complicated regarding your development constraints.
also, testing a report should be done 1 time only, after this you can't test
all the cases (I mean you can't test all the possible resultsets coming from
the database)
So, I recommend to spread your code in 2:
1. predeploy testing
2. deploy
the step 1 can be done by deploying the report in a test report server or an
hidden folder in RS. when you publish a report the publish process returns
the warnings and other errors found in the report. (so you can stop the
process here if there is warning, and if there is errors the report is not
deployed)
When this step pass the deployment, you can now execute the report a first
time and scan the resulting HTML content by code.
so you can retrieve all the <a href statements and verify by code if these
links works fine (using the webrequest object in .NET)
and finally, remove the tested report from report server.
now the report is approved for deployment and can be added in your
deployment process.
converting an RDL report to RDLC can be complex because you have to extract
the SQL queries and connections from the report, create and populate a
dataset on the fly and execute the report on the fly. what's appends if
there is parameters?
you can't simulate a direct "click" event on an hyperlink in any scenario.
you can just extract and test the generated HTML content.
but can you explain who creates the reports and how?
because Visual Studio can validate the deployment himself and can "compile"
the report to identify warnings and errors.
also, can you explain how the hyperlinks are created in the reports?
does it's hardcoded (fixed) links? or does the links come from a database?
or does the links is a formula result? (a concatenation of something like:
"http://myserver/myfolder/mypage.aspx?id=" & Datasetfield.Value)
Jerome.
"Amit" <amits.84@.gmail.com> wrote in message
news:1182692843.900480.295280@.e16g2000pri.googlegroups.com...
> Thanks for the reply.
> I want to validate 2 things with the Hyperlink element which would
> contain complex expressions and calls to custom assemblies.
> 1. Whether the rdl file deploys correctly
> 2. Whether the url generated is right
> This needs to be done without any interaction with the report server.
> Hence we wanted to try out local report processing mode. Can you
> please guide whether I will be able to validate the above mentioned
> scenarios using local processing mode ?
> For validating the second scenario I would need to generate an event
> of clicking the hyperlink. Is that possible in local report processing
> mode ?
> I will convert the rdl file to rdlc file. As only <Hyperlink>
> scenarios needs to be test I would create a rdl file which contains
> only <Hyperlink> element. Renaming this rdl file to rdlc would work as
> the schema for both are same. right ?
> On Jun 24, 2:33 am, "Jeje" <willg...@.hotmail.com> wrote:
>> what do you mean by "test the <a href>?
>> do you want to validate that the URL works fine before deploying
>> thereport?
>> thelocalprocessingmodeof thereportviewer can't use an RDL file. you
>> have to convert it to RDLC. but you also have to execute the query in
>> your
>> code.
>> thereportviewer just render thereportand can't execute the query
>> statements.
>> but...
>> you can validate the hyperlink objects in the RDL file
>> directly, if the hyperlink is hardcoded. (you can simply use the XML
>> Document object model to do this)
>> another option is to publish thereportinreportserver, then execute
>> thereportby code and retrieve the URLS generated in the HTML content to
>> validate them.
>> hope this will help you.
>> "Amit" <amits...@.gmail.com> wrote in message
>> news:1182624675.249537.176170@.x35g2000prf.googlegroups.com...
>> > Hi,
>> > We have a scenario where we want to test the <a href> url generated
>> > by parsing the <Hyperlink> element present in the rdl file
>> > This check needs to be done without deploying the rdl file on the
>> >reportserver. So we are planning to useLocalprocessingmodeof the
>> >reportview control.
>> > I wanted to ask on whether there are any differences between the
>> > conversion of <Hyperlink> element to <a href> when checked inlocal
>> >processingmodeand when checked in remoteprocessingmode(i.e when
>> > the conversion is done byreportserver by using reporting server web
>> > services).
>> > Thanks in advance
>
Local report pdf export
I have found several questions and remarks about the pdf export in local mode. The big problem is that the export to pdf option in local mode is useless when compression is not supported.
My questions:
1.) When (VS 2005? date?) will pdf compression in local mode be supported?
2.) Is it possible to compress the result of the LocalReport.Render method with custom code?
3.) It seems like a small adjustment to use the server mode compression code also in local mode. Is it part of a MS strategy to force the use of server mode?
Thanx,
Arjan
I don't know of any plans to support PDF compression in local mode.
It is always possible to post-process the result of an export however you want, including compression.
|||Do you know of any .net components that can compress a PDF document?|||I know of no .NET compression libraries off the top of my head that can compress the PDF and maintain the correct page stream. However, you can shell out to a command-line tool to do the recompress:
http://www.pdftk.com
Just be aware that this software is GPL-based so check with your legal department before incorporating binaries or source into any solution.
Thanks, Donovan
|||I acutally came across pdftk, and it does do the job.
However, it has no hooks into it, so to get it to work as a component would take a lot of work on our part.
But I can't find anything that does the trick, so I guess I might end up shelling out to pdftk and just hoping it works. But of course that is not ideal.
Local report pdf export
I have found several questions and remarks about the pdf export in local mode. The big problem is that the export to pdf option in local mode is useless when compression is not supported.
My questions:
1.) When (VS 2005? date?) will pdf compression in local mode be supported?
2.) Is it possible to compress the result of the LocalReport.Render method with custom code?
3.) It seems like a small adjustment to use the server mode compression code also in local mode. Is it part of a MS strategy to force the use of server mode?
Thanx,
Arjan
I don't know of any plans to support PDF compression in local mode.
It is always possible to post-process the result of an export however you want, including compression.
|||Do you know of any .net components that can compress a PDF document?|||
I know of no .NET compression libraries off the top of my head that can compress the PDF and maintain the correct page stream. However, you can shell out to a command-line tool to do the recompress:
http://www.pdftk.com
Just be aware that this software is GPL-based so check with your legal department before incorporating binaries or source into any solution.
Thanks, Donovan
|||I acutally came across pdftk, and it does do the job.
However, it has no hooks into it, so to get it to work as a component would take a lot of work on our part.
But I can't find anything that does the trick, so I guess I might end up shelling out to pdftk and just hoping it works. But of course that is not ideal.
Local report pdf export
I have found several questions and remarks about the pdf export in local mode. The big problem is that the export to pdf option in local mode is useless when compression is not supported.
My questions:
1.) When (VS 2005? date?) will pdf compression in local mode be supported?
2.) Is it possible to compress the result of the LocalReport.Render method with custom code?
3.) It seems like a small adjustment to use the server mode compression code also in local mode. Is it part of a MS strategy to force the use of server mode?
Thanx,
Arjan
I don't know of any plans to support PDF compression in local mode.
It is always possible to post-process the result of an export however you want, including compression.
|||Do you know of any .net components that can compress a PDF document?|||I know of no .NET compression libraries off the top of my head that can compress the PDF and maintain the correct page stream. However, you can shell out to a command-line tool to do the recompress:
http://www.pdftk.com
Just be aware that this software is GPL-based so check with your legal department before incorporating binaries or source into any solution.
Thanks, Donovan
|||I acutally came across pdftk, and it does do the job.
However, it has no hooks into it, so to get it to work as a component would take a lot of work on our part.
But I can't find anything that does the trick, so I guess I might end up shelling out to pdftk and just hoping it works. But of course that is not ideal.
Local Report not changing back to original report
Hi
I have an aspx page which contains the report viewer control. I am using
this control in local processing mode.
Everything is working correctly except the following case
If I view a report (Report1) and then click on a hyperlink which drills down
to another report (Report2), the new report loads corectly and the
parameters are passed.
However, If I then select my generate report button on the form, it seems to
create the correct datasource and pass the right parameters, but instead of
displaying Report1 again, Report2 is still displayed and the data in the
report is incorrect.
I have dubugged the code and it all seems correct to me.When the generate
report button is clicked, the report path for Report1 is set, the new
collection of report parameters are created (which are correct) and the
datasources are setup.
The only thing that is not changing correctly is the report being rendered.
Here is some of my code
'btnGenerateReport_Click Method
rptReportViewer.LocalReport.ReportPath = MapPath("../Reports/" &
objReport.URL & ".rdlc")
rptReportViewer.LocalReport.DisplayName = objReport.Name
rptReportViewer.LocalReport.DataSources.Clear()
rptReportViewer.LocalReport.DataSources.Add(New
Microsoft.Reporting.WebForms.ReportDataSource("myDataset",
dsData.Tables(0)))
rptReportViewer.LocalReport.SetParameters(objReportParameters)
rptReportViewer.LocalReport.Refresh()
rptReportViewer.Visible = True
Is there anything else I need to do to refresh the report?
Any help would reeally be appreciated as I cannot find any help or examples
on how to do this.
Thanks
Lewis HolmesHi Lewis,
Thank you for your post.
This behavior is by design for the WebForm.ReportViewer control.
It is possible to change the DataSource of the localreport
It is not possible to change the report definition in the WebForms control
in LocalReport mode after it has been set once.
To work around the design limitation of the WebForms ReportViewer control,
you can remove the existing instance and create a new one which uses the
new report definition.
Here is a sample:
//Get the new report definition
StreamReader tr = new StreamReader( < your rdlc file path>);
string sDef = tr.ReadToEnd();
tr.Close();
//Create the new viewer and remove the old one
ControlCollection col = ReportViewer1.Parent.Controls;
int index = col.IndexOf(ReportViewer1);
ReportViewer newReportView = new ReportViewer();
col.AddAt(index, newReportView);
col.Remove(ReportViewer1);
newReportView.Visible = false;
newReportView.ProcessingMode = ProcessingMode.Local;
StringReader sr = new StringReader(sDef);
newReportView.LocalReport.LoadReportDefinition(sr);
newReportView.LocalReport.DataSources.Clear();
newReportView.LocalReport.DataSources.Add(new
Microsoft.Reporting.WebForms.ReportDataSource("DataSet1_DataTable1",
ObjectDataSource1));
newReportView.LocalReport.Refresh();
newReportView.Visible = true;
Hope this will be helpful!
Thank you!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.
I have an aspx page which contains the report viewer control. I am using
this control in local processing mode.
Everything is working correctly except the following case
If I view a report (Report1) and then click on a hyperlink which drills down
to another report (Report2), the new report loads corectly and the
parameters are passed.
However, If I then select my generate report button on the form, it seems to
create the correct datasource and pass the right parameters, but instead of
displaying Report1 again, Report2 is still displayed and the data in the
report is incorrect.
I have dubugged the code and it all seems correct to me.When the generate
report button is clicked, the report path for Report1 is set, the new
collection of report parameters are created (which are correct) and the
datasources are setup.
The only thing that is not changing correctly is the report being rendered.
Here is some of my code
'btnGenerateReport_Click Method
rptReportViewer.LocalReport.ReportPath = MapPath("../Reports/" &
objReport.URL & ".rdlc")
rptReportViewer.LocalReport.DisplayName = objReport.Name
rptReportViewer.LocalReport.DataSources.Clear()
rptReportViewer.LocalReport.DataSources.Add(New
Microsoft.Reporting.WebForms.ReportDataSource("myDataset",
dsData.Tables(0)))
rptReportViewer.LocalReport.SetParameters(objReportParameters)
rptReportViewer.LocalReport.Refresh()
rptReportViewer.Visible = True
Is there anything else I need to do to refresh the report?
Any help would reeally be appreciated as I cannot find any help or examples
on how to do this.
Thanks
Lewis HolmesHi Lewis,
Thank you for your post.
This behavior is by design for the WebForm.ReportViewer control.
It is possible to change the DataSource of the localreport
It is not possible to change the report definition in the WebForms control
in LocalReport mode after it has been set once.
To work around the design limitation of the WebForms ReportViewer control,
you can remove the existing instance and create a new one which uses the
new report definition.
Here is a sample:
//Get the new report definition
StreamReader tr = new StreamReader( < your rdlc file path>);
string sDef = tr.ReadToEnd();
tr.Close();
//Create the new viewer and remove the old one
ControlCollection col = ReportViewer1.Parent.Controls;
int index = col.IndexOf(ReportViewer1);
ReportViewer newReportView = new ReportViewer();
col.AddAt(index, newReportView);
col.Remove(ReportViewer1);
newReportView.Visible = false;
newReportView.ProcessingMode = ProcessingMode.Local;
StringReader sr = new StringReader(sDef);
newReportView.LocalReport.LoadReportDefinition(sr);
newReportView.LocalReport.DataSources.Clear();
newReportView.LocalReport.DataSources.Add(new
Microsoft.Reporting.WebForms.ReportDataSource("DataSet1_DataTable1",
ObjectDataSource1));
newReportView.LocalReport.Refresh();
newReportView.Visible = true;
Hope this will be helpful!
Thank you!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.
Local mode in asp.net web app
Dear all,
Can i use local mode of reporting service in asp.net web application?yes, if you use VS2005 you can create and use RDLC reports based on your own
datasets.
no server required.
abd there is a webcontrol in the toolbox to render the report
"Joe" <Joe@.discussions.microsoft.com> wrote in message
news:2EBBBA15-EC80-417E-9755-071685810970@.microsoft.com...
> Dear all,
> Can i use local mode of reporting service in asp.net web application?
Can i use local mode of reporting service in asp.net web application?yes, if you use VS2005 you can create and use RDLC reports based on your own
datasets.
no server required.
abd there is a webcontrol in the toolbox to render the report
"Joe" <Joe@.discussions.microsoft.com> wrote in message
news:2EBBBA15-EC80-417E-9755-071685810970@.microsoft.com...
> Dear all,
> Can i use local mode of reporting service in asp.net web application?
Friday, February 24, 2012
Local Intranet mode versus Internet mode.
Hi,
Currently, our Report Builder is running on Local Intranet mode. I'm investigating what the security implications are in changing it to Internet mode. However, I've not been able to find any documentation on this.
Does anyone know of any documentation that addresses this issue or have experience that they can share with changing Report Builder security zone from Intranet mode to Internet mode?
Thanks very much.
Invest in firewalls/routers... both for your users and server at work.
Subscribe to:
Posts (Atom)