Using SSRS Parameter with Epicor

Yahoo Archive
1
Here's an example of how you can use a parameter in your calculations.

Parameters!CutoffCDate.Value is a parameter derived from a field entered
from the BAQ report.

I've attached a couple of screen shots showing how I converted the entered
field to a date parameter. If they don't make it let me know and I'll send
them to you directly.

Here's the expression in an aging column. Of course, you'd have to use a
different expression to get a value based on your comparisons, but maybe
this will get you started.

=sum(iif(Fields!APInvHed_DueDate.Value <= dateadd("d", -30,
Parameters!CutoffCDate.Value) AND Fields!APInvHed_DueDate.Value >
dateadd("d", -60, *Parameters!CutoffCDate.Value*),
Fields!APInvHed_InvoiceBal.Value, Nothing))

Hope it helps.

Joe Trent

On Thu, Jan 28, 2016 at 10:57 AM, bkithca88@... [vantage] <
vantage@yahoogroups.com> wrote:

>
>
> Thanks for the fast response. I looked into that but the issue is that
> these parameters are used to see a what if scenario for ex. if parameter 1
> is shipping cost and that value is $25.00 how will it compare to the
> current cost from that customer. So the overall idea for this is to have 13
> different optional parameters that will ultimately show a new what if price
> for the customer. I just assumed there had to be a way to make the
> parameters on the crystal level appear to be entered. Hopefully this
> explanation will help.
>
> Thanks,
>
>
>


[Non-text portions of this message have been removed]
2

Hello All,


I am trying to make an SSRS BAQ report but the report needs to be able to have optional parameters entered on the SSRS level not the BAQ level. So the question is how to make the SSRS parameters appear before the report fully runs? 



Thanks,

Brandon

3
In the BAQ Report Designer there is an option to add Paramter1, Paramter2 etc.. to the BAQ Report Options... then these are passed into the Report in the DataSet and you can use them to do whatever you need.Â


Jose C Gomez
Software Engineer


T: 904.469.1524 mobile

Quis custodiet ipsos custodes?

On Thu, Jan 28, 2016 at 11:36 AM, bkithca88@... [vantage] <vantage@yahoogroups.com> wrote:

 
<div>
  
  
  <p></p><p><span>Hello All,</span></p><p><span><br></span></p><p><span>I am trying to make an SSRS BAQ report but the report needs to be able to have optional parameters entered on the SSRS level not the BAQ level. So the question is how to make the SSRS parameters appear before the report fully runs? </span></p><p><span><br></span></p><p><span><br></span></p><p><span>Thanks,</span></p><p><span>Brandon</span></p><p></p>

</div>
 


<div style="color:#fff;min-height:0;"></div>

4
Thanks for the fast response. I looked into that but the issue is that these parameters are used to see a what if scenario for ex. if parameter 1 is shipping cost and that value  is $25.00 how will it compare to the current cost from that customer. So the overall idea for this is to have 13 different optional parameters that will ultimately show a new what if price for the customer. I just assumed there had to be a way to make the parameters on the crystal level appear to be entered. Hopefully this explanation will help.

Thanks,
5
Well in SSRS Per Say yes you can but the way that Epicor Invokes SSRS it calls the export function with PDF, CSV etc... so it won't show you the browser to prompt you for the Params. I guess you could Invoke the browser yourself via a customization... I can't recall if there is a way to tell Epicor to Bring Up the SSRS Report on the browser natively but I doubt it


Jose C Gomez
Software Engineer


T: 904.469.1524 mobile

Quis custodiet ipsos custodes?

On Thu, Jan 28, 2016 at 11:57 AM, bkithca88@... [vantage] <vantage@yahoogroups.com> wrote:

 
<div>
  
  
  <p>Thanks for the fast response. I looked into that but the issue is that these parameters are used to see a what if scenario for ex. if parameter 1 is shipping cost and that value  is $25.00 how will it compare to the current cost from that customer. So the overall idea for this is to have 13 different optional parameters that will ultimately show a new what if price for the customer. I just assumed there had to be a way to make the parameters on the crystal level appear to be entered. Hopefully this explanation will help.</p><div><br></div><div>Thanks,</div><p></p>

</div><span class="ygrps-yiv-1910068973">
 


<div style="color:#fff;min-height:0;"></div>