Recent content by rictorsan

Ok, you helped resolve the issue. The SHARED statement was used to allow re-use of the arrays by formula that require that same array, within the same reports, so that the array would not have to be declared within every formula used by a report. So instead of the entire array, the formula would...

I could not force the formula to evaluate WhileReadingRecords, I get the error 'The formula cannot be used as it must be evaulated later'. So I'm assuming it is a 2nd pass formula, and is therefore NOT availabe for sorting, select statements, charting, ...other areas ? Ken, I am not working...

The formula is as follows: formula= {HLD.quantity} * {@Price} * {hld.unit_size} @Price = Shared securityArrayHld(5) as double securityArrayHld(1) = {hld.security_id} securityArrayHld(2) = {hld.coupon_rate_mtf} securityArrayHld(3) = CDbl(CStr({hld.issue_date_mtf},"yyyyMMdd"))...

Thanks, that was helpful. However I now have a more difficult scenario. I need to sort by a *formula field*, not a table.column . Unfortunately, this formula exposes a custom UFL function and because I suppose it requires a 2nd pass, is not available for selection via Select, Summation etc. So...

I'm able to 'dynamically' sort a report based on user selection of a column by supplying a parameter, but I can't find a way to expose to the end user the ability to sort on one column either ascending or descending, via a parameter or otherwise. Ultimately I'd like to allow the user to 'click'...

I am having trouble figuring out if it is possible to use certain formula with things like charts, selects, top 'x' reports, cross tabs. I'm already using 'manual running totals' to get summation at the group level, since it is not possible to directly sum against these formulam but can't figure...

Can anyone tell me if there is a way to configure Crystal Reports to allow users to input dates in a configurable format. It seems that the only way u can enter a date, e.g., to satisify a parameter, is mm/dd/yyyy. Many of our users are Europe based and need to enter dates in dd/mm/yyyy...

Wondering if anyone is using, or has downloaded a trial version of Software Forces .rpt Inspector product, which allows you to modify report properties (formula, sections, other objects..) and propogate changes across reports. It appears to be in pre-release, so wonder what people's reactions...

I'm wondering if the amount of elapsed time that Crystal will wait for a server/datasource response might be configurable in the Win Registry. I'm getting a message that states. When running a report with a custom COM, sometimes it times out and I get a box ('Server Busy') that states: 'This...

I will be writing and distributing quite a few reports that will often contain the same formula that I've written (many which are accessed via a custom UFL). I know that 9.0 has an object repository, but I've developed my app in 8.5 and am curious to how users are going about the problem of...

I've noticed that a named or concurrent user can log into CE > 1 time, from a different workstation. So e.g., if two users shared a user name/pw, they could login simultaneously and only take up one license. While not pratical for typical usage, is it possible to prevent a user from logging in...

I have the need to create reports that always link across datasources. I have a custom service defined as a seperate data source, and need to link to a seperate datasource based on (typically) one common field. CD recommends using sub reports, but as I believe they will need to be linked sub...

I am building a custom Enterprise solution to distribute to my customer base and am developing in CE 8.5, using CR 8.5. I need to supply a standard library of reports, as well as a library of formula for re-use. I cannot use dictionaries to use of a UFL. I may have many reports that have the...

Does anyone know of an existing method to limit users to scheduling reports within a given time window. E.g., I know that users cannot schedule reports from 12 noon to 1, or I know that they CAN schedule them from 12:00am-6:00am. Is there anyway to automatically enforce this or would it need to...

I need to expose one or more parameters (e.g., Client Name)to users for reports that I will publish to a custom ePortfolio. Is it possible to expose a pick list as a parameter so that new Client Names added to the database are automatically displayed in the pick list ? How are other people...