Bill -

When they create their sp's they just need to write

CREATE PROCEDURE [dbo].[NameOfProcedure]

Two things to check -

1. If the graphics are linked, make sure you deployed the graphics files to the reportserver.

2. Tools ~ Internet Options in IE, make sure that you've...

This was covered before...

There is a recent book, purchased but haven't read yet. Chapter 11 describes how to modify Report Manager. Here is a link with some more info.

http://www.sqlreportingservices.net/

1. You have a statement that returns either True or False.

2. You have a IIf() expression for optional filter criteria.

3. If the statement (#1) is True, apply the filter criteria.

4....

One trick to getting PDF's looking good on paper is that you need to visit the Acrobat page setup dialogs:

Page scaling: fit to paper

Auto-rotate and center = checked

Choose paper source by...

I tried many sets of bits before I found one that worked. I am using URL access to render the report to a file as a PDF and then launching...

It might add some value, but not as much as a Microsoft certification. Sounds like you know your stuff, so that should not be too difficult to achieve. To-date I...

Yes there is. Go into the SQL view of your pass-through, click View ~ Properties and observe the "ODBC Connect Str" property. Click the builder (three dots) at the right,...

Martha

All you need to use is

=Fields!completedDate.Value

and then set the Format property of that cell to

d

which corresponds to Short date. For more info, search Reporting Services BOL for "Formatting Text".

You could also turn flash "off" with a freeware utility from

http://www.nirsoft.net/utils/tflash2.html

Curtis

There are several versions of Reporting Services - Standard, Enterprise, Developer - you need to install the version that matches your version of SQL Server. If you're running XP then you need...

Your code should actually read like this (2nd argument names the driver to be used):

DBEngine.RegisterDatabase "ApplicationName", "SQL Server", True, "Database=PT;id=PT_RO;pwd=livingstone5"

To test this out, switch to the VBA side (Alt-F11) and...

Continuing my idea, you would run something like this when the Access reporting mdb opens:

DBEngine.RegisterDatabase "ApplicationName", "SQL Server", True, "Database=MySQLDatabase;id=MyReadOnlyLogin;pwd=MyPassword"

...which creates a DSN named "ApplicationName" pointing at the SQL database...

Is there a reason you don't want to create a SQL login and use that just for the reporting mdb? I'm guessing that you're using ODBC to link Access to...

Paul

You could create a new login that has only SELECT permissions, on only the tables they need for reporting, and use that login to connect to SQL Server from your...