Search results for query: *

I have a VB6 application that uses CR9 API/RDC to allow users to create Ad-Hoc reports. I am running into a problem when the number of columns or the last column in the report exceeds the width of the print page. Using the CR9 API/RDC is there a method or parameter I can use which would instruct...

vidru, Thanks again for all your help, you are the best.

vidru, Thanks for your reply it worked fine. I do seem to have another formatting problem regarding displaying dates. The date is displaying as "9/6/2001" I need to format it as "09/06/2001". Any Ideas? agersh

Using VB6 and Crystal Reports 9 the users have the ability to create ad-hoc reports. My problem is that when a date field is selected/in the report, the field is displayed in the report with the date plus a time. I only want to show the date portion only. Using crystals Field Object properties...

vidru, Yes, After reviewing the .pdf I have changed my code to the following. Thank you for your help. '* Set DB Connection to SQL Server (OLE DB at Runtime ' Declare a Connection Info Object Dim ConnectionInfo As CRAXDRT.ConnectionProperties ' Set the Connection Info to Connection...

Development Environment: WinXP, Visual Basic 6, Crystal Reports 9, SQL Server 2000 Using the following VB code I am opening a Crystal Reports .RPT report. Which I then set the required connection properties for the report. As you can see the code/report currently uses a File DSN. I would like...

Visual Basic 6 and Crystal Reports 9. Using the Report Designer Component Database Object I am trying to dynamically connect to a MS SQL Server 2000 database. From the technical reference documentation I was able to find the required Connection Properties except for the property that is needed...

I am developing a Visual Basic 6.0 application that will use Crystal Reports 9.0 components for it’s reporting mechanism. Via VB/Crystal Reports the user we be able to export a report to PDF format. Using visual basic code is it possible to set/changed the security for the created PDF document...

I would like to use the Report object Export method to provide a simple mechanism for exporting reports. My only problem is that I would like to initialize the “Choose/Save export file” dialog box to a specific directory before it is displayed. Somewhat like setting the visual basic...

Sorry synapsevampire, I should have mentioned that I am creating this report via VB6 code and the CR9 Report Object. Mouse click to not help me since the formula field alignment and formatting is being performed by the VB code.

I have the following Formula Field in the detail section of a report… If IsNull({ado.AMOUNT}) = False Then Formula = {ado.amount} Else Formula = 0.00 End if The Horizontal Alignment for the field is set to “Right”. For some reason when ado.AMOUNT is Null the zero value of the formula is...

WindowsXP Pro, VB 6, MSSQL Server 2000, Crystal Reports 9 I have a report, which includes a subreport. I receive the following error when I use the LogOnServer method to log the main and subreport into my MS SQL2000 database. Any ideas why am I getting this error? Error -2147189176 – Logon...