Search results for query: *

Hi Is there anyway to change the label.caption description for all labels on a form based on a key press for example the ALT key. So if the ALT key is pressed all of the label captions change and if you let go it reverts to normal. Ive used the function keys as short cuts to load forms before...

Is the following possible I have a cross tab that shows a register for a class Date 1 Date 2 Date 3 Name register register register mark mark mark Name register register register mark mark mark I then have a...

Ive been reading about creating LDAP accounts automatically using batch files. However we have a need to automatically trigger the creation of a LDAP account into Active Directory when a record is inserted into a sql table. Is it possible to do this is one action? , rather than creating a...

Hi We have replication setup on our sql servers and I want to setup an alert that queries the database on both servers and tells me if the databases are out of sync by checking the number of records on a certain table. how do i go about setting up the alert. We are using SQL 2000 sp4 ta

Hi We have an instance for one of users where they are running a Crystal Reports from a business view and although the report runs it returns a blank report. We are using Crystal Reports XI Release 2 BO XI Release 2 linking via ODBC to a SQL 2000 database. where Crystal XI is installed on a...

Hi Am new here, and have a problem We have a app which is a online Course Viewer, one feature is that it should biew documents held against the Course database. For instance one field in the course database holds the path to a document (this could be anything from doc to pdf) Is there a...

Hi Have managed to get a report to view using the rdc for reports based solely on a odbc connection. But when trying to do the same for a report based on a business view I get the invalid tlv record error. Has anybody managed to get the crystal viewer to work from a report based on a business...

Hi We have an application that integrates the Crystal View and report design components, however am getting problems when trying to use this with licence key codes. I think I need the RCAPI licence key code. How do i get this ?

Hi Is there a function that checks the fields type. I basically want to do a conversion but depending on the database backend the field is either a string or a date. I want to check the field type so i can then perform the correct conversion. However i cant find a function to do this . Does...

I have the following code which allows you to view a crystal report from VFP however when it hits the Openreport command I get the following error message. OLE IDispatch exception code 0 from Crystal Reports ActiveX Designer : Invalid TLV record I've made sure that the correct dll and merge...

Hi We've been running the crystal viewer from a VFP 8 app quite happily using Crystal Reports v8.5 dll runtime files in order to call the viewer when needed. Does anyone know which dll files are needed in order to utilise the same feature using Crystal Reports XI the files used for Cr85 were...

Hi Have just installed BOXI release 2 with service pack 1 and am getting following problems. Any ideas ? After installation i am unable to logon to the Infoview or administration parts of the web portal using the default administrator passwords. I can however logon to the repository/...

Hi Am getting the following error message when running this stored procedure : Server: Msg 156, Level 15, State 1, Line 1 [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'from'. see code below. Any ideas would be great thanks CREATE procedure...

Hi I have developed a business view and a few cascading prompts for our users to report off. However I have some problems when trying to create paraters using the business view. When create a parameter (static or dynamic) using the business view it wont populate the value field drop down...

Hi Have a report which ive published to Business Objects. The report runs fine when in Crystal however gets the above message when run it in infoview. Have checked the ODBC and all seems ok, any ideas. thanks

Is there a way to do this in Crystal Reports, where you want page 1 to be landscape and page 2 to be portrait

I Am using Crystal 8.5 and VFP8 Am currently trying to pass a load of free tables into a Crystal Report. However am getting an ODBC error saying column does not exist. Yet when running the report in crystal the report runs fine. I am using the following code to setup the free tables...

Hope someone can help with this I have a report which is grouped by a students learner no. and then showing various details about the enrolments for that learner. However I only want to show all learner details if a) the funding field is set to code 70 (it is possible that a learner will be...

Is it possible to control what field you set a parameter for. i.e I have a report that needs to run either by grouping by Venue or Venue Group Area now i can set up parameter which controls the input for a formula and use the formula to set up the groups i.e. if {?sort choice} = 'Venue' then...

Is there a way i can sum the value of a formula for a group. I need to sum a formula which is working out the Date Difference in weeks. So ive created a formula which collects the minimum and maximum dates and then used the DateDiff function to work out the number of weeks between the dates...