Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: kj27
  • Order by date
  1. kj27

    Multi-select listbox issues

    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...
  2. kj27

    Multi-select listbox issues

    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...
  3. kj27

    Multi-select listbox issues

    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...
  4. kj27

    Multi-select listbox issues

    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...
  5. kj27

    Sub-report blank after linking parameter

    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...
  6. kj27

    Selecting Sub-Report records based oon main Report arrays

    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...
  7. kj27

    Currency multiplication and precision

    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...
  8. kj27

    Currency multiplication and precision

    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...
  9. kj27

    Sub-reports blank when main report has no data

    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...
  10. kj27

    Skewy Date Logic

    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...
  11. kj27

    Advanced Record Selection

    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...
  12. kj27

    Advanced Record Selection

    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...
  13. kj27

    Counter Variable in Subreport

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

    Counter Variable in Subreport

    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...
  15. kj27

    Counter Variable in Subreport

    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...
  16. kj27

    Counter Variable in Subreport

    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)...
  17. kj27

    Counter Variable in Subreport

    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...
  18. kj27

    Formulate a list of values to pass on to Sub-report

    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!
  19. kj27

    Formulate a list of values to pass on to Sub-report

    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.
  20. kj27

    Formulate a list of values to pass on to Sub-report

    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...

Part and Inventory Search

Back
Top