Search results for query: *

Your code looks fine to me. I would suggest that you run the sp from query analyzer to see what your return is. Verify that the problem isn't with the stored procedure before looking at Crystal. You could accomplish the same thing by accessing the table directly and using record silection...

Do you want to query in SQL or in Crystal? SQL: SELECT [columns] FROM myTable WHERE description LIKE '%LJ32%' Crystal: (Record Selection Criteria) description LIKE "*LJ32*" What you're asking is really basic stuff. Try looking up parameter in help before bringing it to a forum. BCrowe BCrowe

My final objective is to be able to print 2 copies of an invoice document from different paper sources (different paper colors for dealer/customer copies). To this end I wrote some VB.Net code that would use the PrintToPrinter function and just change the papersource value between calls...

In case anyone cares, I figured out what the problem was. GridColumnStyles are not created when a datatable is set as the datasource but are when a dataview is. So all that was necessary was a single line of code to assign the datatable to a dataview and use the dataview as the datasource for...

Create an array of month lengths {31,28,31,30,...,30,31} Calculate the month (thismonthplus6 = (thismonth+ 6) mod 12) thismonthplus6 = (10 + 6) mod 12 = 4 the array index = nowplus6 - 1 = 3 hope this helps BCrowe

A little clarification on my post. As I step to the line: .GridColumnStyles(0).Width = 0 I get an out of range error because there are no gridcolumnstyles defined. Shouldn't they be created automatically on assigning the datasource?

I am using a datareader to populate a table to fill a datagrid but when I attempt to modify the datagridcolumnstyles for my datagrid I find that there are none. Below are some pertinent code snips...maybe someone can point out where I am screwing up. The data is all there and if I don't try...