I am basically using a wizard to generate report and pretty much of VS2k10's "built in" Designer so looks like this is the appropriate branch to post the report.
I am trying to pick just the first name from the Northwind DB field and looks like split can do so. Well I am trying to use this in the expression editor :
Evidently, and that gives me "System.String" but if I try expression as below :
I get this message : An error has occurred while processing Report 'DemoReport2': Missing operator before '' operand.
Just to make my self clear I tried this and that works, may be I am missing something ?
System.String s =
Please comment ...
This is the query I am using:
Customers.CustomerID = Orders.CustomerID