Search results for query: *

Thanks LB, that's fixed it.

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...

so easy when you know how! Thank you to you both!

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?

I can see why it should have worked, perhaps it would have done if I'd added in the +",". Cheers

Hi LB think I've got this cracked now. I created a formula field {CatPartMatch} with this code numbervar i; numbervar j := ubound({?Market}); stringvar sCatPartMarket; sCatPartMarket:= 'No Match'; for i := 1 to j do ( if...

Thanks LB for the suggestion. It's not really working though. {a.CatPartMarketCode} could have any combination of 2 digit character codes, separated by commas such as [ME,CN,GB] or [CN] or [CZ,ME,CN] Similarly, the parameter array will have any code, any order. I was thinking about making it...

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...

ok worked out how to do this from a previous post! cheers

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

I had a feeling this might be the case! Thanks for responding! Do know what sort of applications would process the PDF and how how complex are they to use? 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...

Hi Thanks for responding. Basically, if I do a find and replace on a cell that has 1655 characters in it, I get and error message 'Formula too long'. I've actually managed to find some code which has sorted the problem. Set Sh = ActiveSheet Set rRng = Sh.Range("H1:I5000") For Each r In...

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...

Thanks for all of your advise, I'll have a go later on and keep you posted. Incidentally, there were zero problem during the install itself, however, once installed the pc would keep rebooting itself, this I fixed, using a download form Mesh's website. Chkdisk is one of the many things not working!

Thanks for this but have already exausted all of the options on this page. The NTUninstall hangs and the system restore errors.

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...