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...

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...

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...

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...

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...

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 hope somebody can help me. I have declared a BooleanVar shared variable in my subreport, which always displays the right True/False. However, when I then declare it in the main report, it does not seem to have any relevance to what is actually being tested to get the true or false. Sometimes...

Hi I have an ongoing problem with what I think may be due to the fact i have got the wrong end of the stick and would appreciate some clarification. I have two applications running from the same sql server database. We have had many problems with one of the apps where it was leaving the cursor...

I have had a report working in a VB app for ages. The customer wanted some modifications and all I did was to add a group in between the two I already had. Now the report will not display in the VB app at all. Nothing else has changed and it doesn't make any sense. Please can anyone help as...

I have a very strange problem. I have written a report and overwritten the sql query within the report. The report works fine, and is being used within a VB app. However, we are overwriting the parameter values within the report when we run it through the VB app, which also works fine, but it is...

I have a problem with a query I have designed for a report within SQL Designer. I need the report to be displayed within a VB app. but it seems that the sql query is not being overwritten (parameter wise) by the VB code. I don't want the 'Enter Parameter Values' dialog box to be displayed as the...

I have aproblem with a sql query I am using through Toad. The db id Oracle 8i and I need to find the number of licences that have startdates from and including the current date to and including 90 days ago. I have spent ages on this and it is obvious that I am missing something stupid. Here is...

I have a hugely urgent problem I have written about fifteen different reports, using version 8, which need to be viewed within from a VB program. I am having terrible trouble getting the reports to connect and show the parameter dialog box(the one which gives both discrete and multiple value...

I have a join probelm with one of my statements. The scenario is that each document has stock assigned to it and that stock may or may not have serial no.s assigned to it. I need to select the every model id which is on a document, along with the serial no.s assigned to the model id if there...

I have used version Crystal Reports 8 for my reports and using the Crystal Control for VB can now display the reports within my application. However, it seems to have reverted back to the way the Crystal version 7 asks the users for the parameter values. I have used the option of discrete and...

I have used version Crystal Reports 8 for my reports and using the Crystal Control for VB can now display the reports within my application. However, it seems to have reverted back to the way the Crystal version 7 asks the users for the parameter values. I have used the option of discrete and...

I am new to VB, but wish to call my reports from inside a VB program, rather than using the compiler (downloadable patch for CR8). I have absolutely no idea of how to do this, although I now it can be done. Is there anyone who can help me. I also do not particularly want to use the CR Web...

I am new to VB, but wish to call my Crystal reports from inside a VB program. I have absolutely no idea of how to do this, although I now it can be done. Is there anyone who can help me. Please tell me I have other options. I am using Crystal Reports Version 8 and VB 6.