ORACLE GRAPHICS. - Reports

HOW TO PASS PARAMETERS TO GRAPHIC BUILDER AT RUNTIME ?
GRAPHICS 3.0.3.12.0
PLEASE REPLY. 

send me your email address. I ll send you an example. Then you
will have a clear idea.
Thanks
Feroz

Related

Report as a mail attachment??

Hi,
I want to send a report as an attachment with my sheduled mail. Please tell me how i can send a report page as an attashment as well as chart reports.
Thanks in advance.
Usman Rana 
Hi Usman,
Please let me know if you were able to get this, as even I have a similar requirement.
Thanks in advance,
Haritha

Matrix Report

Hi All,
As i'm new to develop Matrix Report,if any one is having the pdf document can u plss forward to my mail id or give me the URL.
g_siva4u#yahoo.co.in
Plsss it is urget
Regards
Siva. 
Here is the link:
http://download-uk.oracle.com/docs/cd/B14099_17/bi.1012/b13895/orbr_visidx.htm#sthref2020 
..Or here
http://www.oracle.com/webapps/online-help/reports/10.1.2/state/content/navId.3/navSetId._/vtTopicFile.htmlhelp_rwbuild_hs%7Crwwhthow%7Cwhatare%7Creports%7Ca_nested_matrix_reports~htm/

XML Publisher report errors out when RDF report has no data

Hi everyone,
I created a template and attached it to an RDF. When i run the oracle report with the attached template, if the report has 'not data exists' the report is erroring out. is it the normal functionality of XML publiher??. Because i remember at my earlier client i have run some reports for which if 'no data exists' still the program would complete normal but the output would be blank.
The xml output is creating the tags for the elements.
any help appeciated.
Thanks
sam 
Hi Sam,
Yes this will happen depending on what the template is repeating on etc. You can handle this quite easily using sub-templates.
Firstly create your normal template as a sub-template (so surrounded by the <?template:TEMPLATE_NAME?> tags)
Then create a second template that contains the text "NO DATA FOUND" as another sub-template.
Create a third template (this will be your main template called by the report), which imports the two sub-templates, then using a choose statement, count the number of occurences of you main repeating group in your XML. If the count = 0 then call the "NO_DATA_FOUND" sub-template, otherwise call the normal sub-template.
I hope this helps, if you need an example I can send you one, just let me know your email address.
Regards,
Cj 
Hi Cj
Thanks for your time. would appreciate if you can send me the example
my email address - satish.oracleapps#gmail.com
Thanks
Sam 
Hi Sam,
I have sent you some sample templates and XML to the email address in your last post.
Regards,
Cj 
Hi Cj
Have tried exactly as how u did in ur template, but the program still ends in 'completed warning' status. please check ur email have sent u my rtf.
Thanks
Sam 
Hi all,
Anybody has any other solution for this?
Thanks
Sam 
Thanks Cj. It's working now....
i got the import syntax wrong the first time 
Hi Cj,
Can you please send me the example to the email address - mamatha.bipublisher#gmail.com ?
Thanks in advance.
Mamatha. 
Hi Cj,
Can you please send me the example to the email address - mamatha.bipublisher#gmail.com ?
Thanks in advance.
Ashok.. 
Hi Cj,
Can you please send me the example to the email address - ashokt_mit#yahoo.com ?
Thanks in advance.
Ashok.. 
Hi,
Are you using # section in your template.Do you want to display a NO DATA FOUND or a pdf should not display when the case is.
Thanks,
Gaurav Puri 
Hi CJ,
I hate to be a pain but could you send me an example of that as well. My email is kkayes#hologic.com
Thanks,
ken 
Hi CJ,
It would be great if you could send me the example templates to bouroju#gmail.com.
thanks,
Kiran 
Hi everyone,
Could someone please mail this to me at manish4984#gmail.com.
Thanks in advance.
Manish

BI Publisher (OBIEE 11.1.1.5) email with body???

Hi All,
Is it possible to send an Email from BI Publisher with the message body and signature? I am able to send a mail with BI Publisher report as an attachment but I don't know where to add message body.
NOTE: I am not asking about Digital signature.
Thanks in advance. 
Hi
Its possible using the bursting script in the BI Publisher.
If you are using this then you can include this.
Cheers. 
Hi Eswar,
Thanks for your quick reply. Could you please provide any tutorial or example?
Thanks in advance. 
Hi
here you go in 10g hoping this will be similar.
http://docs.oracle.com/cd/E12096_01/books/PubUser/T421739T479695.htm
Cheers,
Mani. 
Thaks Eswar.
Is it possible to add an image (eg. Company logo) as a signature in the message body?
Thanks in advance. 
May be yes! not sure about this.
But one thing to consider, as you are using the bi publisher then why cant we use logo while creating the template and then use that to publish to the users.
hope this hleps.
Mani. 
Thanks again Eswar.
My client does not want have footer in the template itself. Thats why I am looking for this solution. If you find any example to do that, please get back to me. I am also googling for it with no success.
Thanks in advance.

sending report to mail

Hi every one........
I want to mail number of report at once to different email address ....but the problem is that it keeps in given me the mail box for each report i send .therefore i have to click on the send button (e.g microsoft outlook) .for each report.........
Any one can help me ..........
Thanks in advance
Hi,
If you are using 6i,
Run the report in "batch" mode. This will not bring up the send mail dialog.
For multiple email id's, you can give destype=mail desname=name1#oracle.com,name2#oracle.com,..etc. or use distribution.
In 9i, the standard SMPT protocol is used. Hence you will not get this problem.
You can see example "Bursting and Distributing"
http://otn.oracle.com/docs/products/reports/htdocs/doc_library/getstart/examples/Distribution/index.html
Thanks,
Siva B 
Hi Siva ..
Thank you for your information...and yes i'm using 6i...
but the problem that i'm using the a customized form parameter(form developer)..to run the report..
and i'm using the run_product procedure....so how can i use the parameter batch as yes ...and send it
to the report .. .
Thanks in advance
wesam Talib 
hi,
we are having problem to send email through web based report.
can u please provide me the steps for send mail through web based report.
--> i am running report from web and select Destination Type = Mail.
and getting following errors
1). rep-4202 Unable to log on to mail subsytem.
2). rep-4224 invalid username and password.
kindly reply to my queries.
my E-mail id is parthpandya123#rediffmail.com
thanks.
Hi There........
Well i think that u have to specify the destination format = rdf
and ofcourse the destination type = mail .
and i think that it should work ....
Regards,
Wesam Talib 
Hi Wesam,
Try setting execmode to BATCH in your RUN_PROCUCT call.
regards,
Stewart

Categories

Resources