I'm having problems connecting to my SQL Server so I'm forced to work with my DB using dataset only. I need to make a report that if I could use a query would be something like this:
SELECT id, name
FROM tablePeople
WHERE tablePeople.bornIn= USA;
I wasn't able to use the crystal reports so I just drag a reportViewer to my form and then click on it's little arrow (on right-top corner) and there's an option to design a new report. that's how I made my simple reports where there were no "WHERE" involved I just picked all the colomns from table and it displays them. but I don't see any options to make it report a bit more complicated so it will show what I need as I showed in the query.
is there a way to make it work? maybe some other way? only keep in mind I can't use the SQL connection! :confused: