Crystal Reports 9 reporting off Active Directory

[erinallen]

How can I pass a parameter value to a Command Object going against Active Directory without prompting the user for it? I have a main report that passes a user id to the subreport that goes against Active Directory to find the user's name and location, but my list of users is over 1000 records so I'm not always getting a match.


Thanks

 

[synapsevampire]

A parameter is intended to be a prompted value.

Are you asking how to take a parameter from th main report and pass it to a subreport?

I just posted on this topic, link the subreport field to the main report parm.

Your post isn't clear to me, try posting example data and expected output.

-k

 

[erinallen]

Thanks for responding. With the help of Crystal Support I was able to figure out a way to get what I wanted.

I wanted to pass a SQL parameter value to my subreport without having the user prompted for it. To accomplish this:

1. I created the SQL parameter in the subreport
2. I change the report link between the main report and subreport so that the main report data field fed the SQL parameter (not the typically created PM-... parameter created when you do a report link.)

Voila! I get to use a SQL parameter so I'm only returning rows I wanted from my Active Directory LDAP query and my users don't get prompted.

 

[poujor]

Hi erinallen.

Have figured out how to get more than 100 records from Active Directory?