I'm unexperienced at using Crystal reports and I'm already stuck. I know how to put a report on my asp.net page and pull in straight data from my sql server, but I need to filter that data by using a session variable. Can someone help me here? I'm totally lost. I'm pulling these columns and need to filter with OwnerID.

OwnerID
FirstName
LastName
Phone

Thanks,
DW

there are two ways you could aceive this.

Firstly create the report with a parameter and then use the reportdocument class to get into the paraeters collection and populate this (which is not a simple as it sounds)

For one field this may be over kill.

I would personally look at the selection forumla within crystal and set the owner id as an example, copy this string and place it within your code.

Use the reportdocument class to get the selectionformula string, you can then replace this string with a custom built one based on your field and the session variable value.

HTH