How do I execute a Report from a C#.net Application

Hey guys....

I am new to Actuate ... !

All I want to do is to Execute a Report that is published in the Server, from a client terminal using a C#.net application

I am going through the APIs ... but haven't managed to figure out how!!

Any help will be appreciated...!!

Find more posts tagged with

Comments

mwilliams

Hi Abzz, 
 
If you're wanting to call reports from an application, you should be able to do so using the deployed viewer on tomcat or iServer Express and use URL's to call the reports. What kind of Server are the reports "published" to? 
 
As far as using the APIs, the following post in the devShare shows how to call reports with those. 
 
<a class='bbc_url' href='http://www.birt-exchange.com/devshare/deploying-birt-reports/568-execute-birt-reports-from-java-class/'>Execute BIRT Reports from Java class - Designs & Code - BIRT Exchange</a> 
 
Hope this helps.

Abzz

Hey Michale,

I was actually looking for Calling reports from API.
I ve just taken a look at the code .java files, and seems this is what I want to do from a c# windows based application.

Actually, we have designed and published a set of custom reports on out Windows 2003 Server (PDC). We have a windows based application that all employee use internally. We want to enhance the application so that it generates the required reports for the user.

I 'll go through the links you have forwarded, and will revert back in case I m in trouble again.

Thank you very much,

With Regards,
Abraham

Abzz

<pre class='_prettyXprint _lang-auto _linenums:0'>

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using VIEWEROCXLib;

namespace RepAPI
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}

private void Form1_Load(object sender, EventArgs e)
{
String HostName = "tltMelody", UserName = "Administrator", PassWord = "";

String ROI = "";

VIEWEROCXLib.ViewerOCXClass avcObj = new VIEWEROCXLib.ViewerOCXClass();

avcObj.ConnectToServer(HostName, UserName, PassWord);

}
}
}

</pre>
 
 
I am getting the following error on hitting the last line {ie avcObj.ConnectToServer} 
 
Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED)) 
 
 
 
Well ... Here's what I have done so far. 
 
1. Added COM reference to "axview.dll" to a new C# windows application. {I have already registered the dll. 
2. Wrote the above code, where in I am just trying to Connect to the Reporting Server which has an Actuate 10 installation 
 
 
 
Additional notes 
The server is version 10 where as my pc has an older version (Ver 7) .... 
The COM dll I am using is of Version 7. 
Can this be a problem????!! 
 
 
 
Regards, 
Abraham

Abzz

Well .... 
 
I found some examples in [InstallFolder]ServerIntTechWeb Services ... and was able to figure out the way to connect to the iServer. 
 
Thanks for all the Help, Michale

mwilliams

Abraham,

No problem. Glad you found a solution!

anjana83

hi

Am new to this Actuate BIRT.
i went thru' ur Issue in connecting BIRT with C#.net.

can u pls tell me steps how to connect this with C#.Net
i saw that u add som DLL file
"Added COM reference to "axview.dll" to a new C# windows application. {I have already registered the dll."

can u pls tell me from where u get this "axview.dll".from where v ve to get this.

pls help me

Thanking You
Anjana

Abzz

Please furnish more details. 
Actuate version, Programming platform etc 
 
 
<blockquote class='ipsBlockquote' data-author="anjana83">hi 
 
Am new to this Actuate BIRT. 
i went thru' ur Issue in connecting BIRT with C#.net. 
 
can u pls tell me steps how to connect this with C#.Net 
i saw that u add som DLL file 
"Added COM reference to "axview.dll" to a new C# windows application. {I have already registered the dll." 
 
can u pls tell me from where u get this "axview.dll".from where v ve to get this. 
 
 
pls help me 
 
Thanking You 
Anjana</blockquote>

anjana83

hi,
we are using Actuate 10 Version and we are trying to call the reports which published in Actuate 10 from a C# .NET application.

Thanks,
Anjana.

Abzz

<a class='bbc_url' href='http://www.birt-exchange.com/forum/deploying-integrating-birt-report-engine-applications/12684-birt-dotnet.html'>http://www.birt-exchange.com/forum/deploying-integrating-birt-report-engine-applications/12684-birt-dotnet.html</a> 
 
 
Just try to follow the example. 
 
PDF : "programming-iserver-apps" is a good read and discusses the API in detail

anjana83

hi,
i ve a doubt,
In ur Code :-"using VIEWEROCXLib;"
i searched all files in Add refereance i dnt c that.
actually wat is that?

can u tell me from wer v 'll get this?

Thanking you
Anjana

Abzz

That was a mistake on my part. Ignore that code 
I had added reference to Actuate 7 dlls. It wont work that way in Actuate 10.

anjana83

Hi,
i went thru the Example and document,bt it contains 10 project.i cant understand that code.
can u pls explain me the step u done to integrate BIRT with C#.net
pls help me

Thanking You
Anjana

Abzz

If you have gone through the document, then you should have no trouble.. IMHO !

Here are few tips.

1. Go through Chapter 1 and Chapter 7 of the PDF. They are absolutely necessary.

2. The Server_Proxy is a useful project in the example. As far as my understanding goes... it generates a DLL that exposes the Actuate API for the Application. So first Build it and copy the Server_Proxy.DLL into a known folder like "C:GlobalObject"

3. Pick up a simple example from the Source .... my suggestion is "GetFolderList" . Refer the Chapter 1 API list and understand it. Open the example and make necessary changes. {like the path you supply must exist on your report server}

4. Expand the "References" in solution explorer. Remove reference to server proxy if it exists. Add reference to the DLL you copied into "C:GlobalObjects" ....

5. Compile and run. I m sure u'll see the light!

Wish you luck!

anjana83

Thanks for your reply
i 'll try it n let u knw....

Anjana

anjana83

hi
i followed the steps u said and changed the url path in Getfolderitem
and the tried to run the program
bt its showing error
am attaching the error window with this pls
go thru that n hepl me

thanking you
anjana