Search results for query: *

Thanks for the reply Alex. I come from a FoxPro background so am a novice when it comes to SQL. If I use your suggested approach am I still saving the Pacakge as a file or SQL Server package? Also can you give me a brief overview of how to use Sp_start_job to run the package - many thanks.

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

Thanks IBass - I had forgotten all about SubReport Links for some reason! I have now got it working by using the links - thanks very much - you're a star.

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 solved this for myself by completely removing the dataset and adding it back again with the new fields.

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

Sorry lbass - @FromDate = DATE(2004, 01, 01) andd @ToDate = DATE(2004, 06, 30) as hardcoded in the Crystal Reports Formulae section. The Calling Program requests these dates and passes them into the report. In the Crystal Reports Record Selection I have the following formula:- {MyTable.Date} in...

Basically my calling program requests the Start Date and End Date for the report and sets the formulas @FromDate (the Start Date) and @ToDate (the End Date) in the Crystal Report for use in the Record Selection criteria. I.e both @Fromate and @ToDate are dates.

Thanks lBass - I tried something like this the other day. Unfortunately I am using Formulae for FromDate and ToDate in the Record Selection formula of the Report. This allows me to run the report for a selected date range. How would I quote the formlae for FromDate and ToDate in the Command...

Any more ideas on my problem guys ?

I am already trying to use the Group Sort Expert. My problem is that my percentage calculation is placed directly in the Group Footer (it is not a Summary of any kind) hence it is not available as a Sort option in the Group Sort Expert.

Thanks for your reply - If I try to create a Group # 2 then my formula @MyPerc is not available for selection as this group??

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

Thanks Zemp - I'll give that a try soon. Although at the momemt my PC has died - got the Engineer on call!

Thanks for your reply ! When you say create a new instance of FrmReport how would I do this with my above code? Sorry if this is a silly question but I am still a novice with VB.

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