Search results for query: *

My operating system is Windows XP Professional. I am trying to alter the font color and/or background color of a textbox object within a C++ desktop application. The problem is that when a textbox object is disabled, the font is dark grey on a lighter grey background and the text appears...

Thanks Reebo for your quick response. Matt

I have a 2 page report, but I want dynamic page headings. So on page 1 to have a heading called 'Initial' and on page 2 for this heading to be called 'Subsequent'. Is there a function I can use to identify the Page number? Thanks in advance for any help.

Hi I am currently programming a VB6 application with sql server 2000 backend. I am looking to integrate a Microsoft Word 2000 User manual/help guide to the application, so that when a user clicks on a Help button on, say, the Invoice form, the user guide opens at the corresponding Invoice...

I want to display a custom error message in Crystal(using a dialog box), so in the stored procedure I have been using: RAISERROR (@VErr, 16, 1) WITH NOWAIT where @VErr is the error message. However instead of displaying this, Crystal is showing the annoying 'Error Detected by Database DLL'...

Hi I am using SQL Server 2000/ Crystal Reports 8. I have a stored procedure with 3 select statements returning 3 recordsets of data. Is it possible to display all 3 in a Crystal report without having to split into 3 stored procedures/3 subreports? Also, I dont want to use a union statement...

Thanks for your help James. Using Enterprise Manager to change the data type does work successfully, however this change needs to be performed on a variety of SQL servers, of which I dont have access to. So, I would prefer to code the change into a script that is then run on all of the servers...

I am trying to alter a table column of datatype Money to datatype varchar. The problem is that the table is populated with records so when I attempt to alter it, I get the 'Disallowed implicit conversion from data type varchar to data type money..' message. I know I should be using the convert...

I have borrowed code from other threads concerning this issue. However there seems to be a problem when specifying SQL Server login authentication in that the Data source is not created. Does anyone know a way around this, without removing the Login ID and Password? Here is my code: Module...

Thank you very much SwampBoogie for your help. Regards Matt

I have the following records within a single table, Orders: OrderNo Version Value 1 0 10.00 1 1 12.00 1 2 13.00 2 0 9.00 3 0 10.00 4 0 12.00 4 1...

Thanks Marc, thats sounds ideal. Only one small problem...do you know the VB syntax for SetReportVariableValue as I can't find much documentation for it?

Thanks Marc, thats sounds ideal. Only one small problem...do you know the VB syntax for SetReportVariableValue as I can't find much documentation on it?

Thanks for your suggestions Marc, however I am already using the parameter array in VB....CrxRpt.Param(n) to pass the parameters. Currently the report refers to a SQL Stored procedure that accepts 4 parameters(including the extra parameter @prmSource). These 4 parameters can subsequently be...

I want the parameter to be passed though. The parameter is passed from VB to indicate that the report has been run from the VB application. I would change the asp file so that the same parameter is passed(to indicate that the report has been run from the web), but I dont have control over the...

I didn't mention this before, but this issue will affect all of our company reports so I would prefer not to duplicate all the reports for this one issue.

I have a report that can be run from VB or the Web(ASP). The problem is that less parameters are passed via the Web method. Therefore when running via the web, Crystal displays the Enter Parameter Values dialog box for that parameter. Is there any way of automatically setting the Parameter...

From a stored procedure, I am looking at the best way of determining whether another database exists on that same server. e.g. Say I'm executing a stored proc in the EngDatabase, and want to discover if a GerDatabase exists I want something like: if exists(GerDatabase) begin ... else ... I...

I am passing a parameter(varchar) into a stored procedure that contains several values, and I was wondering whether SQL Server allows you to split the parameter/variable into the separate values. eg. say "Red, Blue, Green, Yellow" is passed as one parameter, I would like to break this...

Hi, I'm hoping that somebody can help me here. Basically, I'm passing the parameter @db_desc into a stored procedure. @db_desc is the name of a SQL Server database residing on the same SQL Server. I want to use this parameter to identify the database in a select statement, like so: select *...