Search results for query: *

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

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

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

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

I'm probably missing something obvious. My main report selects: department, location, userID, etc and groups on location. Within each location there are multiple UserID's. What I'd like to do is pass my sub-report parameter a list of all the UserID's so that for each grouped location I can let...

Hi All, I have a parameter prompting the user to select a name, and in my record selection formula, I want to interpret that selection for the query (like an IN inside the WHERE clause): {Table1.Field} = "Something" AND {Table2.Field} in Select {?User Parameter} Case "Value1": "["6001"...

I have a series of subreports within a main report. (CR version: XI). The subreports are arranged in a horizontal sequence. Since they are in a group on the main report, the output for each will span several lines depending on the number of records in that group. I would simply like to display...

I'm having trouble with a relatively simple report using version 8.5. The table structure briefly explained: The report selects certain accounts meeting a criteria. For each account, there can be 0 to many Opportunities. For each Opportunity, there can be 0 to many Previous Activities (stored...

I'm actually developing a simple report using Version 8.5. This report goes against a SQL Server back-end, and has a grouping on Account ID's. The selection criteria for the entire dataset essentially goes against a table with 6 status fields. So in my group selection formula, I have simply...