nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Report design file with datetime parameter for BIRT enclosed SampleDB

ber

<p>i'm looking for a report design file similar to below with datetime parameters for <a data-ipb='nomediaparse' href='http://www.eclipse.org/birt/phoenix/db/'>SampleDB enclosed in BIRT</a></p><p> </p><p>...</p><div><parameters></div><div> <scalar-parameter name="OrderDate"></div><div><span style="font-size:14px;"> <property name="dataType">date-time</property></span></div><div><span style="font-size:14px;"> <property name="defaultValue">...</property></span></div><div><span style="font-size:14px;"> </scalar-parameter></span></div><div><span style="font-size:14px;"> <scalar-parameter name="PaymentDate"></span></div><div><span style="font-size:14px;"> <property name="dataType">date-time</property></span></div><div><span style="font-size:14px;"> <property name="defaultValue">...</property></span></div><div><span style="font-size:14px;"> </scalar-parameter></span></div><div><span style="font-size:14px;"></parameters></span></div><div><span style="font-size:14px;">...</span></div><div> </div><div>Thanks a lot!</div>

Find more posts tagged with

Comments

kclark

<p>Are you just trying to create a date time parameter or have a custom calendar selection parameter?</p>

ber

<p>Thanks for your reply.</p><p> </p><p>My purpose is to get a design example file to test date-time parameter in a program, so i only need [color=rgb(0,0,0);font-family:helvetica, arial, sans-serif;font-size:14px;]a parameter with data-type as date-time in it, which is dedicated to the <a data-ipb='nomediaparse' href='http://www.eclipse.org/birt/phoenix/db/'>SampleDB</a> and used to produce a report with results by something similar to the query below,[/color]</p><p> </p><p>[color=rgb(0,0,0);font-family:helvetica, arial, sans-serif;font-size:14px;]select orderNum, [/color][color=rgb(0,0,0);font-family:helvetica, arial, sans-serif;font-size:14px;]customer, [/color]<span style="font-size:14px;color:rgb(0,0,0);font-family:helvetica, arial, sans-serif;">... from </span><span style="font-size:14px;color:rgb(0,0,0);font-family:helvetica, arial, sans-serif;">... where </span><span style="font-size:14px;color:rgb(40,40,40);font-family:helvetica, arial, sans-serif;">OrderDate=...</span></p>

kclark

<p>Can you post an rptdesign showing what your doing? From what I understand you should be able to do</p><pre class="_prettyXprint">select orderNumber, customer, ... from customers where OrderDate = ?</pre><p>Then you can create a report parameter and link it to your data set from the parameters window in the data set UI.</p>

ber

<p>Thanks for your reply.</p><p> </p><p>Unfortunately i'm not BIRT designer. I really need an existing <strong>BIRT report design file.</strong></p><p> </p><p>It uses <strong>datetime parameters for end user </strong>to query <strong><a data-ipb='nomediaparse' href='http://www.eclipse.org/birt/phoenix/db'>BIRT SampleDB</a></strong> .</p><p> </p><p>Then, i'm able to use it to validate my <strong>Java code</strong>, which is based on <strong>BIRT report engine API</strong> and invokes the method call <strong>IGetParameterDefinitionTask#getParameterDefns</strong>.</p><p> </p><p>Hope this clarifies.</p>