Recent content by lyanch

I tried the subquery as a join, it wouldn't recognize that it was correlated, and asked for the values. Lisa P.S. I think i am going to do this in a BO report using its top features...

Avg(select top 10 x) isn't the same as select top 10 avg(x) The first averages the top 10, the second takes the top 10 averages. Lisa

I am not sure exactly how to approach this. I have two tables. customer and order customer has a last contact date I want the average of the top 10 sales within 60 days of the last contact. I can get the top ten sales easily enough with a top ten query for the customer and date range using...

Does this happen from all browsers or certain users only? I had similar issues with some users. The problem seemed to be a combination of full cache and missing updates. I updated their browser and emptied the cache and all works fine. Lisa P.S. you may also open the excel file directly on...

What happens when you export? Do they get the whole field or only the truncated portion? I format my reports "don't grow" for viewing, but want the whole field to export. Lisa

Does anyone know if XML exports are more automated in CE10? They are still only available via URL for 9. Actually if anyone knows if XML is available for 10 at all would be a great help. Lisa

I still think you need quotes around your parameter value. All the URL's that I use require them to work correctly, no matter what the datatype. I am on 9 now but they have been that way since 10. I would think it should look something like...

They all use the default "from" account. I originally thought it was operator error, but I have scheduled reports that run every night on a recurrring schedule and sometimes they fail as well. That is why I really think this is an exchange error. The only thing that I can tie it down to is it...

I occasionally receive this error when scheduling reports to email (CE9). In the knowledge base there was an article that this was caused by a missing return in older versions of CE but that it had been fixed by a hotfix. I only get this error occasionally. I think it is an exchange...

Here is a URL I use for sending a string parameter that works fine. It may point you in the right direction: http://server1/report_center/viewrpt.cwr?ID=1304&apsname=coapps2&promptex-catalogId="1010010002BBA101" Lisa

Peter, The Crystal oracle stuff will *not* install automatically unless the oracle client is installed first. I am not sure on the newer version if it will auto install if the client is there.. anyway reinstall (update) crystal and select the datacomponent for oracle. As a general rule, I...

Change your date calculation to ignore when the date is null. ie) if {@YR}<> 0 and {@MO} <> 0 and {@DAY} <> 0 then Date ({@YR}, {@MO}, {@DAY}) Lisa

It works if you require your users to add the wildcards when they enter their parameters. Lisa

Right click on each field you want suppressed. Choose formatting and select "supress if duplicated" Lisa

I have found, when you get that type of behavior (ie only when exporting or going to higher pages) the problem is almost always related to a specific data row or rows. Is it predictable? ie. when i run the report starting and ending at the same place it always crashes when I get to page x...