Search results for query: *

I have saved an SSIS Package using the File System option as C:\Packages\MyPackage.dtsx. I can run this package succesfully from the XP Command Prompt by typing:- dtexec /De mypassword /F C:\Packages\MyPackage.dtsx I then tried creating a stored procedure (using Microsoft SQL Server...

I use Crystal Version 10 to create reports for my application developed in VB under Visual studio 6.0 I have amended a report to carry a logo contained in an OLE Object Bitmap which is always linked to the same file (ReportLogo.bmp) in the same folder. I have ticked the Link option when setting...

Hi, I am using CR8.0 with SQL2005 and am writing a report which uses a Transaction Header table which includes multiple records for a single transaction (there is one record for each payment method used on the transaction). The Transaction Header Table is joined to the Transaction Detail table...

Hi, I am using Crystal 8 and have a Main Report which has a formula which is used for record selection in this Main Report. The value of this Formula is updated by my calling VB application so I can choose what record selction I require. I have now added a SubReport to the Main Report which...

I am now using the version of Crystal Reports that is bundled with Visual Studio 2005. In previous versions of Crystal I have been able to export my reports to a CSV file by clicking the export button on the report. In the Reports done with the bundled Crystal I do not have CSV as an export...

I am using Crystal 10 from within Microsoft Visual Studio. I have a Crystal Report which uses data from an XSD table. I have amended this XSD table to add 3 new fields from within Visual Studio. However, when I open my Crystal Report (again from within Visual Studio) and click Verify Database...

Hi, I am using Crystal Reports V10 against an SQL database. I have very simple report which calculates a percentage in a formula at a Group Footer 1 as follows:- MyPerc = 100 * SUM({Sales.TotalA}, {Staff.Name}) / SUM({Sales.TotalB}, {Staff.Name}) Where Group #1 is Grouped on...

Hi, I posted this in the Crystal Integration Forum yesterday but got no replies - so I am hoping that some kind person may see it here instead! Here goes:- I am fairly new to Crystal and am trying to covert our VB 6.0 Application to load Crystal Reports from .Rpt files instead of Crystal...

Hi, I am fairly new to Crystal and am trying to covert our VB 6.0 Application to load Crystal Reports from .Rpt files instead of Crystal Designer (DSR/DSX) Files. We use Crystal 8.0 I have cobbled together the following code which works on the first run of the report. However, if I try to run...

I have a VB6.0 application which runs some Crystal 8.0 Reports. I have setup a Formula in my Crystal Report called DateRange. In my VB code I am trying to now setup this formula as a String Variable (DateRangeVar) which I have already setup. Here is the line of code I am using:-...

Hi, I am fairly new to Crystal and am trying to covert our VB 6.0 Application to load Crystal Reports from .Rpt files instead of Crystal Designer (DSR/DSX) Files. We use Crystal 8.0 I have cobbled together the following code which works on the first run of the report. However, if I try to run...

I am using Crystal 8 I have manually added an unlinked SubReport to all the existing Crystal Reports in our application. Unfortunately now we have compiled the new version of our application we have found that the size of the new .EXE has grown unacceptably! This is obviously due to all the...

I am using Crystal V8.0 connecting to SQL Server Tables. I am amending an existing Report that already uses various linked tables (all set up in the Visual Linking Expert). I now need to extract data from a new table that does not in any way link to the existing tables. The new table will only...

Hi, I am using Crystal V8.0 connecting SQL Server Tables. I need to make a mod to an existing report which currently only uses one table. I decided to add a new table to the report and join the tables using an Equal Join using the Crystal Visual Linking Expert. I then put a new formula on the...

I have loaded a Visual Basic 6.0 Project on my PC which is running Crystal Reports 8.0. The Project is linked to an SQL database. When I compile the VB project a Datalink Properties Box appears prompting me for the Username / Password to my database. The box keeps appearing for every Crystal...