is the sql edittable?

[subrama6]

I have a VS.NET solution, and I've added a report to it. I went through the report wizard, and it's mostly what i want, but I need a little more granularity than the wizard provides. For example, I need to concatenate my select statement, ie "SELECT a||b||c FROM..." I just want to tweak the SQL, and I can't figure out how to do that in VS.NET. In standalone Crystal, I believe I would right click on my data source and go to "Verify Database", but all that gives me is a popup saying that the database is up to date. Is it possible to do what I'm trying to?

Thanks in advance

 

[synapsevampire]

That's not the method in standard Crystal, it does the same thing, there'd be a choice for Set Datasource Location in standard Crystal.

How you created the data source is key, which you didn't share. Stating that you used the Wizard states little more than that you used data.

Here's the sample apps:

http://support.businessobjects.com/fix/samplescr.asp

-k

 

[subrama6]

First of all, thanks very much for the quick response. I will certainly check out the link you provided. All I did with respect to the datasource was to specify the relevant oracle tables (and fields) while going through the report wizard. I didn't actually add a datasource item. I'm actually rather new to crystal in vs.net, and wasn't aware of any other way to add a datasource. I'm currently trying to add an ado.net datasource as per this article on tek-tips:

http://www.tek-tips.com/faqs.cfm?fid=3940

 

[synapsevampire]

Specifying Oracle tables is the means for adding the datasource, and I'll assume that you used Oracle Server as opposed to ODBC.

I don't work with vs.net, however your article seems worth exploring.

-k

 

[subrama6]

you are correct, i did not use odbc. vs.net only provides for adding the data source in the wizard under ms ole or odbc, and oracle is only available under ms ole. i am currently going over the ado.net datasource example from the link you provided. thanks again