Datatypes supported by VS 2003 crystal reports

Datatypes supported by VS 2003 crystal reports

• susanowo

  I reffered to the sample and used the following code as suggested: crReportDocument.SetDataSource(ds.Tables[0]); DatabaseFieldDefinition crDatabaseFieldDefinition; crDatabaseFieldDefinition = crReportDocument.Database.Tables[0].Fields["Title"]; SortField crSortField = crReportDocument.DataDefinition.SortFields [0]; crSortField.Field = crDatabaseFieldDefinition; It still gives me an Invalid Sort Number error at line 4 of the above code snippet i.e at SortField crSortField = crReportDocument.DataDefinition.SortFields [0];. Could you pls help in this regard. "Title" here is the name of a field in the table. It does not work even if I give an index.

  
  

• SamSmithnz

  Have you tried using ODBC Do you know if the Microsoft OLE DB provider supports CLOB
  
  For sorting samples, take a look at the C# ones available here:
  
  http://support.businessobjects.com/communityCS/FilesAndUpdates/csharp_win_samples.exe.asp
  
  There is a csharp_win_sortfields.zip sample in that package.
  
  Keith - Business Objects
  
  

• Wollmatt

  Could you please send me sample code to add new sort fields to a sortfields collection and modify any sort fields I have specified at design time. Thanks Poonam

  
  

• RayHzz

  Hello Poonam,
  
  You will need to add the sort fields at design time as I mentioned in the previous post.  Once you do then the code you have will allow you to change the sort field at runtime.
  
  If you are sorting on multiple fields you will need to have more than one sort field defined at design time. 
  
  Keith - Business Objects

  
  
  

• stxrxgl

  Is there anyway to remove a sortorder in runtime
  
  I'm having a dynamic list of sort options, sometimes there is only one sort column, other times there are 2 or 3. The default is usually 1 column, how should I solve this Because you have to add sortfields at designtime, I've got 2 extra fields that is not always used, but they are still used by the reportviewer.
  
  An example:
  
  The user can choose from a Combobox with columns to sort by:
  

  • Country
  • Country + Name
  • Name + Country + City

  
  This means that I have to add 3 sortfields in designtime, because I must be able to support the "Name + Country + City" selection from my user. On the other hand, if the user only chooses the "Country" sortfield, the two extra sortfields added in designtime will also be present...
  
  How should I resolve this
  
  Is there some kind of dummy variable available, something like this(it can't be null):
  rptReport.DataDefinition.SortFields[number].Field = EmptySortFieldDummy;
  
  
  
  

• Ponnaravi

  The code that you are using looks fine.  I believe that you are getting the error because you have not predefined a sort in your report.
  
  In the report designer, right click on the report surface to get the context menu and from here choose Report|Record Sort Expert.
  
  Once you have added in the sort fields you will be able to define them at runtime.
  
  Keith - Business Objects

  
  
  

• DSouto

  I am connecting to Oracle using the Microsoft OLE DB provider. When I bind a stored procedure to my report that returns CLOB data I get the following error: Datatype not supported. There is another issue I need a clarification on: In my report I want to sort the data on multiple fields. The sort fields are picked up at runtime. How do I achieve sort on multiple fields through C# .NET code. I tried the following piece of code: FieldDefinition FieldDef ; FieldDef = crReportDocument.Database.Tables[0].Fields[0]; crReportDocument.DataDefinition.SortFields[0].Field = FieldDef; This code gives me the following error: "Invalid Sort Number". And also probably does a sorting on only one field. Please give a solution. We have to deliver this in the next two days. Thanks for your reply.

  
  

• DarrelCusey

  Hello,
  
  We do support CLOB data-type when going through ODBC.  Is this an Oracle database Do you know which ODBC driver you are using
  
  Is there an error that you are getting
  
  Keith - Business Objects
  
  

• Peter Villadsen

  I am using crystal reports version (9.1.5000.0) that comes along with VS 2003. That sample application was not much of help. Does it mean that we cannot do a sort on multiple columns in crystal reports .NET Please give me some code that does the sorting.

  
  

• abhi243

  Hello,
  
  Did the sample application work for you Which version of Crystal Reports are you using
  
  It looks like this was an issue for Crystal Reports XI and is fixed:
  
  http://support.businessobjects.com/library/kbase/articles/c2017069.asp
  
  
  Keith - Business Objects
  
  
• Datatypes supported by VS 2003 crystal reports