Search results for query: *

Thanks for the update. Just out of curiosity, did you select/de-select all using an event (something similar to what was posted on check/uncheck) or did you select/de-select manually. When I do it manually, the field is indeed updated. When I click the independent check-box to...

Hi MajP, Good point - and a correction on my part. I meant that I changed the field type to be a multivalue and not a multi-select. I believe multivalue fields can be represented visually as ListBoxes or ComboBoxes. I decided to represent it as a ListBox. Now if I manually check multiple...

Thanks for the reply. I updated the field to be multi-select and the control to be a listbox. So multiple selections can now be stored. The desired behavior is that the user should be able to check/un-check the 'Select All' checkbox and all/none of the listbox values should get either...

Greetings, I have an issue which I'm hoping to get some help with. There is a DynaSet form which is tied to a table called: tblBasicInfo. Everything works as expected except for a listbox. I have placed a checkbox next to it, to allow users to select all the entries: Code: Private Sub...

Hello all, I'm sort of at my rope's end as I have never faced this problem before. In Cystal X, I would simply like to pass a parameter to a sub-report. This parameter is actually a shared variable which is calculated on a different sub-report. I know the shared variable is good as it is...

Hi Folks, This one is driving me up the wall and I can't imagine why it's so difficult. In my main report, I'm building 2 arrays from the detail section: Array 1 = the unique ID's Array 2 = a date value associated with that ID. The arrays are declared in the main report as Shared variables...

kray4660 and CoSpringsGuy - thanks a lot for your response. I tried CDbl on the exchange rate, and despite formatting to 10 decimal spaces, the displayed value was still 0.80000... But the good news is that (as pointed out), the actual calculation is correct in that the exchange rate being...

Hello Folks, I have a question regarding curency conversion (exchange rate) and precision. I have the exchange rate coming into the report as a string (i.e. "0.07654"). I would need to multiply this in a formula with a database field (SQL Server NUMBER type). The only problem is that when...

Hi Folks, I'm running CR 11. I have a main report with several sub-reports each linked on three parameters. The sub-reports are simply counts (the ID's are in the supressed detail section and the visible footer has the Sum). Everything renders fine as long as the main report has 1 or more...

I am filtering records (Crystal XI) based on a SQL Server 2005 DateTime field (EST_PROPOSAL). So my formula is as follows: ((Month ({C_OPPORTUNITY.EST_PROPOSAL}) = {@CurrentMonth}) and ((Year ({C_OPPORTUNITY.EST_PROPOSAL}) = {@CurrentYear}))) The CurrentMonth and CurrentYear formulas are...

Thanks LB! This is now working exactly as desired. One question - I'm using the UserSecurity.ManagerID as the underlying value field and UserInfo.UserName as the description field. But the Value drop-down only populates when editing the parameter if the description field is set to None. For...

Hello All, I'm not sure if this is possible because I haven't been able to do find a method so far. I'm using Crystal XI. We have a static parameter with manager's names. What I would like to do is filter record selection to only employees under the selected manager. The employee and...

That worked perfectly LB. Thank you very much for your patience with this - I learned quite a bit along the way. :)

Please bear with my ignorance as CR is my weakest skill. I just want to verify my understanding before the changing the report. Here's how I've set this up: GH2a: Has about 20 subs including one with the following code: shared numberVar hist_ctr := Count({...}) I think you're suggesting to...

That makes sense...and indeed it works as you wrote. So I guess there's no way to change the placement. All the subs and their output are in GH2A but this calculation will output in GH2B. The last question (since this is now mostly working), is where the placement of the reset code will be. You...

Thanks as usual LB. Actually my criteria was wrong because I didn't have the right specs. The shared var. in the sub should really be: shared numberVar hist_count := Count({history.entryID}); In the main report there are two groups. Within the second group's header (which is where the sub is)...

I have a variable (Global by default) in my subreport which basically increments based on a condition: numberVar connectionsCtr:= 0; if {HISTORY.TYPE} = some value connectionsCtr := connectionsCtr + 1 else connectionsCtr The problem is that the variable only goes to 1 and doesn't really...

That was the problem. The sub was linked on the incorrect group. By re-linking to the correct level, I was able to filter out the initial set of records. This was exactly what was needed - rather than doing the filtering separately within the sub itself. Thanks!

That'd be perfect - the ability to get a group total to display back to the main report. Right now, I'm using shared variables between the sub and main that get totals for all the groups. But these are essentially running totals. I'd like to print per group and then "reset". Thanks.

The idea to use the same queries in the subs is a good one. But to be simpler, what we get from the subs are counts (totals) per user. Is there a way to simply take those subreport counts and total them per group to display on the main report? I mean I can just supress the sub-reports so they...