SQL String

SQL String

• nper

  thanks...

  already know these resource, but nothing about my question.

  I would pass a sql string to a report to select the records.

  In earlier version of CR (8) was possibile use SQLString property, but in lastest release this property not exits.

  
  

• SergeyPV

  Keith,

  thank you for reply

  My opinion is that RecordFormula is not good idea for thousand records, but for few records. When RecordFormula is used, the records are ALL get from DB and then filtered by Report, you can image out which results is!

  I'm attemping to use StoredProcedure as DataSource of Report, but the problem is that if i have to change the WHERE condition I must create another SP, because CR not recognize dynamic SQL string concatenation, of course! Anyway this later solution seems resolve, in part, this my litlle question. Anyway, i'm looking for other solution.

  Any suggestion is welcome!

  
  

• JSMARTIN

  If you are wanting to create a dataset, I would look at the sample applications you can download from Businessobjects website

  http://support.businessobjects.com/communityCS/FilesAndUpdates/sample_applications_for_.NET_developers.pdf

  you want either the C# or VB samples for crystal reports, last section in the pdf, save the exe and run it, it will creata a directory with many sample applications.

  The sample name you are looking for is vbnet_win_adodotnet.zip

  
  

• kevinwind

  Hello,

  Yes this property was removed in more recent versions of our SDK. I think that the previous poster was suggesting that you could accomplish the same thing by using dataset.

  If that's not an option then you can look at using the RecordSelection formula. While this is not SQL you can still filter records by using the Crystal or Basic syntax.

  Keith - Business Objects

  
  
  
• SQL String