PDF Bookmarks

When I export a report to PDF format, the bookmarks pane is closed, and
needs to be pressed in order for the bookmarks to open.
Is it possible that Upon opening the PDF, the bookmark pane will be
visible ?Alon (alongivaty@.hotmail.com) writes:
> When I export a report to PDF format, the bookmarks pane is closed, and
> needs to be pressed in order for the bookmarks to open.
> Is it possible that Upon opening the PDF, the bookmark pane will be
> visible ?

Somehow, I get a feeling that you should try a different newsgroup. I
don't see where SQL Server comes in.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

pb Order by

Under ASP, I have this statement which works:
strSQL="select * from " & Table_Name
objRS.open strSQL, objConn

But when I want to sort according to my column 'Position' (which is of number type under Access 2000) It no longer works. Any Idea?:
strSQL="select * from " & Table_Name & " Order by Position"
objRS.open strSQL, objConn

I have this error:
error '80004005'
Unspecified error

I'm connected this way:
StrConnect = "Provider=Microsoft.Jet.OLEDB.4.0;"&_
"Data Source=o:\teams\pursuit\db\productdb.mdb;" &_
"Persist Security Info=False"
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.ConnectionString = StrConnect
objConn.Open
Set objRS = Server.CreateObject("ADODB.Recordset")
objRS.activeconnection = objConn

Help:confused:Don't search, the name'position' for my field was a key word

Password: case sensitive

I installed SQL 2000 with default sort order. I though the password for SQL
logins is case-sensitive but it is not. Is that correct?
Thanks.Yes ...the passwords are not case sensitive... because of the collation
level . I beleive you might be able to change the collation for the password
column in sysxlogins table. Not tried it out but might be interesting if it
can be done
<Flicker> wrote in message news:OGqSaLqkDHA.708@.TK2MSFTNGP10.phx.gbl...
> I installed SQL 2000 with default sort order. I though the password for
SQL
> logins is case-sensitive but it is not. Is that correct?
> Thanks.
>

passing table name and order by parameter to stored procedure

can i pass the name of the table and the "order by" column name to stored procedure?

i tried the simple way

(@.tablename varchar and then "select * from @.tablename)

but i get error massesges. the same for order by...

what is the right syntex for this task?

You have to use dynamic SQL for this task, unfortunately. You have to create a character string in your sproc that puts together the SQL statement and then you have to call exec(@.sql) on it.

Example:

@.sql = 'SELECT * FROM ' + @.tableName

exec(@.sql)

|||

well, i just started to use stored procedure, i think that i will leave dynamic sql to later on...

Passing row data!

Hi Team,

I am trying to build a report which compose of EmployeeName and his order assigned. First of all, I created a dataset which include all of the employee name, then I created another dataset which return all the count of the order by passing the employeeName as parameter. My question is how to pass the employee name which are generated from the first dataset and then pass to the second dataset?

Any help I will greatly appreciate.

You can refer to the value of the first parameter in the query parameter value expression of the second dataset. For example, =Parameters!<param1>.Value.