Search results for query: *

Hi there, Thanks for your speedy responses! i was trying to avoid having to link on a timestamp field as I wasn't suer how robust that would be - maybe I'm just being overly tentative - they're kind of my bette noir!! Anyway, I greatly appreciate you taking the time to answer - I'll give...

Hi All, Happy 2007 Tek-Tippers!! I have a generic "is it possible?" SQL query. If possible I will need to use any solutions in postgreSQL and SQL Server 2000. I have a table that contains Order information - let's call it tblOrders for the sake of originality. Every row represents a unique...

Hi there, Thanks for your replies - I had tested using other fonts prior to posting - there seems to be no rhyme or reason as to which ones work and which don't - I guess it will just have to be goodbye corporate font, hello Arial! Thanks again for your time - if anyone comes up with any fixes...

Hi All, CRXI, SP2 Windows XP, SP2 Adobe Acrobat 7.0.7 I have a very frustrating issue when exporting to PDF - every font size is reduced to an ulmost undecipherable size! I can increase the font size in the report design but that means every field overlaps and is extremely difficult to work...

Hi there, Thanks for your reply - apologies for the "save as" waffle, had clearly lost the plot at that point in time - I meant exporting to Excel from CR. You may well have hit on a point about the DLLs, I do all of the maintenance of our CR machines but recently had to do a rebuild on the...

Crystal Reports XI Crystal Reports Server XI PostgreSQL 8.0 DB WinXP Desktop Excel 2003 Hi there, I have designed a report in CRXI and have a number of field headings that are wrapped. When I export to Excel straight from CRXI and open the Excel file, the cells containing the field headings...

Hi there, Thanks for the reply, I'm guessing I just can't do what needs to be done... I'm all out of ideas! Apologies for not replying sooner, I didn't get my email notification that someone had replied! Many thanks, NixyJ

Crystal Reports XI PostgreSQL 8.0 DB WinXP Desktop Hi there, I wonder if someone can help me please! I have a report where the Page and Report headers background's are black. Our company logo is white on black, so makes the reports aesthetically pleasing!! buuuuuutttt... our purse strings...

Hi there, Revisiting archived thread 149-402603 I am currently migrating all our internal reporting from COGNOS Impromptu to Crystal Reports XI, and I am planning on using Crystal Reports Server to schedule and distribute internally as PDFs. The current COGNOS Impromptu reports write in pdf...

Hi Tom, Thanks for the replies! I'll have some of what you're swilling if there's any left - would make my afternoon go a whole lot better!!! :-) I'm not converting the file types at all - the photos were originally saved as jpegs before being pasted into Excel. Once that has happened all...

Hi All, I've read through a number of threads relating to saving Excel as an image but my problem is slightly different. I have a stock sheet where each row represents a different product. Each product can have up to 3 pictures in columns E,F and G for example. As part of an export function...

Hi there, I have a curious problem that has been driving me slightly insane for a few days now! I'm running Office XP and have a worksheet that contains information for individual products that my company sells, imcluding up to three images for each product. The issue is that I want these...

Hi all, SQL expressions seem entirely unfathomable to me! I agree with you both cmmrfrds and synapsevampire. The only reason I started down this route was because of related posts that I'd seen before about how to solve my exact problem! I'm not entirely sure why Lbass' solution works for...

Hi there, Aggggghhhh ..... nope - still no joy - if I do that it gives me the Column prefix error again. This is driving me mad... I'm in so much trouble if I can't solve this!! Please can you explain why the SQL that I've got is summing to a report total as opposed to the SKU group? Many...

Hi cmmrfrds, Sorry for skipping over you earlier on - the site seems so screwy today - I didn't see you response until a minute ago. Thanks for your comments above - I must admit to not being the greatest SQL bod in the world - I'm pretty much following Lbass' method verbatim without...

Sorry all... I hit Submit rather than edit Post The new code should read ( SELECT SUM(AKA.upload) FROM tblTrial, tblTrial AKA WHERE AKA.SKU = tblTrial.SKU ) Many thanks, Nx

Hi there, Many thanks - I tried doing that as per a thread you helped me with some time back now. When I do this it uses "tblStock"."UnitsUploaded"... I have tried using this sytax throughout the expression but am continuing to get the same error message. I have however made a little...

Hi Ian, Many thanks for your really speedy reply - unfortunately I am still getting the same error message if I remove all quotes, single or double! Any other ideas? Nx

Hi All, Crystal version 10 Microsoft SQL Server 2000 I am trying to create SQL expressions to enable me to sort groups on a formula in the group footer. Thread767-874782 and Thread767-899216 both deal with this particular problem but I cannot get the required SQL expressions to save. Sample...

Hi there! Many thanks for all of your efforts above - I really appreciate it. Unfortunately I think this is probably something that can't be done - there are several layers of complexity that i can't represent in an SQL expression. I've tried your above ideas to try and get the SQL expresion...