Hello everybody,
I am looking for some help. If guys have encountered anything similar like this pls let me know. I am very new to BIRT though I have Actuate reports experience so I can at least guess what I need to expect from Actuate BIRT.
Problem A:
Problem A.1:
I need to create a stored procedure data set. I have created a Data Source. while creating stored procedure data set I go these steps:
New Data Set -->
Enter Data Set Name -->
Enter Data Source -->
Data Set Type: SQL Stored Procedure Query --> Next
Next in Query window I can see stored procedure (Available Items):
ActivitySummary;1
RETURN_VALUE(int, Return Value)
@ACTIVITYID(char, Input)
@ACCOUNTNO(char, Input)
@REGION(char, Input)
@BUSINESSDATE(datetime, Input)
@INTERNATIONAL(char, Input)
That means my database connection is good I can confirm that.
Then I entered stored procedure query. I tried following sets but NOT able to see Output Columns or Preview Results or Parameters. Hence I am not able to create any data set.
{call ActivitySummary(?, ?, ?, ?, ?)}
{call ActivitySummary(
@ACTIVITYID = ?, ACCOUNTNO = ?,
@REGION = ?,
@BUSINESSDATE = ?,
@INTERNATIONAL = ?)}
{call ActivitySummary(
@ACTIVITYID = 'WEB',
@ACCOUNTNO = 'NANO',
@REGION = 'US',
@BUSINESSDATE = '2/26/2008',
@INTERNATIONAL = 'Y')}
On the parameter tab I created data set parameters and binding data set parameters correctly with the Report parameters.
Any idea?
Problem A.2
Now I have tried using SQL Select Query for stored procedure. Instead of Data Set Type: SQL Stored Procedure Query I entered SQL Select Query.
On Query window I am able to see stored proc. I put following query there.
execute ActivitySummary
@ACTIVITYID = ?,
@ACCOUNTNO = ?,
@REGION = ?,
@BUSINESSDATE = ?,
@INTERNATIONAL = ?
Still I am not able to see any Output Columns. On parameter tab I created data set parameters and bind them with report parameters.
Next I click on Preview Results...there I am able to see the result sets. Now problem with this approach is that I have no Output Columns to put in to report.
If I create computed columns manually, I am able to reference them with stored proc columns some how but when I create rptdesign and try to see "preview" or try to run rptdesign it doesn't show me any data if I change report parameters. It shows me data only for default report parameters.
Anyone has any idea what is going wrong?
Problem B:
I need to call 3 different stored procedure at runtime based on 'INTERNATIONAL' value. Let us say, there are 4 stored procedures.
Stored ProcA
Stored ProcB
Stored Proc1
Stored Proc2
I need to call:
If 'INTERNATIONAL = Y' then Stored ProcA, Stored ProcB, Stored Proc1
ELSE 'INTERNATIONAL = N' then Stored ProcA, Stored ProcB, Stored Proc2
Any idea how do I achieve this? Is this possible in BIRT?
Thank you very much for looking at my issues. Any inputs/tips/ideas will be very much helpful.
