angrycoder
Aug 23rd, 2004, 04:06 AM
First off, i'm a crystal reports noob.
I'm using crystal reports that came with VS .NET 2003, and as far as I can tell, there's no way to edit a sql command during runtime. I use the "Add Command" to make my sql statement, but is there any way to add a parameter? so I can do something like: SELECT * FROM Invoices WHERE docID = 147. But have a parameter for the 147 part. I googled a few places and can try using an ADO .NET DataSet as the reportSource, but then as I understand, you have to have a file DataSet (.xsd) with the same exact structure that you would pull from a database via a SQL command? And that doesn't help since I may or may not need to pull data from 1 or 2 tables.
crystal reports (at least this version) seems to really be lacking in basic SQL selection, or am I missing a lot?
I'm using crystal reports that came with VS .NET 2003, and as far as I can tell, there's no way to edit a sql command during runtime. I use the "Add Command" to make my sql statement, but is there any way to add a parameter? so I can do something like: SELECT * FROM Invoices WHERE docID = 147. But have a parameter for the 147 part. I googled a few places and can try using an ADO .NET DataSet as the reportSource, but then as I understand, you have to have a file DataSet (.xsd) with the same exact structure that you would pull from a database via a SQL command? And that doesn't help since I may or may not need to pull data from 1 or 2 tables.
crystal reports (at least this version) seems to really be lacking in basic SQL selection, or am I missing a lot?