Search results for query: *

Hi, I would like to add a button with lotus script behind it onto an embedded form in lotus 123. I can see how to add a button using the Approach form editor, but the only options appear to be to run a macro when the button is pressed. Is there any way to assign a script to this button instead...

Yes! Very hard work - but worth it - thanks!

Actually my data is in the footer, but I created a section below that and put it in there - that resulted in the budget field returning all zero's. I've had a look at other posts on this forum about this problem, and it seems that in version 8.5 the value is calculated in one section and is...

LB, This sort of works, but the value of the shared numvar budget is assigned in the section where the sub-report and data are. However it doesn't show up until at least the next section below - if you see what I mean. So say the budget value for a row was 10, the value of the formula field...

LB, Sorry, that doesn't quite work. If I select onlyt groups that have sales value not equal to zero, then groups where the sales value is equal to zero, but there is a budget value also do not show. I cannot use the budget figures in the group select equation as they exist only in...

Thanks LB - simple as it seems now - that's the solution I was missing!

LB, Thanks for this - something for me to think about. The {@ALL_SUM} formula selects on detail because they also want to see no blank rows when they drill-down to the detail level. I can get it to work one way or the other, it's just when I try and get both the main and drill-down reports to...

p.p.s Currently selecting out blank rows using the following parameter formula {@ALL_SUM} SALES_TM.SALES + SALES_LM.SALES Set as follows in the Select Records section {@ALL_SUM} <> 0 Cheers, Steve.

p.s Just noticed a typo in the SQL - but you get the idea: sales files linked to CUSOWN on account number, budget file on account category. Steve

Mr Bill, Thanks for your response. Unless you're thinking of a different way than I am I don't think it will, because if I had sales for a customer in a category for which there were no budget values for that period, then those sales would have nothing to link to, and so wouldn't show in the...

SV, Thanks for your reply, the information you require follows: Crystal Version is 8.5 Database is DB2 Example data: file CUSOWN - Holds customer details, fields follow ... CUSCAT - Customer category ("VOLUME ACCOUNT") CUSACC - Customer account code ("ACC001") file SALES_TM, SALES_LM -...

Hi, My situation is this ... I have a report that is grouped on customer type. You can drill down on these groups and get sales by customer. I have budget figures for the groups (customer types) only. To get the budgets I have created subforms with the budget data by customer type. I have...

Hi, I have a main report, which has an un-linked sub report containing one row of data relevent to todays date. I use this report to display last month as text (i.e. January 2004). This works fine un-linked, however I would like to use the value for month in this sub report in the select...

I have a question already. It is the categorised data that has values missing. If I create an &quot;On-demand&quot; sub-report for the details and omit values which are null, then will this solve my problem? Surely the categorised data, being based on the detailed data (not in the sub-report)...

Thanks, Not much of that means anything to me, but I'll get the manual out and have a go! Cheers, Steve

Hi, This is a repost as my old post appears dead as it has some responses which din't solve my problem. I have a database on our server which has a list of sales values for each product, each product belonging to a category. The top level of my Crystal Report (8.5) shows only the categories...

Hi, Not sure if it's the same with the crashes you're getting, and so you may like to test this on a non-critical machine first, but if you get rid of the processes nhldaemon or naldaemon (can't remember which one is left after a crash), wait a bit and then relaunch Notes it should work OK. If...

Hi, Thanks for your responses. It may be helpfull to explain what I am trying to achieve. I have a database on our server which has a list of sales values for each product, each product belonging to a category. The top level of my report shows only the categories. Some of the categories...

HI all, I am pretty new to this, so apologies if this is a silly question, but I Have entered the following into the Report - Edit Selection Formula - Group formula window: NOT IsNull(Sum ({D020FIG_LY.STERL01}, {CTPATMS.PTCATG}))OR NOT IsNull(Sum ({D020FIG_TM.STERL01}, {CTPATMS.PTCATG}))...

Hi Katy, Thanks, I have tried going there, and you can select which fields to show based on their value using that option. What I actually need to change are the fields that are used in the query, and possibly even the databases too, i.e. the values that are included in the SQL SELECT...