<div>
As you found out you can't pass them<br />
<br />
<a href="http://technicalsupport.businessobjects.com/KanisaSupportSite/search.do?cmd=displayKC&docType=kc&externalId=5270990&sliceId=&dialogID=17904008&stateId=1%200%2017902682" rel="ugc">http://technicalsupport.businessobjects.com/KanisaSupportSite/search.do?cmd=displayKC&docType=kc&externalId=5270990&sliceId=&dialogID=17904008&stateId=1%200%2017902682</a><br />
<br />
Can you use a subreport?<br />
<br />
mlmcc
</div>


As you found out you can't pass them

http://technicalsupport.businessobjects.com/KanisaSupportSite/search.do?cmd=displayKC&docType=kc&externalId=5270990&sliceId=&dialogID=17904008&stateId=1%200%2017902682 [http://technicalsupport.businessobjects.com/KanisaSupportSite/search.do?cmd=displayKC&docType=kc&externalId=5270990&sliceId=&dialogID=17904008&stateId=1%200%2017902682]

Can you use a subreport?

mlmcc

<div>
Thanks experts. I tried to use subreport. But can not make link to the subreport. Main report table date field doesn't match the date field in subreport table.<br />
<br />
Eg. main report show user login to system multi times a day. Each day user may have vary number of transactions. How can summarize transaction amount in subreport by the date range in main report?<br />
<br />

</div>


Thanks experts. I tried to use subreport. But can not make link to the subreport. Main report table date field doesn't match the date field in subreport table.

Eg. main report show user login to system multi times a day. Each day user may have vary number of transactions. How can summarize transaction amount in subreport by the date range in main report?



<div>
WHat are the date fields in each report?<br />
<br />
mlmcc
</div>


WHat are the date fields in each report?

mlmcc

<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
&nbsp;I have a Crystal report which need to summarize value from another table using paramters entered by user and the value can only sum in a sql exprssion field. But Sql expression can not reach the parameters. e.g<br />
(select sum(price) from InvoiceSum where Invoicedate &nbsp;beteen {?sDate} and {?eDate})<br />
<br />
Please help.<br />
<br />
Cw<br />
<br />

</div>
</div>


Hi Experts,

 I have a Crystal report which need to summarize value from another table using paramters entered by user and the value can only sum in a sql exprssion field. But Sql expression can not reach the parameters. e.g
(select sum(price) from InvoiceSum where Invoicedate  beteen {?sDate} and {?eDate})

Please help.

Cw



how to use parameters in SQL Expression field

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.