setting crystal report using sqldatasource in visual studio 2008

It’s been several days I looking for connecting crystal report express for visual studio 2008 using sqldatasource, so i can edit the sql query using code behind on runtime. All I found on the net are using dataset or xsd, so more coding required 🙂
But finally I found it in microsoft site, with a few simple steps:
– Create crystal report file.
– Connect to database and add fields on the report, customize it as you like.
Continue reading


just find out today, another limitation of the visual studio 2008
beside it somehow not 100% compatible with early days oracle query (I use oracle 8.1.7 database with 2.0/vs2008, ans some queries just cannot work without “simplifying” it).

anyway, back to the tittle, it seems that every time i make it over 127 columns when i save it, the visual studio crashed (actually i can save it at 127 columns, but when i add 13 more bound fields, it crashed). the strange thing is that it is ok if you use automatic generating field option, but not ok if you manually add the field yourself…

but don’t worry there is a work around to that, but this is with a consequence,
Continue reading