Search results for query: *

Hello: I am using CR10, windows XP, connected via ODBC to a SQL server. I have a report that runs fine. The main report runs and returns around 10,000 groups of data. A quick subreport then runs for each of the groups returned. I have the detail sections hidden so a person can drill down if...

I have to constantly fight an automatic mandatory comany wide screensaver/logoff that occurs every fifteen minutes. When I am working its not a problem but when I am away from the desk for lunch or meetings, the screensaver comes on I will have to logon to windows again. After logging on...

Thanks for your work around idea of using 2 text boxes in different sections. I would really like to know how to fix this issue though. I was using CHR(10) and CHR(13) together because I figured that is how all new lines occur in text.

That still didn't work. I tried it with just CHR(10) also. This is only occuring in subreport captions. It does not have any problems with other formulas.

I am having problems with on demand subreport captions being exported incorrectly. The report works and looks great in crystal. Here is the on demand caption formula [COLOR=blue]Dim Text as String Text = CSTR(DistinctCount ({SKU}, {WHSE}),0,",") & chr(10) & chr(13) Text = Text & CSTR(Sum...

Hello: I have built a report that is looking at the type of shipments on trucks. There can be any combination of five different shipment types on a trailer. Now I am trying to build a report that will find trailers that have only one type of shipment. I have finished working on the group...

CRCDATA again. I forgot to mention that I am using a formula that needed to be set to null. To do so, I created formula called "NULL Formula". After I created it I left it blank. No statements or anything in it. Then I modified my first formula with an if then else statement. If {@My...

EO, I am using CR 10. I had to deal with the same problem all day today. I know how to exclude nulls with running totals but not summarie fields or crosstab, until now. Running Totals: You can use the evaluate condition formula to exclude certain values. It requires a true/false formula...

I forgot to mention in this post, I am using crystal reports 10 professional. I will not be able to reply to any questions at work (They are very picky about cookies, I don't blame them.) I wrote this from home.

Hi All: I am doing some programing in VBA to retreive report definitions from reports. So far, so good. I can get almost everything I need. However, I cannot find any condition formula for the 'display string formula' of fields. I can set them in crystal reports by selecting a field...