Automation Error when called from VB 6

Hi Friend,

I have an application in VB 6 with Crystal Reports 7. Once I deploy the application using Package & Deployment Wizard, I get the error 'Automation Error' when I call the report from VB. I have deployed the .rpt file and not the complied file. I get this error occationally and not always. I also use Selection Formula, and Replace Selection Formula, both in VB code and also in the Report. Other reports function normally but just this one report gives me problems.

Have you come across this problem or do you have any idea of solving this ?

Please let me know if you do.

Bye.You might be missing a required dll.|||omalley might be right...............but it can be about a thousand things in CR - the error traps are so generic...:-(

I've seen this type of error when referencing objects in VB that are nor correctly type, for example.
eg dim myObj as Object
dim myObj as CRAXDRT.Report (which is the correct way to expose a report object and its properties and avoid the iUnknown interface on the COM layer, as I recall.)

It can also occur when automation servers used by CR are not available for some reason. I use some of my own UFLs (user function libraries that I developed in VB), which end up being exposed as "Additional Functions" in the formula editor. Any dll's with prefix UFL MUST be in same location as crpeaut32.dll or they will operate unreliably, even though properly registered using regsvr32.

Check also that your installation doesn't have some distributables on a network drive.

Once you've done that, make sure that you have properly passed your login info to the report in your code, and that you have also passed it to any subreports. This is a trap that bites many CR users - your database security may require you to supply login info to each subreport. It will also vary from OS to OS - standard XP security is much fussier than ME, for example.

As you can isolate it to a particular report that fails, are you doing anything differently to other reports, ie passing a different type of parameter, or maybe a range of parameters instead of a single one, and so on? Or maybe a different user is experiencing the problem.

Failing that, check the event log on the PC and see what information it is returning regarding the automation failure, and post that here.

Dave|||Thank You, omalley and springsoft for your comments. The code I use is given below;

'*****

CR.ReportFileName = App.Path & "\RouteCard.Rpt"

CR.DiscardSavedData = True
CR.Reset
CR.DiscardSavedData = False
CR.WindowShowRefreshBtn = True
CR.WindowShowSearchBtn = True
CR.WindowShowPrintSetupBtn = True

If CmbWoNoFrom.ListCount = 0 Then
MsgBox "No Records", vbInformation
Exit Sub
End If
ab = False
st1 = "({TblSchedulinghdr.Cancelled} = 0 and {TblPartNoWorkOrderNo.Cancelled}=0) and {TblOrderAcceptanceDetail.Move}='MOVE' "



If Trim(CmbWoNoFrom) <> "" Then
st1 = st1 & " AND {TblSchedulinghdr.SequenceWONo} >= " & Val(CmbWoNoFrom)
End If
If Trim(CmbWoNoTo) <> "" Then
st1 = st1 & " and {TblSchedulinghdr.SequenceWONo} <= " & Val(CmbWoNoTo)
End If
If Trim(CmbFinancialYear) <> "" Then
st1 = st1 & " and {TblSchedulinghdr.FinancialYear} = '" & UCase(Trim(CmbFinancialYear)) & "'"

End If
CR.SelectionFormula = st1





CR.Action = 1

'****

I use a database on the network which connects through ODBC and there is no database passwords set. There are 6 sub reports on this report and only one user gets this error at times. This package is compiled on win 2000 and deployed on win98.

Please let me know if you have any clue.

Thanx.
Bye.|||John,
Only potential problem I can see here (and it may not actually be a problem because you have given us a code snippet, not the whole lot), is that you are using combo boxes, by the look of your variable naming notations (which bears some resemblance to Charles Simonyi's Hungarian C Notation, with an indicative type prefix on variable and object names).
If CmbWoNoFrom (for example) is actually a combo box, what are you doing to trap situations where user presses Print button without actually selecting an item from each combo?
Unless you have a default value already set, and it doesn't look like you have, as you are Val'ing the combo's selection, then a failure to select the value may cause the query to fail, because it is passing a value (probably -1) that the query can't handle.

Dave|||Thnak You springsoft for your observations.

I don't think an empty combo box would produce an error as the check for an empty trimmed combo is done before the expression is built. This particular machine had some virus problems and also has a keyboard device driver alert in device manager. Does this pose any potential problem, although I feel it should'nt.

Please let me know of your views.

Thanx.

Bye.

automating SSMS reports

Is there a way to automate some of the reports available in Sql Server Mgmt
Studio? I really like several of them, such as the Schema Changes History,
and think they would be helpful from a "compliance" perspective. So, I've
been exporting a few to PDF or Excel on a regular basis... so it's pretty
obvious that the next step would be to have a job that does automatically on
a scheduled basis (Daily, Weekly, whatever).
Any insight on if this doable w/out too many hoops?
-- Margo Noreen
Hello M,
You can download the reports here
http://blogs.msdn.com/sqlrem/archive/2006/08/30/SSMS_Reports_3.aspx
You will need to put them in RS and schedule them
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons

> Is there a way to automate some of the reports available in Sql Server
> Mgmt Studio? I really like several of them, such as the Schema
> Changes History, and think they would be helpful from a "compliance"
> perspective. So, I've been exporting a few to PDF or Excel on a
> regular basis... so it's pretty obvious that the next step would be to
> have a job that does automatically on a scheduled basis (Daily,
> Weekly, whatever).
> Any insight on if this doable w/out too many hoops?
>
|||So that assumes one has Reporting Services setup and configured... which we
do not.
No other way?
-- Margo Noreen
"Simon Sabin" wrote:
[vbcol=seagreen]
> Hello M,
> You can download the reports here
> http://blogs.msdn.com/sqlrem/archive/2006/08/30/SSMS_Reports_3.aspx
> You will need to put them in RS and schedule them
>
> Simon Sabin
> SQL Server MVP
> http://sqlblogcasts.com/blogs/simons
>
|||RS is needed if you want the same cool look you currently have in Management
Studio. If you're just after the data, you can pull the queries into a
sproc, tweak it to output to a persistent table and schedule a job to run it
at whatever frequency you need.
joe.
"M Noreen" <MNoreen@.discussions.microsoft.com> wrote in message
news:3D38CBF0-A6EC-435F-B1EC-309BAEF92BC5@.microsoft.com...[vbcol=seagreen]
> So that assumes one has Reporting Services setup and configured... which
> we
> do not.
> No other way?
> --
> -- Margo Noreen
>
> "Simon Sabin" wrote:
|||We have Reporting Services installed on some servers. Can we run these
reports against any other SQL Servers in our network.
thanks,
ktm
"Joe Yong" wrote:

> RS is needed if you want the same cool look you currently have in Management
> Studio. If you're just after the data, you can pull the queries into a
> sproc, tweak it to output to a persistent table and schedule a job to run it
> at whatever frequency you need.
>
> joe.
> "M Noreen" <MNoreen@.discussions.microsoft.com> wrote in message
> news:3D38CBF0-A6EC-435F-B1EC-309BAEF92BC5@.microsoft.com...
>
>
|||You can run these reports against any SQL Server 2005 instance.
Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/
"ktmd" <ktmd@.discussions.microsoft.com> wrote in message
news:3F316342-FAB9-4E5A-802A-320713FD9E39@.microsoft.com...[vbcol=seagreen]
> We have Reporting Services installed on some servers. Can we run these
> reports against any other SQL Servers in our network.
> thanks,
> ktm
> "Joe Yong" wrote:

Automating Reporting Services in my Windows App.

Is there a way of automating SQL Server Reporting Services reports in my win
app?
I want to be able to pick up events when the user right-clicks on the report
etc.
I really want to provide a context menu with options relevant to what
they've selected in the report.
As I understood it, the generated report is basically html and theres no
easy way of doing it...
I basically want the report to be more dynamic than just being generated and
then printed.
If not is in coming in a future version of SQL Server?Are you using the ReportViewer control?
http://gotreportviewer.com/
If on the server you may be able to add via .css?
http://weblogs.asp.net/jgalloway/archive/2006/09/01/SQL-Reporting-Services-_2D00_-CSS-fix-for-Firefox.aspx
Steve MunLeeuw
"James" <James@.discussions.microsoft.com> wrote in message
news:E1244EC6-5372-4AB2-8BC1-9D41827F2D8E@.microsoft.com...
> Is there a way of automating SQL Server Reporting Services reports in my
> win
> app?
> I want to be able to pick up events when the user right-clicks on the
> report
> etc.
> I really want to provide a context menu with options relevant to what
> they've selected in the report.
> As I understood it, the generated report is basically html and theres no
> easy way of doing it...
> I basically want the report to be more dynamic than just being generated
> and
> then printed.
> If not is in coming in a future version of SQL Server?|||yes, I'm currently looking into doing it via hyperlinks as in the following
article:
http://www.devx.com/dotnet/Article/30424/0/page/6
"Steve MunLeeuw" wrote:
> Are you using the ReportViewer control?
> http://gotreportviewer.com/
> If on the server you may be able to add via .css?
> http://weblogs.asp.net/jgalloway/archive/2006/09/01/SQL-Reporting-Services-_2D00_-CSS-fix-for-Firefox.aspx
> Steve MunLeeuw
> "James" <James@.discussions.microsoft.com> wrote in message
> news:E1244EC6-5372-4AB2-8BC1-9D41827F2D8E@.microsoft.com...
> > Is there a way of automating SQL Server Reporting Services reports in my
> > win
> > app?
> > I want to be able to pick up events when the user right-clicks on the
> > report
> > etc.
> > I really want to provide a context menu with options relevant to what
> > they've selected in the report.
> > As I understood it, the generated report is basically html and theres no
> > easy way of doing it...
> > I basically want the report to be more dynamic than just being generated
> > and
> > then printed.
> >
> > If not is in coming in a future version of SQL Server?
>
>sql

Automating record selection parameters

Hi,

I need some advise on how to automate record selection on a stored
proc. Here is my situation. I have a stored proc that I used on
Crystal reports with two parameters - Acctcode and Subacct. When a
user enters ' *' on these parameter, it means to report on all
accounts otherwise, report only on specific account.

Here is my select statement with line numbers:

Create proc rb_SubledgerRpt
@.Acctcode varchar(4), @.SubAcct varchar(3)

As

3 Select AcctCode, SubAcct
4 From GLDetails
5 Where SubAcct <> ' '
6 and AcctCode = @.Acctcode -- for specific acctcode
7 and SubAcct = @.SubAcct -- for specific subacct

8 Go

-- If a user wants to see all Acctcode, and all Subacct, how do I
disable lines 6 and 7?

Thank you in advance for your help.

EdgarHi Edgar,

How about:

Create proc rb_SubledgerRpt
@.Acctcode varchar(4), @.SubAcct varchar(3)
As
Select AcctCode, SubAcct
From GLDetails
Where SubAcct <> ' '
and ((@.AcctCode = '*' ) or (AcctCode = @.Acctcode))
and ((@.SubAcct = '*' ) or (SubAcct = @.SubAcct))

-Dick Christoph
"Edgar" <edgarjtan@.yahoo.com> wrote in message
news:1141058639.691125.36720@.v46g2000cwv.googlegro ups.com...
> Hi,
> I need some advise on how to automate record selection on a stored
> proc. Here is my situation. I have a stored proc that I used on
> Crystal reports with two parameters - Acctcode and Subacct. When a
> user enters ' *' on these parameter, it means to report on all
> accounts otherwise, report only on specific account.
> Here is my select statement with line numbers:
> Create proc rb_SubledgerRpt
> @.Acctcode varchar(4), @.SubAcct varchar(3)
> As
> 3 Select AcctCode, SubAcct
> 4 From GLDetails
> 5 Where SubAcct <> ' '
> 6 and AcctCode = @.Acctcode -- for specific acctcode
> 7 and SubAcct = @.SubAcct -- for specific subacct
> 8 Go
> -- If a user wants to see all Acctcode, and all Subacct, how do I
> disable lines 6 and 7?
> Thank you in advance for your help.
> Edgar|||One way would be this:

Declare @.sQry nvarchar(500)
Declare @.sWhere nvarchar(500)
Set @.sWhere = ' '
set @.AcctCode = 'ABC'
Set @.sQry =
'Select AcctCode, SubAcct ' +
'From GLDetails ' +
'Where SubAcct <> '' '''

If @.AcctCode <> '*'
Set @.sWhere = @.sWhere + 'and AcctCode = ''' + @.Acctcode + ''''

If @.SubAcct <> '*'
Set @.sWhere = @.sWhere + 'and SubAcct = ''' + @.SubAcct + ''''

Set @.sQry = @.sQry + @.sWhere
EXEC sp_executesql @.sQry|||Edgar (edgarjtan@.yahoo.com) writes:
> I need some advise on how to automate record selection on a stored
> proc. Here is my situation. I have a stored proc that I used on
> Crystal reports with two parameters - Acctcode and Subacct. When a
> user enters ' *' on these parameter, it means to report on all
> accounts otherwise, report only on specific account.
> Here is my select statement with line numbers:
> Create proc rb_SubledgerRpt
> @.Acctcode varchar(4), @.SubAcct varchar(3)
> As
> 3 Select AcctCode, SubAcct
> 4 From GLDetails
> 5 Where SubAcct <> ' '
> 6 and AcctCode = @.Acctcode -- for specific acctcode
> 7 and SubAcct = @.SubAcct -- for specific subacct
> 8 Go
> -- If a user wants to see all Acctcode, and all Subacct, how do I
> disable lines 6 and 7?

Dick and Jennifer suggested two methods. Dick's method is cleaner, but
Jennifer's solution can give better performance. If there are no
indexes on AcctCode or SubAcct (or the table is small), then there is
on performance issue. But if there are indexes, it is not likely that
Dick's solution will make use of them.

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

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||Hmmmm.

I guess I don't understand your comments Mr. Sommarskog. Dick's
solution to me is better. It is simpler, and doesn't use dynamic SQL.

Further, I've had the best success with GL's using a composite index on
Account+Subaccount.
If you don't know the account, you will end up doing a table scan
pretty much no matter what. If you know the account and the subaccount,
retrievals can be VERY fast.

Finally, because Dick's solution doesn't use dynamic SQL, the optimizer
can key in on the best way to do the search relatively easily.

I look forward to hearing why you don't think the optimizer would
indexes. They have in my experience.

Thank you,
Doug|||Doug (drmiller100@.hotmail.com) writes:
> I guess I don't understand your comments Mr. Sommarskog. Dick's
> solution to me is better. It is simpler, and doesn't use dynamic SQL.
> Further, I've had the best success with GL's using a composite index on
> Account+Subaccount.
> If you don't know the account, you will end up doing a table scan
> pretty much no matter what. If you know the account and the subaccount,
> retrievals can be VERY fast.

I will have admit that I did not consider the particular business problem,
but more considered the general case. Let's say that you have something
like:

SELECT ...
FROM tbl
WHERE (indexedcol1 = @.vall OR @.val1 = '*')
AND (indexedcol2 = @.val2 OR @.val2 = '*')
AND (nonindexedcol = @.val3 OR @.val3 = '*')

This will most certainly table scan, even if @.val1 has a distinct value and
@.val3 is '*', because when the optimizer builds the plan it has no
knowledge what value the parameter will have. It can sniff parameter
values, but it cannot build plans that produce wrong results. So it must
be a table scan. (The exception in SQL 2005 is when you add the query hint
OPTION (RECOMPILE).)

> Finally, because Dick's solution doesn't use dynamic SQL, the optimizer
> can key in on the best way to do the search relatively easily.

If you build a dynamic SQL string and include only the the search
parameters that were actually given, you will give the optimizer the
exact right amount of information to work with. If you only supply
@.val1, the optimizer will use that index (if it is selective enough).
If you only supply @.val2, it will use thar index, and if you supply
only @.val3, the query will table scan.

For a longer discsussion on the topic, see my article
http://www.sommarskog.se/dyn-search.html.

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

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||Hello,

Thanks for your comments.

An interesting subtlty is involved here. I wonder if the difference is
significant.
Dick's code had and ((@.AcctCode = '*' ) or (AcctCode = @.Acctcode))

your code had
(indexedcol1 = @.vall OR @.val1 = '*')

this sounds weird, but I can easily see where your code would require a
table scan, yet Dick's code could be done without one.
Does this make any sense to anyone else?
I don't know how to explain my logic.

Automating Creation of Reporting Services Reports (Excel format)

Hello,

Currently, I have to manully create RS 2005 reports which I export into an Excel later. Is there a way to create a SSIS package that could automate this somehow?

Thanks for sharing your thoughts and ideas!

donnie100 wrote:

Hello,

Currently, I have to manully create RS 2005 reports which I export into an Excel later. Is there a way to create a SSIS package that could automate this somehow?

Thanks for sharing your thoughts and ideas!

You mean you want to use SSIS to build the RDL? I'm not really sure why you would want to do this but heigh-ho.

Is there a .Net API for SSRS? if there is then you could call it from a SSIS script task.

-Jamie

Automatically Regenerate on Depending on parameter input

Hello,
Is there a way to get the reports to automatically regenerate when a user
changes a drop down or selects a radio button?
Thanks
DylanOn Feb 20, 11:45 am, Dylan <D...@.discussions.microsoft.com> wrote:
> Hello,
> Is there a way to get the reports to automatically regenerate when a user
> changes a drop down or selects a radio button?
> Thanks
> Dylan
As far as I know, there is not a way to do that; unless, you are
embedding the report in an application, whereas, you can call a
refresh of the report on a given event.
Regards,
Enrique Martinez
Sr. ASP.NET/SQL Server Developer|||By giving "default value" the report runs automatically (rather pretend to
run, infact it substitutes the values) Otherwise you have to click on view
report to see the report. other option is to write custom code..
Amarnath
"Dylan" wrote:
> Hello,
> Is there a way to get the reports to automatically regenerate when a user
> changes a drop down or selects a radio button?
> Thanks
> Dylansql

Automatically Preview reports

Hi all. Great Forum by the way

I have a question. I have some crystal reports that people open via a hyperlink on a web page. This brings up the crystal report but people have to then "refresh" or "run" the report themselves. They are then prompted for a "start" and "end" date for report.

Is it possible to have the report automically open prompting for the start and end dates? In other words open and run automically?

Regards

Johnu didn't mention what u r using to develop web pages.

If asp.net then use crystalreportviewer control it should automatically prompt for parameters.

Make sure u r not saving data with report.

I Hope this helps..

Automatically Generating PDFs With Reports Requiring Parameters

Hi,
I'm working on many reports that are generated using SQL Server
Reporting Services SP 1 from an ASP.NET 1.1 web application. One of the
things the users would like to do is have the report automatically
generate a PDF when they click on the View Report button after entering
the parameters for the report. Parameters could be a date, a city, a
state, etcetera. However, they would like to avoid having to choose the
format and click the Export link. Is there a way to manipulate the
functionality of the View Report button such that it does this
automatically? Thank you for any insights you can provide.
JabooHow are you accessing the reports?
1) Report Manager
2) URL parameters
3) Web Service
Kulgan.sql

Automatically Export reports in SQL Reporting services 2000

Is it possible to have a report automatically export the results to Excel, when the report is generated? ...rather than having to select the format and click Export? .Pl let me know-Thanks.

I found this article some days ago!

http://ryanfarley.com/blog/archive/2006/01/27/15689.aspx

sql

Automatically Export reports in SQL Reporting services 2000

Is it possible to have a report automatically export the results to Excel, when the report is generated? ...rather than having to select the format and click Export? .Pl let me know-Thanks.

I found this article some days ago!

http://ryanfarley.com/blog/archive/2006/01/27/15689.aspx

Automatic refresh

If there a way to have reports automatically refesh in in print preview mode - without hitting the refresh key or cmd5 key on the toolbar. CR VER 8.5 or 9.0Is there a way to automatically refresh a screen in the preview mode (without hitting cmd 5 or refresh key on the toolbar)

Automatic Printing of Reporting Services reports through subscriptions

To all the techies,

We are trying to schedule the report for automatic printing using subscriptions. Does any one have any idea of how to achieve this?

Any inputs appreciated.

AM

You can take a look at the custom extention sample for Reporting Service. This extention allows you to deliver your subscription to a network printer known by the reporting server.

The default location is: C:\Program Files\Microsoft SQL Server\90\Samples\Reporting Services\Extension Samples\PrinterDelivery Sample.

|||i have read the install sheet that goes with the sample. my question is how does one get it going?

Automatic Printing of Reporting Services reports through subscriptions

To all the techies,

We are trying to schedule the report for automatic printing using subscriptions. Does any one have any idea of how to achieve this?

Any inputs appreciated.

AM

You can take a look at the custom extention sample for Reporting Service. This extention allows you to deliver your subscription to a network printer known by the reporting server.

The default location is: C:\Program Files\Microsoft SQL Server\90\Samples\Reporting Services\Extension Samples\PrinterDelivery Sample.

|||i have read the install sheet that goes with the sample. my question is how does one get it going?

Automatic printing from ReportViewer control

Hi,
I've got a WinForm app written in .NET 2.0 (C#). We have a series of SQL
Reporting Services reports which are on a remote server - not RDLCs. I've
got a ReportViewer control on one of the forms, and am able to render the
reports in the ReportViewer just fine. However, I would like to be able to
print these reports, preferably without displaying any UI at all, through
this app. Does anybody have any suggestions? I realize that RDLCs would
work in this case, but that's not an option, unfortunately.
Thanks, JimOn Jan 4, 6:34 pm, "LiveCycle" <livecy...@.sandbox.etech.adobe.com>
wrote:
> Hi,
> I've got a WinForm app written in .NET 2.0 (C#). We have a series of SQL
> Reporting Services reports which are on a remote server - not RDLCs. I've
> got a ReportViewer control on one of the forms, and am able to render the
> reports in the ReportViewer just fine. However, I would like to be able to
> print these reports, preferably without displaying any UI at all, through
> this app. Does anybody have any suggestions? I realize that RDLCs would
> work in this case, but that's not an option, unfortunately.
> Thanks, Jim
This link should be helpful.
http://forums.asp.net/p/516455/533549.aspx
Regards,
Enrique Martinez
Sr. Software Consultant

Automated creation

Hello,
I was curious if, through code or some other process, if you can automate the creation of a report. I have reports I need generated after a DTS package imports data from the data dictionary. I want the reports in excel format. Is there an automated way of creating these reports? I'm sure there is, but I'm not that familiar with Reporting Services.

Hi bmains

Try using subscriptions with default permissions. You could then output the reports to a share or mail it to users.

,l0n3i200n

Automated client report rendering

My company would like to write an app that does on-demand rendering of
certain reports. Is there a .NET client report rendering library that
is not dependent on IIS (as the SOAP/URL apis are), nor WinForms (as
the ReportViewer is)?
Thanks,
EvaAfter some research I've found one third-party product called the RDL
Project that renders RDL into HTML, PDF, and some other formats. It's
found at http://www.fyiReporting.com. I played with it, and its version
1.0.1 can't yet parse a report that I built in VS2005, although I think
it could if I removed a few unsupported things from the report and if I
studied its code a bit more (documentation seems lacking).
Hope this post helps someone else, and of course if you know of any
other options please let me know!

Automate exporting reports to PDF

I have read these two sites:
http://blogs.msdn.com/bryanke/articles/71491.aspx
http://scruffylookingcatherder.com/archive/2007/12/07/printing-reporting-services-2005-reports.aspx
But I'm new to Reporting Services and these methods aren't well documented
(that I can find). I have a report that has four parameters -- the second
parameter is queried off the value of the first, and could potentially have
up to five unique values for each unique first value. I need to generate a
report for each unique device listed in the second parameter, spit it out to
PDF for us to review and email to the clients.
Is there a command that can be used to do this? Or do I need to do a SQL
query or two myself to pull those values, and using a foreach statement
generate a report for each?
Any suggestions would be fantastic.
--Nathan Loding
Systems Associate, Special Projects
WESCO NetI doubt that RS has the capabilities you're looking for as that kind of
round-tripping would be frought with really complicated issues (mainly
maintaining state management). I did a cursory look at the client proxy
objects and nothing lept out at me that seems like it'd do what you're
looking for. I can't claim this to be an authoritative answer, but
personally, I'm betting you'll have to redo the queries client-side if you're
going to mimic the Report Manager functionality.
Jacob
"Nathan Loding" wrote:
> I have read these two sites:
> http://blogs.msdn.com/bryanke/articles/71491.aspx
> http://scruffylookingcatherder.com/archive/2007/12/07/printing-reporting-services-2005-reports.aspx
> But I'm new to Reporting Services and these methods aren't well documented
> (that I can find). I have a report that has four parameters -- the second
> parameter is queried off the value of the first, and could potentially have
> up to five unique values for each unique first value. I need to generate a
> report for each unique device listed in the second parameter, spit it out to
> PDF for us to review and email to the clients.
> Is there a command that can be used to do this? Or do I need to do a SQL
> query or two myself to pull those values, and using a foreach statement
> generate a report for each?
> Any suggestions would be fantastic.
> --Nathan Loding
> Systems Associate, Special Projects
> WESCO Net

Automate deployment of reporting project

I have to deploy reports several times a day [to our teesting environment]
due to contstant changes by devlopers. Does anyone know of a way to automate
the deployment process? Even doing something with VBA will work. I don't
see any possible references listed in the VBA references section - would the
createobject method work? Has anyone does this? I would love to get this on
a schedule and off my plate.
Thanks in advance,
John Hennesey
p.s. Third party programs are an option too, if anyone knows of any.You should be able to do all you need with a bit of scripting and the rs
utility. The following link should give you an idea, based on the reporting
services sample reports:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSAMPLES/htm/rss_sampleapps_v1_1apd.asp
"JohnHennesey" wrote:
> I have to deploy reports several times a day [to our teesting environment]
> due to contstant changes by devlopers. Does anyone know of a way to automate
> the deployment process? Even doing something with VBA will work. I don't
> see any possible references listed in the VBA references section - would the
> createobject method work? Has anyone does this? I would love to get this on
> a schedule and off my plate.
> Thanks in advance,
> John Hennesey
> p.s. Third party programs are an option too, if anyone knows of any.|||Thank you for your response. This will do the trick, will take a bit of
massaging to get it to where I want it to be. Ideally if I could use the
Visual Sourcesafe object model to pull down the latest code, then use a .Net
object model to open the solution, change the deployment path then deploy it
would be ideal.
But, I can use command line script to pull down the latest code base from
SS, then iterate through the file list (.rdl's only) via the Scripting engine
and deploy from there.
Thanks for your help!
John
"David Jennaway" wrote:
> You should be able to do all you need with a bit of scripting and the rs
> utility. The following link should give you an idea, based on the reporting
> services sample reports:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSAMPLES/htm/rss_sampleapps_v1_1apd.asp
> "JohnHennesey" wrote:
> > I have to deploy reports several times a day [to our teesting environment]
> > due to contstant changes by devlopers. Does anyone know of a way to automate
> > the deployment process? Even doing something with VBA will work. I don't
> > see any possible references listed in the VBA references section - would the
> > createobject method work? Has anyone does this? I would love to get this on
> > a schedule and off my plate.
> >
> > Thanks in advance,
> > John Hennesey
> >
> > p.s. Third party programs are an option too, if anyone knows of any.

Auto UpLoad

Is there a way to automate the upload of reports (.PDF's).
My DD Subscription produces .PDF files of the reports , I would like to
upload them automatically so the user can see the files via Report Manager.
Has anyone had to do thi yet?
Many thanks in advance
PaulIf I understand you correctly, (and I'm assuming some things), you have a
report(s) that take some time to generate and you want to generate them in
the background but enable the users to see them through the web-page without
the latency?
If this is correct, set up the history so that it creates the report at a
regular interval, then when someone requests the report, it will pull it from
the history.
"PaulQld" wrote:
> Is there a way to automate the upload of reports (.PDF's).
> My DD Subscription produces .PDF files of the reports , I would like to
> upload them automatically so the user can see the files via Report Manager.
> Has anyone had to do thi yet?
> Many thanks in advance
> Paul

Auto update RDL file

Hi, Is there a way to automaticaly update my rdl file'
I have 12 reports to maintain and i modify theme often, is there a way that
when I put my new rdl file on the server, rs autoupdate file... because I
have to enter in the 12 report and click modify...update...browse...ok
FrancisYou'll need to publish them again, which can be scripted.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Francis" <francis.cote@.uqat.ca> wrote in message
news:uOHVzBuqEHA.1952@.TK2MSFTNGP12.phx.gbl...
> Hi, Is there a way to automaticaly update my rdl file'
> I have 12 reports to maintain and i modify theme often, is there a way
that
> when I put my new rdl file on the server, rs autoupdate file... because I
> have to enter in the 12 report and click modify...update...browse...ok
> Francis
>|||Hi Francis:
You could create an RSS script, which can execute with the RS.exe
utility. SSRS comes with a sample script you could copy and build on.
Look in <Reporting Services application path>\Samples\Scripts for
PublishSampleReports.rss. There is some documentation available here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsamples/htm/rss_sampleapps_v1_1apd.asp
--
Scott
http://www.OdeToCode.com/
On Tue, 5 Oct 2004 09:37:23 -0400, "Francis" <francis.cote@.uqat.ca>
wrote:
>Hi, Is there a way to automaticaly update my rdl file'
>I have 12 reports to maintain and i modify theme often, is there a way that
>when I put my new rdl file on the server, rs autoupdate file... because I
>have to enter in the 12 report and click modify...update...browse...ok
>Francis
>
--
Scott
http://www.OdeToCode.com/