Search results for query: *

We are migrating our site from Informix to SQL/Server and I have a problem when calling my Crystal Report from ASP. The old code was... Dim webSource Set webSource = CreateObject("WebReportSource.WebReportSource") webSource.ReportSource = webBroker...

Hard coded values work fine. I have done some tracing on the SQL being passed to the database and we end up with... SELECT fields FROM tables WHERE custname LIKE 'value1,value2%' So it seems that the problem is that the 2 values are just being treated as one when entered via the URL...

We have a report that has a multi value text parameter, this allows the user to enter multiple strings and the report should produce a listing of all records where the customer name begins with any of the strings entered. We have created a record selection formula on the customer name field of...

Help!! I am new to ASP and am getting the message... Object Required: 'Server' from the line "Set cnn1 = Server.CreateObject("ADODB.Connection")" in my ASP page. All works fine without the "Server." prefix but I need to do the data access on the server rather than...

Thanks, a view might be a good way to do it but I cannot seem to use set location to point my report at the view as opposed to the query. If my report was based upon database tables I would get the dialogue allowing me to map each table onto a new location. As my report is based on a query I...

I have several reports based on Crystal Queries (.qry files) against an old Informix database. I now need to port these reports to a SQL/Server database and put a VB front end on them to allow them to be run by end users. I think that in order to do this I need to convert the reports to use...