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; } } }

parameter

siraj_farooq

i am using a online DB......i have set parameters earlier in differnt db....but i am having problem now with online db...any one knows how....???????????

Find more posts tagged with

Comments

kclark

What kind of database are you working with? You'd add the parameter in the query. If you using mysql it'd look something like this<pre class="_prettyXprint">select customernumber, paymentdate, amountfrom paymentswhere customernumber = ?</pre>Then in the "parameters" section of the data set UI you can link that to a report parameter. Let me know if I'm understanding what your requirements are

Also, here's a <a data-ipb='nomediaparse' href='http://www.birt-exchange.org/devshare/_/designing-birt-reports/969-birt-cascading-parameter-example'>link to a devshare</a> that shows how to setup a cascading parameter.

siraj_farooq

thanks kclark i am using a online database.....i already know the method you have described...but it is not working in my case.when i add a it in query paramater is not defined automatically in parameter colum.......is there any other way to do it...... :unsure:

kclark

Is your online database mysql, mongodb, etc?

BRM

<blockquote class="ipsBlockquote" data-author="siraj_farooq" data-cid="120074" data-time="1378813385"><div>......is there any other way to do it...... :unsure:</div></blockquote> There is always another way to do it but, in my experience and I am pretty sure that of others, running a parameterized query against an online database works the same as it does when the database is local. If you'll describe the error you are getting (and attach screenshots if you can) we might be able to help you figure out what the problem is.

siraj_farooq

i have added screen shot of my problem......see if you have any solution to this problem

siraj_farooq

<a data-ipb='nomediaparse' href='http://www.birt-exchange.org/forum/index.php?/topic/29016-adding-new-drop-down-in-birt-report-and-changing-query-parameter-based-on-value-from-dropdown/'>http://www.birt-exchange.org/forum/index.php?/topic/29016-adding-new-drop-down-in-birt-report-and-changing-query-parameter-based-on-value-from-dropdown/</a> if (params["Country"] != "All"){this.queryText = this.queryText + " and CLASSICMODELS.CUSTOMERS.COUNTRY = '" + params["Country"] + "'";}can i add parameter by this method ?????????

siraj_farooq

<blockquote class="ipsBlockquote" data-author="siraj_farooq" data-cid="120134" data-time="1378884134"><div><a data-ipb='nomediaparse' href='http://www.birt-exchange.org/forum/index.php?/topic/29016-adding-new-drop-down-in-birt-report-and-changing-query-parameter-based-on-value-from-dropdown/'>http://www.birt-exchange.org/forum/index.php?/topic/29016-adding-new-drop-down-in-birt-report-and-changing-query-parameter-based-on-value-from-dropdown/</a> if (params["Country"] != "All"){this.queryText = this.queryText + " and CLASSICMODELS.CUSTOMERS.COUNTRY = '" + params["Country"] + "'";}can i add parameter by this method ?????????</div></blockquote> here is the error displayed in preview menu when i add a query.....e,g costumer.numeber = ?(data type is bidint) or can it have any thing to do with schema

Hans_vd

If you add a "?" to your query, you need to somehow provide a value. So did you bind the data set parameter to a report parameter?Or did you provide a default value?

siraj_farooq

han_vd thanks,my problem is solved......it was problem in the driver..last figured it out