Search results for query: *

We have a report which we have stripped out the location of the view and just left in there the view name and the name of the dsn (a Sql Server 2000 dsn)(for migration purposes). Opening the report in all locations with the right named dsn works only as long as the server has NT authentication...

We have a report which we have stripped out the location of the view and just left in there the view name and the name of the dsn (a Sql Server 2000 dsn)(for migration purposes). Opening the report in all locations with the right named dsn works only as long as the server has NT authentication...

If anyone is interested, we have bypassed the error completely, by creating a view with the complex sql statement and doing the report from that instead. This has also cut down by loads the processing time of the report.

Thanks welshone, will try that

We have a problem with a report. It is based on a SQL Designed query and gets its parameters from a temporary table within the database. The vb code we are using within the app CrystalReport1.Connect = "korg" 'conn.ConnectionString CrystalReport1.ReportFileName = App.Path...

We are getting the same problem. We are running an SQL based report through VB which gets its parameter from a temporary table. Before, its parameter was in crystal and the report was not intergrated within the VB app. Since we have changed it, we now get this error. We are using SQL Server...

From what everyone has said, would I be right in thinking that if I used a stored procedure or a view as the datasource for a report and built in the parameters for the report within the VB source code rather than Cyrstal this would make increase the speed of performance?

What would you suggest then? I need to learn more about database connectivity, stored procedures, integration with vb etc. The only trouble is I am in the UK, and there seems to be nothing going on here at all.

Hi I have a report which runs nicely in vb, but have recently been asked to change the subreport within it, so as to only display distinct values within the subreport. Having done this from the menu option in crystal I get everything displayed as it should be if I view the report in Crystal...

Hi, I have a rather strange problem. I have a report which has a subreport in it. This report works fine, and has been integrated into a vb app successfully. However, I have changed the subreport so as it is selecting distinct. Within CR this works fine and the report has been saved, the vb...

Thanks, HowardHammerman and Ngolem, both solutions work brilliantly, although I have gone with the page footer solution.

I have a problem with a report I am doing where I may have 1 or many lines in the detail section which hold values. I then want sums of these values to appear in the group footer section. My problem is that as I am printing on pre-printed forms, the group footer section must start 21.5 cms down...

That sound's great, but unfortuanately I am using ODBC, to SQL Server 2000, which means there isn't any log on info to strip out the server name. I am also using a database which has a completely different name to the one at the client site, anybody got any ideas, or is that impossible? Thanks...

Hi, I was wondering if it is at all possible to set the location of a report within VB code, so as ignoring development location. Obviously I know how to reset location(s)within CR, but does everybody when implementing finished apps have to go in and reset the reports location within CR, is...

Thanks, Ngolem and Ido. My only problem with SQL Designed reports before was that we have never manged to overwrite a parameter within VB. However, my problem with this query is that because the value I wish the parameter to be based on (DocID) is in the subquery, the field does not come...

Jim, thanks for that. I understand now what I need to do, apart from two quick questions. I could have up to 100,000 values of serid for this sub select of docid. Is that going to be a problem? The other question is about the syntax of the shared string array SERID. How do I set a string...

Thanks Ngolem, I thought that was what IdoMillet meant, but I still have (as far as I know) the problem of putting extra where clauses (ie Docid = 95561) when I use the an SQL Designer based query and then make the report in CR8 and try and open the report from within VB. You see the trouble...

Thanks, IdoMillet. However, as the docID in the sub-select statement needs to be chosen at run-time by the user, then using a view won't work. Also, as far as I understand it, it is impossible to overwrite any of the clauses in a SQL Designer report from VB, or if it is I haven't had any luck...

I have a problem which I have no idea whatsoever about solving. I have been given an SQL statement which I need to implement in CR8. The statement is pretty simple apart from the last where clause which I have absolutely no idea how to implement. I have thought of shared variables, sub reports...

I have the same problem, but can't put all fields in a single text field as I am doing v. complicated mailing label, with loads of conditional suppression. If I move the fields, then the report won't work properly. I would really appreciate any ideas whatsover. I need them in csv format as they...