Search results for query: *

Have you tried to right-click the field? An alternativ for resizing is to select the point "Size and Position" (or similar, my version is a german one) from the context menu. Is the behaviour in every report or only in certain? Is it the same if you create a new report and only add one text...

What do you mean with "a high one fixed"? Perhaps I will understand your problem better if I can follow that. If you want to have three identical version of the same contents the alternative solution is to create a view on the database that returns your data three times, for instance with an...

Hi, first of all: Which version of CR are you using and where do you get the data from? Next: Do you really want 3 identically copies of the same report or did you make modifications to the subreport (e.g. other sort criteria)? If you continue with your 3-subreport-solutioan you should try...

Hi, we notice to kinds of problem on machines running CR 10 under WinXP: 1) When locking the PC (using CTRL+ALT+DEL or other technical solution, that does not make a difference) while CR is working on a report with lots of pages and then unlock it again, CR seems to "forget" the pages that...

...in the report, not the running totals itself. Then create the formulas for the percentage: loc_percentage: ({@calls_per_loc}-{@holds_per_loc})*100/{@calls_per_loc} total_percentage: ({@calls_total}-{@holds_total})*100/{@calls_total} In the group footer or for the total in the report footer...

I've made the experience that isNull sometimes does not work if it is not the first statement in the formula. Therefor I would do the following. Formula_field_1: if IsNull({Table1.field_1}) then 0 else {Table1.field_1} Formula_field_2: if IsNull({Table1.field_2}) then 0 else {Table1.field_2}...

Hi, what's the version? Starting with CR 8.5 you can mark one value label, select "chart option/selected element" (or similar, I don't know it exactly because I'm working with the german version) and change the font of the label. It is possible (depending on the version) that you have to run...

Hi, I've never worked with CR 9 because we switched from 8.5 directly to 10. But I think that the things are not that different in between. I would try to design a subreport and put it in the report header where it is executed only once. It reads the needed information from the v_pubinfo view...

Hi BillyRay, I just tried this. Furthermore I thought that it is a more generell question about JavaScript and hoped that at tek-tips there will be a greater number of experts, who probably may help. Barbara Barbara Fuhrmann (Cologne, Germany) - Using Windows 2000/XP, Oracle 9i and Crystal...

Juice, which version of CR do you use? I don't know a "Format with multiple columns". Unless that, to me it sounds like the best idea to place the column headers into the page header section. If you place it in the group header it will not be repeated on the next page automatically. You will...

Hi Juice, In case like yours I usualy use the running total. Yours could look like (all labeling can be exactly or similar in your CR because I'm running a german version): Name: YourRunningTotal Field for result: Table.SALES Kind of result: SUM Evaluate Section: Mark "Use Formula", then click...

Hi, in similar case I usualy build a formula that completes the string in a way that the sort result will be as required. Example: {@Event_completed} if length({TABLE.EVENT}) = 1 then '0'+{TABLE.EVENT} else {TABLE.EVENT} HTH Barbara

...Standard Edition with the ARTS Aerialist add on using the following JavaScript: printCurrentPage(); function printCurrentPage() { /* Print Current Page */ var iCurrentPage = this.pageNum; this.print({bUI: false, nStart: iCurrentPage, nEnd: iCurrentPage}); } It's...

Hi Hetal, when I started working with CR I had the same question. An expert pointed me to the following: In the subreport links box the dropdown at the bottom left SEEMS to have only the default {?pm-?parametername}. Make sure that the option "in subreport select data basing on the field"...

I tried that out and it resulted in the whole group 3 on the next page. That's better than befor but what I need is to keep group 2 together because it's of a size that will ALLWAYS fit on 1 page, sometimes 2 or 3 of group 2 may fit on one page. Therefor group 2 shall never be devorced.

Hi, my problem is the following: I have a report with several subreports. One of those is build of 4 groups, for group 2 in the group expert the option "keep together" is activated. This seems to work under most circumstances but in a certain data constellation it is only the sum in group...

Hi, just at the moment I'm working on a report which needs the same database table two times. With the expert I choosed it twice and the second now is named with "tablename_1". I'd like to change this alias. Can someone point me a way how to? Thanks in advance! Barbara

Hi, we've just upgraded from CR 8.5 to 10. It is the professional full version, but Crystal Enterprise is not licensed. In the help file I found a chapter about the Crystal Repository. It sounds to me as if you could use the Repository without Crystal Enterprise. But every time I try to, a...

Hi, I'm using CR X since some days and just found out the following (sorry if the terms are not exactly like they are in the english version, I'm working with a german one): In the chart expert remove the checkmark "Choose options automatically" first. Now you will see a flag "options". In the...

Hi paulmarr I tried that, but when I build a simple running total and put it in the chart its value is the december value for all displayed month. When I create 12 running totals (one for result of Jan, one for Jan+Feb, one for Jan-Mar, and so on) I don't know how to tell the diagramm expert to...