Parameter List 1

[OT2]

Hello, hopefully you will be able to help me with the following.

I have report with three parameters: Start Date, End Date and Identifier. The identifier parameter allows multiple values so what I would like to do is include a list at the end of my report that shows all the indentifier I used in my parameter. Is there a quick way to get this done without using SubReports? Thank you, OT2

 

[OT2]

What can I plug in instead of the HZ and LEX? If I dont know the name of the Securities that I will be pulling into my report. All I have is the sec id. What can I replace those values with?

 

[jraheja]

As lbass said this will work if you have a small list. If you have a bigger list, maybe sub report is a better option. Sorry, I haven't tried that way. Typically I pick what has been selected in the parameter and put is as is. I have a shorter list...

 

[OT2]

Jraheja, I went with the sub-report. Turns out I had to incorporate two subreports, one to show me all the sec's in the parameter and another to show me all the securities were active. I had to do this becaue if not the securities that were not traded would drop from my sub report,(linking issues). Do you know of any way I can make one report out of these subreports? Or is there a way I can change the links in the subreport to left outer or inner?

 

[jraheja]

Sorry, I haven't done subreports at all. Maybe someone else can help.

 

[lbass]

In the subreport, you could use a left from the table containing all secIDs to the table containing only some of them, but you cannot place record selection criteria on fields from the second table or it will undermine the join. If you want to show only those which are active from the second table, then use a suppression formula.

-LB

 

[OT2]

Hi lbass, where do I go to select my joins on subreports?

 

[lbass]

You design a subreport pretty much the same way as a main report. Go to database->visual linking expert and click on the link->options->left join.

-LB