Thank you for your reply...
I am sorry to sound redundant...
I had started off by downloading the birt-all-in-one (came bundled with the
full Eclipse SDK).
Created a maven project( wicket quickstart) , then designed the birt
rptdesign (all within the eclipse platform) I run it outside eclipse, (mvn
jetty:run)

Now, I have downloaded the birt runtime engine, and copied files from the
birtrunttime\ReportEngine\plugins to the eclipse\plugins

But when I try to use "org.eclipse.birt.report.engine.api.ReportEngine" i
get "org.eclipse cannot be resolved"

Not sure what I should do for this.
Thank you for your help..and again sorry to sound redundant, I am really new
to this.


reiern70 wrote:
> 
> Hi,
> 
> For the BIRT part you need to install somewhere a BIRT runtime.
> Essentially, this an equinox OSGi runtime with a folder structure like:
> 
> {root}-configuration`
>          -plugins
> 
> If you have extended BIRT by adding your own ODA extensions then you have
> to drop them on the plugins folder. There is also a folder (e.g.
> plugins/org.eclipse.birt.report.data.oda.jdbc_2.3.0.v20080610/drivers)
> where you have to drop any JDBC drivers you need to connect to your
> database (in case you are using standard ODA drivers). I usually install
> the BIRT runtime under WEB-INF...
> 
> The next step is to have instantiate this runtime and use it to generate
> your reports. I do this via a class like the following:
> 
> 
> public class Birt {
>       
>         .............
> 
>         private static IReportEngine engine;
> 
> 
>       public static final void startEngine() {
>               try {
>                       if(engine != null)
>                               return;
>                       
>                       EngineConfig engCnf = new EngineConfig();               
>         
>               
> engCnf.setEngineHome(ConfigGlobal.i.resuelveRuta("WEB-INF/birt").toString());
>                       
> engCnf.setLogConfig(ConfigGlobal.i.resuelveRuta("../logs").toString(),
> Level.ALL);                   
>                       Platform.startup(engCnf);
>                       IReportEngineFactory factory = (IReportEngineFactory) 
> Platform
>                               .createFactoryObject(
> IReportEngineFactory.EXTENSION_REPORT_ENGINE_FACTORY );
>                       engine = factory.createReportEngine(engCnf);
>                       engine.changeLogLevel( Level.OFF );                     
>                         
>               } catch (Throwable ex) {
>                       log.fatal("", ex);
>               }
>       }
>       
>       public static final void stopEngine() {
>               try {
>                       engine.destroy();
>                       engine = null;
>               } catch (Exception e) {
>               }
>       }
>       
>       public static IReportEngine getEngine() {
>               if(engine == null) {
>                       startEngine();
>               }
>               return engine;
>       }
>  
> 
>         public static void generateBirtReport(String file, 
>                       String fmt, 
>                       OutputStream out, 
>                       IdSql area, 
>                       ReportInfo petA, 
>                       JSONObject parametros_Reporte, Locale locale, boolean 
> autoPageBreaking)
> throws Exception {
>               Attachment attachment = Attachment.loadFromTable(file, area);
>               File tmpDir =
> ConfigGlobal.i.resuelveRuta(LectorConfig.i.get().getChild("dirs").getChild("tmp").getValue());
>               // creating a resource locator that is capable of retrieving 
> libraries 
>               // or images from the database...
>               DataBaseResourceLocator dataBaseResourceLocator = new
> DataBaseResourceLocator(area);
>               IReportRunnable design =
> getEngine().openReportDesign("test",attachment.getAsInputStream(),
> dataBaseResourceLocator);
>       
> updateDataSources((ReportDesignHandle)design.getDesignHandle().getModuleHandle(),
> petA);
>               IRunAndRenderTask renderTask =
> getEngine().createRunAndRenderTask(design);
>               RenderOption opcRend;
>               if ("pdf".equals(fmt)) {
>                       PDFRenderOption opc = new PDFRenderOption();
>                       opc.setOutputFormat("pdf");
>                       //ReportDesignHandle designHandle =
> (ReportDesignHandle)design.getDesignHandle().getModuleHandle();               
>         
>                       //designHandle.setDisplayName(null);
>                       // para reducir la pagina tal como sale desde el 
> diseƱador BIRT
>                       opc.setOption(PDFRenderOption.PAGEBREAK_PAGINATION_ONLY,
> autoPageBreaking);
>                       opc.setOption(PDFRenderOption.FIT_TO_PAGE, 
> autoPageBreaking);
>                       
>                       opcRend = opc;
>               } else if ("excel".equals(fmt)){
>                       // TODO: find if there is 
>                       opcRend = new RenderOption();
>                       opcRend.setOutputFormat("xls");                 
>               } else {
>                       HTMLRenderOption opc = new HTMLRenderOption();
>                       opc.setHtmlTitle(design.getReportName());
>                       opc.setBaseImageURL("/recursos/img/x.birt-img?imagen=");
>                       opc.setImageDirectory(tmpDir.getAbsolutePath());
>                       opc.setImageHandler(new HTMLServerImageHandler());
>                       opcRend = opc;
>               }
>               // hanlde report paramteters.
>               if(parametros_Reporte != null) {
>                       Iterator<String> it = 
> (Iterator<String>)parametros_Reporte.keys(); 
>                       while(it.hasNext()) {
>                               String param = it.next();
>                               try {
>                                       // first try to handle the parameter as 
> multivalued.
>                                       JSONArray array = 
> parametros_Reporte.getJSONArray(param);
>                                       Object[] values = new 
> Object[]{array.length()};
>                                       for(int i=0; i < array.length(); i++) {
>                                               try {
>                                                       values[i] = 
> array.get(i);
>                                               } catch (Exception e) {
>                                                       values[i] = null;
>                                               }
>                                       }
>                                       renderTask.setParameterValue(param, 
> values);
>                               } catch (Exception e) {
>                                       // if parameter is not multi-valued 
> then treat it as single-valued.
>                                       String value = 
> parametros_Reporte.getString(param);                             
>                                       renderTask.setParameterValue(param, 
> value);
>                               }                               
>                       }
>               }
>               opcRend.setOutputStream(out);                           
>               renderTask.setLocale(locale);
>               renderTask.setRenderOption(opcRend);
>               renderTask.run();
>       }
>         .........
> 
> }
> 
> This class initializes a singleton BIRT runtime and the
> generateBirtReport(...) method can be used to read the report design from
> a database and generate the corresponding report (PDF, excel, HTML).  If
> you filter out the logic that is specific to my use case you can easily
> build your own machinery for building reports based on code given above.
> 
> As for the generation of the download link there should be plenty of
> examples and/or related threads in this list... 
> 
> Best,
> 
> Ernesto
> 
> 
> 
> 
> 
> 
> 
> newbieabc wrote:
>> 
>> The generation of the excel report.
>> I am really new to BIRT and wicket..
>> I've created the BIRT report (report.rptdesign)(in eclipse) but need it
>> to be output as xls.
>> I'd really appreciate some help. 
>> Thank you
>> 
>> 
>> reiern70 wrote:
>>> 
>>> Sure you can... Which part is giving you problems? The generation of the
>>> excel report with BIRT? Or the creation of the link?
>>> 
>>> Best,
>>> 
>>> Ernesto
>>> 
>>> newbieabc wrote:
>>>> Hello..
>>>> How can create a download link on a webpage, that converts a BIRT
>>>> report to
>>>> excel format and downloads to client machine?
>>>>
>>>> Thank you.
>>>>   
>>> 
>>> 
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: [email protected]
>>> For additional commands, e-mail: [email protected]
>>> 
>>> 
>>> 
>> 
>> 
> 
> 

-- 
View this message in context: 
http://www.nabble.com/DownloadLink%2C-BIRT-report-tp21218997p21293883.html
Sent from the Wicket - User mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to