Search results for query: *

Hi all Is there a function similar to DTS in MS SQL server in Oracle? I have a requirement to get data from a Sybase database into an Oracle database on a regular basis in order to be able to report on it using Crystal. Ideally I would like to have all the required data in a single database...

Hi all We used to use Crystal 6 (which requires that you print the reports onto dinosaur-leather parchment) to export our report to a text file automatically (via another program). Then this exported document is read into another application (app B). Now that we have upgraded to V9, we are...

Hi all As I understand it, the repository data is stored in a database. If you make a change to an item in the repository, every report that uses that repository item will be affected. Is this all correct? Then my next question is, what would happen if you created a report with a few...

Hi all I have posted an FAQ (faq149-4496) which details a method for preventing virtual pages in cross tabs. I hope some of you might find it useful. Cheers

Hi. I have posted this in the crystal formulas section too! Sorry to those that lurk in both sections. I would like to group by the day of the month such that EVERY day of the month is shown regardless of whether there is data for this day or not. Firstly, this report is run for a whole...

Hi. I would like to group by the day of the month such that EVERY day of the month is shown regardless of whether there is data for this day or not. Firstly, this report is run for a whole month only. (ie only Jan or only Feb etc) I have data reported for samples that are logged in on...

Hi I have a subreport sitting in a page footer section all on its own. In the subreport itself, the information is shown in the group footer. I am grouping on a field called Grade. Hence for each grade, there are results. If there are 5 grades, I get 5 lines of data. HOWEVER [Evil]...

Hi I have a report that is fairly straightforward - 2 subreports but nothing fancy. On the report, I have a few logos but none of them are huge in size. In fact, a word file with both logos is 97KB in size. But the Crystal file I have created is 5.8 MB in size! I did have the "Save...

Hi In version 8.5, turning off auto smart linking was easy (under file, options and look for the check box) but in version 9, this check box is gone. I work with databases with field names that are the same but which in fact don't contain the same data (ie auto linking is a pain in the butt...

Hi I have a peculiar error. On one pc that is brand new and has just had all its software loaded, when I type in a formula such as =IF(SUM(A1:A3) = 6, "Yes", "No"), I get an error message saying there is a problem with this formula. Cells A1 through A3 contain regular...

Hi all I have a requirement to query a table in an external Access database. I have created a connection to this external database as shown below (Data_source is the external database path): Set dbDoc = DBEngine.Workspaces(0).OpenDatabase(Data_Source) Now I need to query a table called...

Hi all I have a requirement to query a table in an external database. I have created a connection to this external database as shown below (Data_source is the external database path): Set dbDoc = DBEngine.Workspaces(0).OpenDatabase(Data_Source) Now I need to query a table called Field_master...

Hi When looking at the design view of a table in Access, there is a column called "Description". I was wondering if anyone knows where this data is stored if you wish to extract it with say a SQL statement in VBA. Thanks for the help.

Hi I have 2 issues. Firstly, I would like to prompt the user to choose the name of a table from a drop down list. What is the best way of doing this? Currently I simply prompt them for a name from an inputbox which I know is not great at all! I haven't used a form. Would I be able to use...

Hi I am trying to write a query in Access that will work for several different tables. The SQL code appears below: SELECT [x].Table, [x].Field_seq, [x].Field_name, [x].Field_type, [y].Field_type FROM x INNER JOIN y ON ([x].Field_name = [y].Field_name) AND ([x].Table = [y].Table) WHERE...

Is there a way of determining the number of days between 2 dates excluding the weekends? A lab receives samples. They have 2 working days to complete the sample. I wish to determine how long it has taken them to complete the work. Eg Select sample_number, date_recieved, date_completed...

Hi I have a problem with a csv file that I create. A new CSV file is created by an application and this file is opened by Excel (As would happen if you double clicked on the CSV file). What I would like is for a macro to execute at this point which will do some simple formatting such as...

Hi all I have a bizarre problem. The following code runs fine on most machines but on a few, it gives me a subscript out of range error at the line that is red. I added the following watch to see what value was coming through: "Worksheets("Tensile-Bend").HPageBreaks.Count&quot...

Hi again I have a problem with some code I wrote working fine on my and several other PCs but not working on a few other isolated PCs. I have had a look and the references are all the same on both the working and non working PCs. VBA, Excel 9.0 Object Library, OLE Automation and MS Office 9.0...

Hi all and apologies for the rapidfire queries. I have the following scenario. Sheet1 has data in columns per component and date Eg Cl F Mg 10/10/2002 6.7 9.4 6.1 10/10/2002 7.2 5.76 11/10/2002 3.21 9.3 6.13 etc I have a subroutine that selects all...