Search results for query: *

I'm using CR2008 SP1 and I have a line chart with 4 summarised data values and a on change of value that should be a decimal along the X Axis. My problem is that the X Axis is only showing whole numbers (the database is decimal(5,2)) and the decimals display as raw data outside the chart ok...

I have a very strange bug in my Crystal Server 2008. When scheduling reports in infoview, the report will only run in the default format (Excel, PDF, Crystal Rep etc). Even though I change the format in the schedule screen from say Crystal Reports to Excel, I still only get the report in...

I know the subject sounds daft but I can't think of a way to display the report that I need. I have a report where the page needs to be split in 2. The first half on the left is an image. The second half on the right is the detail. I have so far created a sub report displaying the detail...

Hi I'll don't know anything at all about Terdata but I need to set up and ODBC connection. I don't have any Teradata ODBC drivers on my PC, where can I get them from?

Is there anyway you can pass an array parameter into the record selection formula in Crystal R XI. Basically I have a field in my database that stores values such CA, ME, UK ({a.CatPartMarketCode} below) I need a parameter where a user can select multiple markets. If the db field stored just...

Hi I'm using Crystal Report Prof XI. I use a formula in a pie chart which sets a load of data to null if it doesn't meet certain critieria. The trouble is, although the null values aren't charted (which is what I want), there is still an annoying '0' without a label in the chart legend...

Hi I have a report with 1 grouping level. I need the page header displayed when showing the details but I want the page header suppressed when the group header is being displayed. Does anyone know how to do this? Thanks

Hi Does anyone know of a way to place hyperlinks in reports that would navigate around the report once exported to PDF? As an example, Say the first page contains a list of colours (report header), then the following pages were grouped by the colours (Group 1 and detail), so I'd want a link...

Ok, I've had a good rumage and can't find what I need and hope someone out there can help me. I'm trying to create a macro in Excel to find and replace special characters such as a comma. I'm using the code below which works fine until it gets to a cell that is 1655 characters long. The...

Hi, I'm having a look at a Mesh PC that has been completely screwed by XP service pack 2. It just about boots up but explorer, installer, restore, nothing is working. Before I re-build it, does anyone have any ideas on how to repair Windows XP. This area is not my strong point, so forgive me...

This problem is listed on the BO website and it basically say's that it's known problem in CR8 but is resolved on more recent versions. I need a group which is based on a formula. I can't see the formula in the insert group pop up (any ideas?). If I try and force it, i.e set it to a formula...

Does anyone know how to pass a Crystal Enterprise login name to use it as a filter in Crystal Reports? ta in advance

Hi I'm trying to execute store procedure with multiple input parameters but sql server isn't recognising the parameters that I am passing. The error message is "procedure ....expects parameter @Period, which was not supplied. It's breaking on the execute bit. I've tried naming the parameter...

Hi, Does anyone out there know of any Teradata SQL code that can change a sentence that reads something like THE BROWN FOX JUMPS to The Brown Fox Jumps

I've done search for this and nothing really similar to what is happening for me... Typical! I need to delete the current record and therefore have been merrily using DoCmd.RunCommand acCmdDeleteRecord. I'm using a different machine and it has stopped working. Getting the errow message...

Hi, I need to create an automated process to import tab delimited files. The problem I've got is that they are all in different formats i.e different columns in different places etc. I've tried using TransferText but it doesn't seem powerful enough? The text files that I am importing from...

Hi, I have a table that contains for example a person ID and products associated with that person. If I do a select * where personid = 1, I would get for example this PersonID Product 1 prod1 1 prod2 1 prod3 What I want is an out put that does this PersonID...

Hi, I have a listbox and I want to use the "on double click" to run some code. This is working fine but I can't seem to reset the list box to null when I have selected the first value as I want to run different code, if a value isn't selected. Can this be done? Cheers

I am trying to update a table when a change has been made to a secondary table. Can anyone spot where I am going wrong? Someone please help!! CREATE TRIGGER JenContactDateUpdate ON [dbo].[tblFees] FOR UPDATE AS UPDATE tblCompanies SET DateUpdated = getDate() FROM tblCompanies INNER JOIN...

Hi, I'm trying to call a stored procedure from AccessXP, that has a input parameter. The stored procedure has one input parameter @EventRef. This is what I have so far but the error message is Automation Error Unspecified Error -2147467259. Any ideas? Dim EventRef As Integer Dim conn As...