Crystal report selection and viewing

[MJB]

Now I have code like this:

Dim sSelection As String
sSelection = " {Planning.Week} = 44"
WeekReport1.SelectionFormula = sSelection
WeekReport1.PrintReport

I'm new to Crystal reports, so I've got 4 (i hope simple) questions:

1. How can I make a selection like Planning.Week between 44 AND 48 or something like that? Can I use SQL for this?
2. How can I maximize the report that is being showed by PrintReport?
3. How can I show a selected report in the crystal report viewer?
4. How can I use a query as a source for a crystal report, and then use parameters passed from VB to this report?

[oh1mie]

To the first question try this:

sSelection = "{Planning.Week}>43 AND {Planning.Week}<49"

[MJB]

Thnx, that works oke indeed . Thnx 4 your reaction. Also someone 4 the other questions?

[pnish]

Assuming you're using the Crystal ocx:

2. WeekReport1.WindowState = crptMaximized

3. I'm not sure what you mean??
4. I think you have to use ODBC to be able to use Access parameter queries in a report. I've never done it so I'm not sure.