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

Problem in designing report by passing dynamic query to the dataset

nayal_se

I am developing a Birt Report in which I need to pass dynamic query to the dataset from a previous page base on certain parameters.
Please suggest me some solution

Find more posts tagged with

Comments

Tubal

Each dataset has a beforeOpen script you can run that will fire before the dataset is opened.

The dataset's query is stored in this.queryText and is editable with java script.

So in your beforeOpen event, you would do something like:

this.queryText = this.queryText.replace("what I want to replace","what I want to replace it with")

In this example, I'm replacing the name of a table in my query with a name I build from one of the report parameters:

this.queryText = this.queryText.replace("stockslc", "stock" + params["branch"].value);

So I'm replacing any instance of "stockslc" in my query with a string built from the parameter named 'branch'.

nayal_se

Suppose I am passing four parameters in birt viewer than whether these parameters value can be get in the query using input parameters so that dynamic query can be generated according to that 
for eg: 
 
in birt:viewer is pass parameter as: 
 
<birt:viewer isHostPage="true" id="dealer_list" baseURL="/Report" reportDesign="/Dealer_List.rptdesign" width="800" height="800"> 
<birt:param name="state_id" value='<%= request.getAttribute("state_id")%>'></birt:param> 
</birt:viewer> 
 
in beforeOpen of dataset i write: 
this.queryText="select mfms.dealer.agency_name,mfms.dealer.dealer_id,mfms.dealer.mobile_no from mfms.dealer from where state_id="+params["state_id"]; 
 
but still giving error 
 
 
 
 
 
 
 
 
 
<blockquote class='ipsBlockquote' data-author="'Tubal'" data-cid="100037" data-time="1336403522" data-date="07 May 2012 - 08:12 AM">
Each dataset has a beforeOpen script you can run that will fire before the dataset is opened. 
 
The dataset's query is stored in this.queryText and is editable with java script. 
 
So in your beforeOpen event, you would do something like: 
 
this.queryText = this.queryText.replace("what I want to replace","what I want to replace it with") 
 
In this example, I'm replacing the name of a table in my query with a name I build from one of the report parameters: 
 
this.queryText = this.queryText.replace("stockslc", "stock" + params["branch"].value); 
 
So I'm replacing any instance of "stockslc" in my query with a string built from the parameter named 'branch'. </blockquote>

Tubal

What error is it giving you?

You may need to do some testing to see if you are actually receiving any data in your state_id parameter. Make a data cell somewhere in your report that calls that parameter to see what it gives you.

And also test your query by hardcoding the state_id to see if you get an error. (put an actual state in there instead of getting it from a parameter, just to see if your query runs without error)

EDIT: Actually I see an error in your query in the beforeOpen text.

You've got an extra FROM in there, right before your WHERE.

nayal_se

<blockquote class='ipsBlockquote' data-author="'Tubal'" data-cid="100113" data-time="1336499328" data-date="08 May 2012 - 10:48 AM">
What error is it giving you? 
 
You may need to do some testing to see if you are actually receiving any data in your state_id parameter. Make a data cell somewhere in your report that calls that parameter to see what it gives you. 
 
And also test your query by hardcoding the state_id to see if you get an error. (put an actual state in there instead of getting it from a parameter, just to see if your query runs without error) 
 
 
EDIT: Actually I see an error in your query in the beforeOpen text. 
 
You've got an extra FROM in there, right before your WHERE. </blockquote>
 
Please help me out in solving this problem 
 
I have developed a Report Dealer_list.rptdesign: 
 
Report Source: 
 
<?xml version="1.0" encoding="UTF-8"?> 
<report xmlns="<a class='bbc_url' href='http://www.eclipse.org/birt/2005/design'>http://www.eclipse.org/birt/2005/design"</a> version="3.2.23" id="1"> 
<property name="createdBy">Eclipse BIRT Designer Version 3.7.2.v20120213 Build <3.7.2.v20120214-1408></property> 
<property name="units">in</property> 
<property name="iconFile">/templates/simple_listing.gif</property> 
<property name="cheatSheet">org.eclipse.birt.report.designer.ui.cheatsheet.simplelisting</property> 
<property name="bidiLayoutOrientation">ltr</property> 
<property name="imageDPI">96</property> 
<parameters> 
<scalar-parameter name="state_id" id="28"> 
<property name="hidden">true</property> 
<property name="valueType">static</property> 
<property name="dataType">string</property> 
<property name="distinct">true</property> 
<list-property name="selectionList"/> 
<property name="paramType">simple</property> 
<property name="controlType">text-box</property> 
<structure name="format"> 
<property name="category">Unformatted</property> 
</structure> 
</scalar-parameter> 
</parameters> 
<data-sources> 
<oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="datasource_DealerList" id="27"> 
<list-property name="privateDriverProperties"> 
<ex-property> 
<name>metadataBidiFormatStr</name> 
<value>ILYNN</value> 
</ex-property> 
<ex-property> 
<name>disabledMetadataBidiFormatStr</name> 
</ex-property> 
<ex-property> 
<name>contentBidiFormatStr</name> 
<value>ILYNN</value> 
</ex-property> 
<ex-property> 
<name>disabledContentBidiFormatStr</name> 
</ex-property> 
</list-property> 
<property name="odaDriverClass">org.postgresql.Driver</property> 
<property name="odaURL">jdbc:postgresql://localhost:5432/mfms</property> 
<property name="odaUser">postgres</property> 
<encrypted-property name="odaPassword" encryptionID="base64">c2FydGhhaw==</encrypted-property> 
</oda-data-source> 
</data-sources> 
<data-sets> 
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="dataset_DealerList" id="29"> 
<list-property name="parameters"> 
<structure> 
<property name="name">state_id</property> 
<property name="paramName">state_id</property> 
<property name="dataType">integer</property> 
<property name="position">1</property> 
<property name="isInput">true</property> 
<property name="isOutput">false</property> 
</structure> 
</list-property> 
<structure name="cachedMetaData"/> 
<method name="beforeOpen"><![CDATA[this.queryText="select mfms.dealer.agency_name,mfms.dealer.dealer_id,mfms.dealer.mobile_no from mfms.dealer";]]></method> 
<property name="dataSource">datasource_DealerList</property> 
<xml-property name="queryText"><![CDATA[select 
from ]]></xml-property> 
<xml-property name="designerValues"><![CDATA[]]></xml-property> 
</oda-data-set> 
</data-sets> 
<styles> 
<style name="report" id="24"> 
<property name="fontFamily">sans-serif</property> 
<property name="fontSize">10pt</property> 
</style> 
<style name="crosstab-cell" id="25"> 
<property name="borderBottomColor">#CCCCCC</property> 
<property name="borderBottomStyle">solid</property> 
<property name="borderBottomWidth">1pt</property> 
<property name="borderLeftColor">#CCCCCC</property> 
<property name="borderLeftStyle">solid</property> 
<property name="borderLeftWidth">1pt</property> 
<property name="borderRightColor">#CCCCCC</property> 
<property name="borderRightStyle">solid</property> 
<property name="borderRightWidth">1pt</property> 
<property name="borderTopColor">#CCCCCC</property> 
<property name="borderTopStyle">solid</property> 
<property name="borderTopWidth">1pt</property> 
</style> 
<style name="crosstab" id="26"> 
<property name="borderBottomColor">#CCCCCC</property> 
<property name="borderBottomStyle">solid</property> 
<property name="borderBottomWidth">1pt</property> 
<property name="borderLeftColor">#CCCCCC</property> 
<property name="borderLeftStyle">solid</property> 
<property name="borderLeftWidth">1pt</property> 
<property name="borderRightColor">#CCCCCC</property> 
<property name="borderRightStyle">solid</property> 
<property name="borderRightWidth">1pt</property> 
<property name="borderTopColor">#CCCCCC</property> 
<property name="borderTopStyle">solid</property> 
<property name="borderTopWidth">1pt</property> 
</style> 
</styles> 
<page-setup> 
<simple-master-page name="Simple MasterPage" id="2"> 
<page-footer> 
<text id="3"> 
<property name="contentType">html</property> 
<text-property name="content"><![CDATA[<value-of>new Date()</value-of>]]></text-property> 
</text> 
</page-footer> 
</simple-master-page> 
</page-setup> 
<body> 
<table id="4"> 
<property name="width">100%</property> 
<property name="dataSet">dataset_DealerList</property> 
<list-property name="boundDataColumns"> 
<structure> 
<property name="name">agency_name</property> 
<text-property name="displayName">Agency Name</text-property> 
<expression name="expression" type="javascript">dataSetRow["agency_name"]</expression> 
<property name="dataType">string</property> 
<property name="allowExport">true</property> 
</structure> 
</list-property> 
<property name="pageBreakInterval">50</property> 
<column id="20"/> 
<column id="21"/> 
<column id="22"/> 
<header> 
<row id="5"> 
<cell id="6"/> 
<cell id="7"/> 
<cell id="8"/> 
</row> 
</header> 
<detail> 
<row id="10"> 
<cell id="11"> 
<data id="40"> 
<property name="dataSet">dataset_DealerList</property> 
<list-property name="boundDataColumns"> 
<structure> 
<property name="name">agency_name</property> 
<text-property name="displayName">Agency Name</text-property> 
<expression name="expression" type="javascript">dataSetRow["agency_name"]</expression> 
<property name="dataType">string</property> 
<property name="allowExport">true</property> 
</structure> 
</list-property> 
<property name="resultSetColumn">agency_name</property> 
</data> 
</cell> 
<cell id="12"> 
<data id="34"> 
<property name="dataSet">dataset_DealerList</property> 
<list-property name="boundDataColumns"> 
<structure> 
<property name="name">dealer_id</property> 
<text-property name="displayName">Dealer_Id</text-property> 
<expression name="expression" type="javascript">dataSetRow["dealer_id"]</expression> 
<property name="dataType">integer</property> 
<property name="allowExport">true</property> 
</structure> 
</list-property> 
<property name="resultSetColumn">dealer_id</property> 
</data> 
</cell> 
<cell id="13"> 
<data id="35"> 
<property name="dataSet">dataset_DealerList</property> 
<list-property name="boundDataColumns"> 
<structure> 
<property name="name">mobile_no</property> 
<text-property name="displayName">Mobile Number</text-property> 
<expression name="expression" type="javascript">dataSetRow["mobile_no"]</expression> 
<property name="dataType">string</property> 
<property name="allowExport">true</property> 
</structure> 
</list-property> 
<property name="resultSetColumn">mobile_no</property> 
</data> 
</cell> 
</row> 
</detail> 
<footer> 
<row id="15"> 
<cell id="16"/> 
<cell id="17"/> 
<cell id="18"/> 
</row> 
</footer> 
</table> 
</body> 
</report> 
 
 
When I am previwing it in Eclipse or viewing it in Web Viewer it is giving following error: 
 
Error: 
 
HTTP ERROR 500 
Problem accessing /viewer/run. Reason: 
 
javax/servlet/ServletConfig 
 
Caused by: 
java.lang.LinkageError: javax/servlet/ServletConfig 
at org.eclipse.birt.report.utility.ParameterAccessor.initParameters(ParameterAccessor.java:1460) 
at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.init(BirtSoapMessageDispatcherServlet.java:102) 
at org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrapper.initializeDelegate(ServletManager.java:195) 
at org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrapper.service(ServletManager.java:179) 
at org.eclipse.equinox.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:61) 
at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:126) 
at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:60) 
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) 
at org.eclipse.equinox.http.jetty.internal.HttpServerManager$InternalHttpServiceServlet.service(HttpServerManager.java:317) 
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511) 
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:390) 
at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182) 
at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765) 
at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) 
at org.mortbay.jetty.Server.handle(Server.java:322) 
at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542) 
at org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:924) 
at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:549) 
at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212) 
at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404) 
at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:409) 
at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582) 
 
 
 
 
When I run the report in web brower it is giving following error at this url: 
 
<a class='bbc_url' href='http://localhost:808...masterpage=true'>http://localhost:808...masterpage=true</a> 
 
Error: 
 
HTTP Status 404 - /Report/frameset

type Status report 
 
message /Report/frameset 
 
description The requested resource (/Report/frameset) is not available.

Apache Tomcat/6.0.30

SailRCG

Can you provide the rptdesign file as an attachment? 
 
I think I can find some example dynamic query designs, but I'd like to find one similar to what you're trying to achieve. 
 
Thanks, 
 
RG 
 
 
 
 
<blockquote class='ipsBlockquote' data-author="'nayal_se'" data-cid="100127" data-time="1336542110" data-date="08 May 2012 - 10:41 PM">
Please help me out in solving this problem 
 
I have developed a Report Dealer_list.rptdesign: 
 
Report Source: 
 
<?xml version="1.0" encoding="UTF-8"?> 
<report xmlns="<a class='bbc_url' href='http://www.eclipse.org/birt/2005/design'>http://www.eclipse.org/birt/2005/design"</a> version="3.2.23" id="1"> 
<property name="createdBy">Eclipse BIRT Designer Version 3.7.2.v20120213 Build <3.7.2.v20120214-1408></property> 
<property name="units">in</property> 
<property name="iconFile">/templates/simple_listing.gif</property> 
<property name="cheatSheet">org.eclipse.birt.report.designer.ui.cheatsheet.simplelisting</property> 
<property name="bidiLayoutOrientation">ltr</property> 
<property name="imageDPI">96</property> 
<parameters> 
<scalar-parameter name="state_id" id="28"> 
<property name="hidden">true</property> 
<property name="valueType">static</property> 
<property name="dataType">string</property> 
<property name="distinct">true</property> 
<list-property name="selectionList"/> 
<property name="paramType">simple</property> 
<property name="controlType">text-box</property> 
<structure name="format"> 
<property name="category">Unformatted</property> 
</structure> 
</scalar-parameter> 
</parameters> 
<data-sources> 
<oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="datasource_DealerList" id="27"> 
<list-property name="privateDriverProperties"> 
<ex-property> 
<name>metadataBidiFormatStr</name> 
<value>ILYNN</value> 
</ex-property> 
<ex-property> 
<name>disabledMetadataBidiFormatStr</name> 
</ex-property> 
<ex-property> 
<name>contentBidiFormatStr</name> 
<value>ILYNN</value> 
</ex-property> 
<ex-property> 
<name>disabledContentBidiFormatStr</name> 
</ex-property> 
</list-property> 
<property name="odaDriverClass">org.postgresql.Driver</property> 
<property name="odaURL">jdbc:postgresql://localhost:5432/mfms</property> 
<property name="odaUser">postgres</property> 
<encrypted-property name="odaPassword" encryptionID="base64">c2FydGhhaw==</encrypted-property> 
</oda-data-source> 
</data-sources> 
<data-sets> 
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="dataset_DealerList" id="29"> 
<list-property name="parameters"> 
<structure> 
<property name="name">state_id</property> 
<property name="paramName">state_id</property> 
<property name="dataType">integer</property> 
<property name="position">1</property> 
<property name="isInput">true</property> 
<property name="isOutput">false</property> 
</structure> 
</list-property> 
<structure name="cachedMetaData"/> 
<method name="beforeOpen"><![CDATA[this.queryText="select mfms.dealer.agency_name,mfms.dealer.dealer_id,mfms.dealer.mobile_no from mfms.dealer";]]></method> 
<property name="dataSource">datasource_DealerList</property> 
<xml-property name="queryText"><![CDATA[select 
from ]]></xml-property> 
<xml-property name="designerValues"><![CDATA[]]></xml-property> 
</oda-data-set> 
</data-sets> 
<styles> 
<style name="report" id="24"> 
<property name="fontFamily">sans-serif</property> 
<property name="fontSize">10pt</property> 
</style> 
<style name="crosstab-cell" id="25"> 
<property name="borderBottomColor">#CCCCCC</property> 
<property name="borderBottomStyle">solid</property> 
<property name="borderBottomWidth">1pt</property> 
<property name="borderLeftColor">#CCCCCC</property> 
<property name="borderLeftStyle">solid</property> 
<property name="borderLeftWidth">1pt</property> 
<property name="borderRightColor">#CCCCCC</property> 
<property name="borderRightStyle">solid</property> 
<property name="borderRightWidth">1pt</property> 
<property name="borderTopColor">#CCCCCC</property> 
<property name="borderTopStyle">solid</property> 
<property name="borderTopWidth">1pt</property> 
</style> 
<style name="crosstab" id="26"> 
<property name="borderBottomColor">#CCCCCC</property> 
<property name="borderBottomStyle">solid</property> 
<property name="borderBottomWidth">1pt</property> 
<property name="borderLeftColor">#CCCCCC</property> 
<property name="borderLeftStyle">solid</property> 
<property name="borderLeftWidth">1pt</property> 
<property name="borderRightColor">#CCCCCC</property> 
<property name="borderRightStyle">solid</property> 
<property name="borderRightWidth">1pt</property> 
<property name="borderTopColor">#CCCCCC</property> 
<property name="borderTopStyle">solid</property> 
<property name="borderTopWidth">1pt</property> 
</style> 
</styles> 
<page-setup> 
<simple-master-page name="Simple MasterPage" id="2"> 
<page-footer> 
<text id="3"> 
<property name="contentType">html</property> 
<text-property name="content"><![CDATA[<value-of>new Date()</value-of>]]></text-property> 
</text> 
</page-footer> 
</simple-master-page> 
</page-setup> 
<body> 
<table id="4"> 
<property name="width">100%</property> 
<property name="dataSet">dataset_DealerList</property> 
<list-property name="boundDataColumns"> 
<structure> 
<property name="name">agency_name</property> 
<text-property name="displayName">Agency Name</text-property> 
<expression name="expression" type="javascript">dataSetRow["agency_name"]</expression> 
<property name="dataType">string</property> 
<property name="allowExport">true</property> 
</structure> 
</list-property> 
<property name="pageBreakInterval">50</property> 
<column id="20"/> 
<column id="21"/> 
<column id="22"/> 
<header> 
<row id="5"> 
<cell id="6"/> 
<cell id="7"/> 
<cell id="8"/> 
</row> 
</header> 
<detail> 
<row id="10"> 
<cell id="11"> 
<data id="40"> 
<property name="dataSet">dataset_DealerList</property> 
<list-property name="boundDataColumns"> 
<structure> 
<property name="name">agency_name</property> 
<text-property name="displayName">Agency Name</text-property> 
<expression name="expression" type="javascript">dataSetRow["agency_name"]</expression> 
<property name="dataType">string</property> 
<property name="allowExport">true</property> 
</structure> 
</list-property> 
<property name="resultSetColumn">agency_name</property> 
</data> 
</cell> 
<cell id="12"> 
<data id="34"> 
<property name="dataSet">dataset_DealerList</property> 
<list-property name="boundDataColumns"> 
<structure> 
<property name="name">dealer_id</property> 
<text-property name="displayName">Dealer_Id</text-property> 
<expression name="expression" type="javascript">dataSetRow["dealer_id"]</expression> 
<property name="dataType">integer</property> 
<property name="allowExport">true</property> 
</structure> 
</list-property> 
<property name="resultSetColumn">dealer_id</property> 
</data> 
</cell> 
<cell id="13"> 
<data id="35"> 
<property name="dataSet">dataset_DealerList</property> 
<list-property name="boundDataColumns"> 
<structure> 
<property name="name">mobile_no</property> 
<text-property name="displayName">Mobile Number</text-property> 
<expression name="expression" type="javascript">dataSetRow["mobile_no"]</expression> 
<property name="dataType">string</property> 
<property name="allowExport">true</property> 
</structure> 
</list-property> 
<property name="resultSetColumn">mobile_no</property> 
</data> 
</cell> 
</row> 
</detail> 
<footer> 
<row id="15"> 
<cell id="16"/> 
<cell id="17"/> 
<cell id="18"/> 
</row> 
</footer> 
</table> 
</body> 
</report> 
 
 
When I am previwing it in Eclipse or viewing it in Web Viewer it is giving following error: 
 
Error: 
 
HTTP ERROR 500 
Problem accessing /viewer/run. Reason: 
 
javax/servlet/ServletConfig 
 
Caused by: 
java.lang.LinkageError: javax/servlet/ServletConfig 
at org.eclipse.birt.report.utility.ParameterAccessor.initParameters(ParameterAccessor.java:1460) 
at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.init(BirtSoapMessageDispatcherServlet.java:102) 
at org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrapper.initializeDelegate(ServletManager.java:195) 
at org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrapper.service(ServletManager.java:179) 
at org.eclipse.equinox.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:61) 
at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:126) 
at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:60) 
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) 
at org.eclipse.equinox.http.jetty.internal.HttpServerManager$InternalHttpServiceServlet.service(HttpServerManager.java:317) 
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511) 
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:390) 
at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182) 
at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765) 
at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) 
at org.mortbay.jetty.Server.handle(Server.java:322) 
at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542) 
at org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:924) 
at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:549) 
at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212) 
at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404) 
at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:409) 
at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582) 
 
 
 
 
When I run the report in web brower it is giving following error at this url: 
 
<a class='bbc_url' href='http://localhost:808...masterpage=true'>http://localhost:808...masterpage=true</a> 
 
Error: 
 
HTTP Status 404 - /Report/frameset

type Status report 
 
message /Report/frameset 
 
description The requested resource (/Report/frameset) is not available.

Apache Tomcat/6.0.30 </blockquote>

nayal_se

<blockquote class='ipsBlockquote' data-author="'SailRCG'" data-cid="100165" data-time="1336589041" data-date="09 May 2012 - 11:44 AM">
Can you provide the rptdesign file as an attachment? 
 
I think I can find some example dynamic query designs, but I'd like to find one similar to what you're trying to achieve. 
 
Thanks, 
 
RG </blockquote>
 
I have enclosed the report design file as an attachment. 
Please help me out. 
 
Regards, 
Ashish