OPENQUERY from ASP.NET Page Problem?

I'm performing a particular word Search in MS Word, Text, PDF docs and
displaying the results through Index Server linked to SQL Server when
it is matched. For which I'm using Openquery in the stored procedure
which works fine in Query Analyzer of the SQL Server but doesn't work (
shows none of the results) when i call it from the ASP.NET Page. I am
not able to figure out Where and What is the problem?
The Stored Proc which is i'm using is shown below
Any help will be greatly appreciated. Thanks for your time and help in
Advance
CREATE PROCEDURE SelectIndexServerCVpaths
(
@.searchstring varchar(100)
)
AS
SET @.searchstring = REPLACE( @.searchstring, '''', ''' )
IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE
TABLE_NAME = 'FileSearchResults')
DROP VIEW FileSearchResults
EXEC ('CREATE VIEW FileSearchResults AS SELECT * FROM
OPENQUERY(FileSystem,''SELECT Directory, FileName,
DocAuthor, Size, Create, Write, Path FROM
SCOPE('''' "c:\inetpub\wwwroot\sap-resources\Uploads" '''') WHERE
FREETEXT('' + @.searchstring + '')'')')
SELECT * FROM CVdetails C, FileSearchResults F WHERE C.CV_Path =
F.PATH AND C.DefaultID=1
GO
which works with followin stat in Query Analyzer
Exec SelectIndexServerCVpaths
@.searchstring = 'The Search text'
but doesn't work when i connect it to a Datagrid in my ASP.NET Page
objcmd = new SqlCommand("SelectIndexServerCVpaths", objConn);
objcmd.CommandType = CommandType.StoredProcedure;
objcmd.Parameters.Add("@.searchstring",strsearchstrings);
objConn.Open();
objRdr = objcmd.ExecuteReader();
dgcvs.DataSource=objRdr;
dgcvs.DataBind();
objRdr.Close();
objConn.Close();Did you try it with impersonation on?
http://support.microsoft.com/kb/323293/en-us
Also why don't you just query indexing services directly through ixsso, or
msidxs?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"savvy" <johngera@.gmail.com> wrote in message
news:1137934280.281102.175800@.o13g2000cwo.googlegroups.com...
> I'm performing a particular word Search in MS Word, Text, PDF docs and
> displaying the results through Index Server linked to SQL Server when
> it is matched. For which I'm using Openquery in the stored procedure
> which works fine in Query Analyzer of the SQL Server but doesn't work (
> shows none of the results) when i call it from the ASP.NET Page. I am
> not able to figure out Where and What is the problem?
> The Stored Proc which is i'm using is shown below
> Any help will be greatly appreciated. Thanks for your time and help in
> Advance
>
> CREATE PROCEDURE SelectIndexServerCVpaths
> (
> @.searchstring varchar(100)
> )
> AS
> SET @.searchstring = REPLACE( @.searchstring, '''', ''' )
> IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE
> TABLE_NAME = 'FileSearchResults')
> DROP VIEW FileSearchResults
> EXEC ('CREATE VIEW FileSearchResults AS SELECT * FROM
> OPENQUERY(FileSystem,''SELECT Directory, FileName,
> DocAuthor, Size, Create, Write, Path FROM
> SCOPE('''' "c:\inetpub\wwwroot\sap-resources\Uploads" '''') WHERE
> FREETEXT('' + @.searchstring + '')'')')
> SELECT * FROM CVdetails C, FileSearchResults F WHERE C.CV_Path =
> F.PATH AND C.DefaultID=1
> GO
> which works with followin stat in Query Analyzer
> Exec SelectIndexServerCVpaths
> @.searchstring = 'The Search text'
> but doesn't work when i connect it to a Datagrid in my ASP.NET Page
> objcmd = new SqlCommand("SelectIndexServerCVpaths", objConn);
> objcmd.CommandType = CommandType.StoredProcedure;
> objcmd.Parameters.Add("@.searchstring",strsearchstrings);
> objConn.Open();
> objRdr = objcmd.ExecuteReader();
> dgcvs.DataSource=objRdr;
> dgcvs.DataBind();
> objRdr.Close();
> objConn.Close();
>|||Thanks for your time and help
I'll try out the above|||Thanks for your time Hillary
I tried with impersonation with both true and false as well
it didn't make any difference
At present i'm getting some results which are static not changing with
the search word
I can't query just Indexing Services as you can see in my stored
procedure i'm linking my SQL Server Database table with the Index
Server Results
and displaying the results
Is there any problem in my Connection String which is shown below
SqlConnection objConn = new
SqlConnection(" Server=MISC\\MISC;Database=sapresources;
User
ID=sap;Password=sapres;");
that's it i'm not using any provider name, catalog name nothing of that
sort, Is that right ?sql

OPENQUERY from ASP.NET Page Problem?

I'm performing a particular word Search in MS Word, Text, PDF docs and displaying the results through Index Server linked to SQL Server when
it is matched. For which I'm using Openquery in the stored procedure
which works fine in Query Analyzer of the SQL Server but doesn't work ( displays none of the results) when i call it from the ASP.NET Page. I am
not able to figure out Where and What is the problem?
The Stored Proc which is i'm using is shown below
Any help will be greatly appreciated. Thanks for your time and help in
Advance

CREATE PROCEDURE SelectIndexServerCVpaths
(
@.searchstring varchar(100)
)
AS
SET @.searchstring = REPLACE( @.searchstring, '''', ''' )
IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE
TABLE_NAME = 'FileSearchResults')
DROP VIEW FileSearchResults
EXEC ('CREATE VIEW FileSearchResults AS SELECT * FROM
OPENQUERY(FileSystem,''SELECT Directory, FileName,
DocAuthor, Size, Create, Write, Path FROM
SCOPE('''' "c:\inetpub\wwwroot\sap-resources\Uploads" '''') WHERE
FREETEXT('' + @.searchstring + '')'')')
SELECT * FROM CVdetails C, FileSearchResults F WHERE C.CV_Path =
F.PATH AND C.DefaultID=1
GO

which works with followin stat in Query Analyzer
Exec SelectIndexServerCVpaths
@.searchstring = 'The Search text'

but doesn't work when i connect it to a Datagrid in my ASP.NET Page
objcmd = new SqlCommand("SelectIndexServerCVpaths", objConn);
objcmd.CommandType = CommandType.StoredProcedure;
objcmd.Parameters.Add("@.searchstring",strsearchstrings);
objConn.Open();
objRdr = objcmd.ExecuteReader();
dgcvs.DataSource=objRdr;
dgcvs.DataBind();
objRdr.Close();
objConn.Close();

Has No-one got any idea the above Question ? Is the above problem that complicated ?

|||

savvy wrote:

Has No-one got any idea the above Question ? Is the above problem that complicated ?

You question is not complicated but it is not valid implementation because SQL Server can perform what you want back in SQL Server 7.0 in 1999. Now if you can interested in valid solution post again and I can give you some links.

The reason Information Schema Views and Openquery are ANSI SQL for inter RDBMS( relational database management system) communication not for SQL Server and IIS index server. Hope this helps.

|||

Thanks for your help. So, Is my analogy wrong ? I have implemented this because i need to link SQL server and Index Server so that i can grab the data in the SQL Server and i had no idea of other ways of achieving this .

If you got any information to get around this problem that will be really great as I've been trying to solve this problem since a week.

Thanks in Advance

|||

Try these links the first deals with using both Image and text columns to get what you want and the second is SQL Server Full Text Blog, he was with the Microsoft SQL Server Full Text team. If you cannot find your solution in his blog he will answer your post at SQL Server Central forums. Hope this helps.

http://forums.asp.net/949146/ShowPost.aspx

http://spaces.msn.com/members/jtkane/?partqs=cat%3DSQL+Server+2000+Full-Text+Search&_c11_blogpart_blogpart=blogview&_c=blogpart

|||

Thanks for your help

Can you tel me is there any way to read the Word or PDF documents and store the text it in a database field (ntext) . Is this is possible?

Thanks in advance

|||

Savvy,

I think you have skipped design and is coding so you are complicating simple problems. The create table statement below comes from Microsoft new sample database AdventureWorks, you can store the files as Word or PDF on image columns but also use text to store the same files so you can use the Microsoft Full Text Index and do the key word search you want. What design do for you is look for alternative implementations which takes the complications out of the problem. Run a search for the AdventureWorks database on Microsoft site install it run tests and take the tables you need for your application. Hope this helps.

CREATE TABLE [ProductPhoto] (
[ProductPhotoID] [int] IDENTITY (1, 1) NOT NULL ,
[ThumbNailPhoto] [image] NULL ,
[ThumbnailPhotoFileName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[LargePhoto] [image] NULL ,
[LargePhotoFileName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ModifiedDate] [datetime] NOT NULL CONSTRAINT [DF_ProductPhoto_ModifiedDate] DEFAULT (getdate()),
CONSTRAINT [PK_ProductPhoto_ProductPhotoID] PRIMARY KEY CLUSTERED
(
[ProductPhotoID]
) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

|||

Thanks Caddre for your help. It was a really long journey after i got your reply, when i got shifted totally from linked servers to FULL TEXT INDEXING in MICROSOFT SEARCH SERVICE. I had many problems to solve such as my FULL TEXT INDEXING was grayed out so i need to install DEVELOPER Edition on my System coz my O/S is Win XP Prof. I read many of your Posts regarding this topic. I personally thank u alot for your help which u have rendered in this field.

Thank you very much

|||What error are you getting?|||

Savvy,

Thanks for the complement and I am glad I could help.

Opening Reports in continuation in pdf fomat

Hi
Just wanna know how to open two reports in continuation in pdf fomat
I am using Sql server 2000 Reporting Service . The scenario is that I have
two reportsA.rdl and B.rdl . The first report A.rdl is to opened in Acrobet
foramt with dyamic header/footer. Once the report is completely displayed
report B.rdl is to be displayed. with new page number starting from 1 (page
number).
One thing more first page , next page and last page all have different
formats
of header and footer.
Looking for solution..................
RohitHave you tried creating a third report which contains both of the other
reports?
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"Rohit J" wrote:
> Hi
> Just wanna know how to open two reports in continuation in pdf fomat
> I am using Sql server 2000 Reporting Service . The scenario is that I have
> two reportsA.rdl and B.rdl . The first report A.rdl is to opened in Acrobet
> foramt with dyamic header/footer. Once the report is completely displayed
> report B.rdl is to be displayed. with new page number starting from 1 (page
> number).
> One thing more first page , next page and last page all have different
> formats
> of header and footer.
> Looking for solution..................
> Rohit

Opening Multiple Reports In Adobe?

Does anyone know how to open two or more reports in adobe reader (pdf)? For
example, the user wants to print multiple reports in one whack, so I'd like
to be able to render several reports and ship them to adobe all at once. I
am using the render method of the web service to render reports along with
Response.OutputStream.Write to send the streaming content to the browser.
Any help or advice is greatly appreciated.
Thanks,
DBS5150Check
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=791554f6-b99b-425a-a23c-21eac16fa523&sloc=en-us.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"DBS5150" <DBS5150@.discussions.microsoft.com> wrote in message
news:FAADE7BE-16C3-45B6-8B1D-14919A5930E7@.microsoft.com...
> Does anyone know how to open two or more reports in adobe reader (pdf)?
For
> example, the user wants to print multiple reports in one whack, so I'd
like
> to be able to render several reports and ship them to adobe all at once.
I
> am using the render method of the web service to render reports along with
> Response.OutputStream.Write to send the streaming content to the browser.
> Any help or advice is greatly appreciated.
> Thanks,
> DBS5150

Opening a PDF report without the OPEN/Save Dialog

Is there a way to render the PDF report in the same broswer window you just called it from without the Open/Save dialog box coming up. The report is being call directly by URL parameters for PDF formatNo there is not. We set the Content-Type to attachment which causes IE to prompt for this.|||

This is quite easy with custom programming, I've made a new webapp and gave the aspnet-user full access to reporting services, maybe you could add a cutom file to the Reports-Webapp..

I've default.aspx:

<%@. Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>
<%
Dim pdfloader As New PDFLoader(Request, Response)
pdfloader.show()
%>

and default.aspx.vb:

Public Class PDFLoader

Private request As System.Web.HttpRequest
Private response As System.Web.HttpResponse

Public Sub New(ByVal request As System.Web.HttpRequest, ByVal response As System.Web.HttpResponse)
Me.request = request
Me.response = response
End Sub

Public Sub show()
Dim rsExec As New ReportExecutionService
rsExec.Credentials = System.Net.CredentialCache.DefaultCredentials

' Prepare Render arguments
Dim historyID As String = Nothing
Dim deviceInfo As String = Nothing
Dim format As String = "PDF"
Dim showHide As String = Nothing
Dim results() As [Byte]
Dim warnings As RepExServ.Warning() = Nothing
Dim streamIDs As String() = Nothing
Dim encoding As String = String.Empty
Dim mimeType As String = String.Empty
Dim reportName As String

Dim zaehl As Integer = -1
Dim names(), name, values(), value As String
Dim ParameterValues() As RepExServ.ParameterValue
ParameterValues = New RepExServ.ParameterValue(0) {}

names = request.QueryString.AllKeys
For Each name In names
values = request.QueryString.GetValues(name)
For Each value In values
If (name = "") Then
reportName = value
Else
zaehl = zaehl + 1
If zaehl >= ParameterValues.Length Then
ReDim Preserve ParameterValues(zaehl)
End If
Dim ParameterValue As RepExServ.ParameterValue = New RepExServ.ParameterValue
ParameterValue.Name = name
ParameterValue.Value = value
ParameterValue.Label = Nothing
ParameterValues(zaehl) = ParameterValue
End If

Next

Next

Dim ei As ExecutionInfo = rsExec.LoadReport(reportName, historyID)
If zaehl > -1 Then
rsExec.SetExecutionParameters(ParameterValues, "")
End If

'Exectute the report and send it to the Client
results = rsExec.Render(format, deviceInfo, "", encoding, mimeType, warnings, streamIDs)
response.ContentType = "application/pdf"
response.BinaryWrite(results)

End Sub
End Class

Partial Class _Default
Inherits System.Web.UI.Page

End Class

This works just similar to the usual URL-Access method, but you can't specify any "rs:" - Parameters.. sampe call:

http://yourserver/YourWebApp/default.aspx?/RepPath/Repname&Parameter1=something

okay, I forgot something: you have to add WebReferences to you webapp:
http://msdn2.microsoft.com/en-us/library/ms154699(SQL.90).aspx

|||Yes, you can always add your own web app to do this. I was stating that RS does not allow you to change this behavior using either URL access or Report Manager|||You can do this with the ReportViewer control, using the ExportContentDisposition property.|||

I also would like to open my report in PDF format without opening the Open/Save Dialog box.

I read that the ExportContentDisposition is indeed the property to use.

Is there a way to put this property in the URL when calling the report? Or do I have to use the ReportViewer Control? I am using SQL Server Reporting with ASP, not ASP.net

Thx

|||

You can always mimic the approach given above of hainvg a custom page that does the export, just recode it in ASP, rather than ASP.NET.

Hope that helps,

-Lukasz

|||

I have just tried creating the web app posted by BenniG and it works great on my computer but when I try from any of my co-workers computers i get a scripting error stating invalid character on line 2 character 1.

I know this is pretty vague but then again so is the error.

Any thoughts?

Opening a PDF report without the OPEN/Save Dialog

Is there a way to render the PDF report in the same broswer window you just called it from without the Open/Save dialog box coming up. The report is being call directly by URL parameters for PDF formatNo there is not. We set the Content-Type to attachment which causes IE to prompt for this.|||

This is quite easy with custom programming, I've made a new webapp and gave the aspnet-user full access to reporting services, maybe you could add a cutom file to the Reports-Webapp..

I've default.aspx:

<%@. Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>
<%
Dim pdfloader As New PDFLoader(Request, Response)
pdfloader.show()
%>

and default.aspx.vb:

Public Class PDFLoader

Private request As System.Web.HttpRequest
Private response As System.Web.HttpResponse

Public Sub New(ByVal request As System.Web.HttpRequest, ByVal response As System.Web.HttpResponse)
Me.request = request
Me.response = response
End Sub

Public Sub show()
Dim rsExec As New ReportExecutionService
rsExec.Credentials = System.Net.CredentialCache.DefaultCredentials

' Prepare Render arguments
Dim historyID As String = Nothing
Dim deviceInfo As String = Nothing
Dim format As String = "PDF"
Dim showHide As String = Nothing
Dim results() As [Byte]
Dim warnings As RepExServ.Warning() = Nothing
Dim streamIDs As String() = Nothing
Dim encoding As String = String.Empty
Dim mimeType As String = String.Empty
Dim reportName As String

Dim zaehl As Integer = -1
Dim names(), name, values(), value As String
Dim ParameterValues() As RepExServ.ParameterValue
ParameterValues = New RepExServ.ParameterValue(0) {}

names = request.QueryString.AllKeys
For Each name In names
values = request.QueryString.GetValues(name)
For Each value In values
If (name = "") Then
reportName = value
Else
zaehl = zaehl + 1
If zaehl >= ParameterValues.Length Then
ReDim Preserve ParameterValues(zaehl)
End If
Dim ParameterValue As RepExServ.ParameterValue = New RepExServ.ParameterValue
ParameterValue.Name = name
ParameterValue.Value = value
ParameterValue.Label = Nothing
ParameterValues(zaehl) = ParameterValue
End If

Next

Next

Dim ei As ExecutionInfo = rsExec.LoadReport(reportName, historyID)
If zaehl > -1 Then
rsExec.SetExecutionParameters(ParameterValues, "")
End If

'Exectute the report and send it to the Client
results = rsExec.Render(format, deviceInfo, "", encoding, mimeType, warnings, streamIDs)
response.ContentType = "application/pdf"
response.BinaryWrite(results)

End Sub
End Class

Partial Class _Default
Inherits System.Web.UI.Page

End Class

This works just similar to the usual URL-Access method, but you can't specify any "rs:" - Parameters.. sampe call:

http://yourserver/YourWebApp/default.aspx?/RepPath/Repname&Parameter1=something

okay, I forgot something: you have to add WebReferences to you webapp:
http://msdn2.microsoft.com/en-us/library/ms154699(SQL.90).aspx

|||Yes, you can always add your own web app to do this. I was stating that RS does not allow you to change this behavior using either URL access or Report Manager|||You can do this with the ReportViewer control, using the ExportContentDisposition property.|||

I also would like to open my report in PDF format without opening the Open/Save Dialog box.

I read that the ExportContentDisposition is indeed the property to use.

Is there a way to put this property in the URL when calling the report? Or do I have to use the ReportViewer Control? I am using SQL Server Reporting with ASP, not ASP.net

Thx

|||

You can always mimic the approach given above of hainvg a custom page that does the export, just recode it in ASP, rather than ASP.NET.

Hope that helps,

-Lukasz

|||

I have just tried creating the web app posted by BenniG and it works great on my computer but when I try from any of my co-workers computers i get a scripting error stating invalid character on line 2 character 1.

I know this is pretty vague but then again so is the error.

Any thoughts?

Opening a PDF report without the OPEN/Save Dialog

Is there a way to render the PDF report in the same broswer window you just called it from without the Open/Save dialog box coming up. The report is being call directly by URL parameters for PDF formatNo there is not. We set the Content-Type to attachment which causes IE to prompt for this.|||

This is quite easy with custom programming, I've made a new webapp and gave the aspnet-user full access to reporting services, maybe you could add a cutom file to the Reports-Webapp..

I've default.aspx:

<%@. Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>
<%
Dim pdfloader As New PDFLoader(Request, Response)
pdfloader.show()
%>

and default.aspx.vb:

Public Class PDFLoader

Private request As System.Web.HttpRequest
Private response As System.Web.HttpResponse

Public Sub New(ByVal request As System.Web.HttpRequest, ByVal response As System.Web.HttpResponse)
Me.request = request
Me.response = response
End Sub

Public Sub show()
Dim rsExec As New ReportExecutionService
rsExec.Credentials = System.Net.CredentialCache.DefaultCredentials

' Prepare Render arguments
Dim historyID As String = Nothing
Dim deviceInfo As String = Nothing
Dim format As String = "PDF"
Dim showHide As String = Nothing
Dim results() As [Byte]
Dim warnings As RepExServ.Warning() = Nothing
Dim streamIDs As String() = Nothing
Dim encoding As String = String.Empty
Dim mimeType As String = String.Empty
Dim reportName As String

Dim zaehl As Integer = -1
Dim names(), name, values(), value As String
Dim ParameterValues() As RepExServ.ParameterValue
ParameterValues = New RepExServ.ParameterValue(0) {}

names = request.QueryString.AllKeys
For Each name In names
values = request.QueryString.GetValues(name)
For Each value In values
If (name = "") Then
reportName = value
Else
zaehl = zaehl + 1
If zaehl >= ParameterValues.Length Then
ReDim Preserve ParameterValues(zaehl)
End If
Dim ParameterValue As RepExServ.ParameterValue = New RepExServ.ParameterValue
ParameterValue.Name = name
ParameterValue.Value = value
ParameterValue.Label = Nothing
ParameterValues(zaehl) = ParameterValue
End If

Next

Next

Dim ei As ExecutionInfo = rsExec.LoadReport(reportName, historyID)
If zaehl > -1 Then
rsExec.SetExecutionParameters(ParameterValues, "")
End If

'Exectute the report and send it to the Client
results = rsExec.Render(format, deviceInfo, "", encoding, mimeType, warnings, streamIDs)
response.ContentType = "application/pdf"
response.BinaryWrite(results)

End Sub
End Class

Partial Class _Default
Inherits System.Web.UI.Page

End Class

This works just similar to the usual URL-Access method, but you can't specify any "rs:" - Parameters.. sampe call:

http://yourserver/YourWebApp/default.aspx?/RepPath/Repname&Parameter1=something

okay, I forgot something: you have to add WebReferences to you webapp:
http://msdn2.microsoft.com/en-us/library/ms154699(SQL.90).aspx

|||Yes, you can always add your own web app to do this. I was stating that RS does not allow you to change this behavior using either URL access or Report Manager|||You can do this with the ReportViewer control, using the ExportContentDisposition property.|||

I also would like to open my report in PDF format without opening the Open/Save Dialog box.

I read that the ExportContentDisposition is indeed the property to use.

Is there a way to put this property in the URL when calling the report? Or do I have to use the ReportViewer Control? I am using SQL Server Reporting with ASP, not ASP.net

Thx

|||

You can always mimic the approach given above of hainvg a custom page that does the export, just recode it in ASP, rather than ASP.NET.

Hope that helps,

-Lukasz

|||

I have just tried creating the web app posted by BenniG and it works great on my computer but when I try from any of my co-workers computers i get a scripting error stating invalid character on line 2 character 1.

I know this is pretty vague but then again so is the error.

Any thoughts?

Opening a new window on clicking a hyperlink

Hi,

We are opening a Crystal Enterprise report in a browser. The report is opened in a .pdf format. We need to make some texts/images appear as hyperlinks. We did so by formatting the concerned objects in the Crystal Reports Designer and specifying the website address. But on clicking the text/image, the website is being opened in the same window. What can we do so that the website gets opened in a new window? Please Help!
We are using Crystal Reports 10.

Thanks,
ManishHi,

Let me rephrase the problem again after some observations.
We have found out that the hyperlink in thus generated pdf file is indeed opening in a new window. But when this pdf file is displayed inside a frame, clicking on the hyperlink is opening in the same window/frame. Please Help.

Regards,
Manishsql

Open Report in PDF

How can I force ReportViewer to open a report as a PDF automatically? Using
the Format=PDF in the properties menu generates a PDF report, but it opens
in Acrobat causing an extra step for the user. In Crystal Reports there is
an ExportType function that allows the Viewer to open a PDF directly. Does
SRS offer a similar function?
ThanksWhat do you mean by "extra step"?|||Instead of asking me if I want to Open or Save the PDF file, I want it to
open directly in the Report Viewer.
"Sorcerdon" <sorcerdon@.gmail.com> wrote in message
news:1140011264.479730.172910@.g47g2000cwa.googlegroups.com...
> What do you mean by "extra step"?
>

Open PDF in Web Browser

Hi,
I've got a report that I invoke from within Javascript using a direct
URL hit to the report. When the report generates it asks to either
"Open" or "Save" the PDF file. When I click on Open it opens Acrobat
Reader to view the file.
I need the report to open within the same browser as the javascript
that kicked it off without any prompts.
Is this possible in Reporting Services?
Regards,
Graham Richter.Hi
Are you wanting it still to be pdf and just open with the plugin? Or
otherwise render it as html.