Hi, all

I've a trouble when assigning complex dataset to a crystal report, anyone can help me out? I'm a bit hurry...

Following is what I did:
1. first I add a new view into SQL enterprise manager. This view is created from 8 tables. I can see the view is created successfully as it returns all rows correctly.

2. In my project, I used "add new item" to add a dataset. Then I drag and drop the view (in step 1) from "Server Explorer" into this dataset. As I read the XML schema, all fields are correct.

3. Still in the project, by using "add new item", I add a new crystal report. When I try to add the dataset into the report in "data" tab, it says: "no items found". Why?


The reason why I try to create crystal report in such way is because I want to use ".SetDataSource(ds)" method to bind data into the report at runtime. Am I using the correct method or is this the only way? I tried to create report from database and assigned a new dataset(same structure) to it at run time, but it just show all records out(I've a WHERE case in building dataset, it supposed to show only few records).

I know how to use report parameter, however I must not use any parameter in my project

Br,
Xuan

do u have add a new item(dataset) into your form

____________________________
bshaen