Search results for query: *

Thanks. I have another question for you. How does this make the report more efficient? I can see that I reduce the number of records in each group, but I am not sure what the benefit of this is.

Naith, I am having trouble with this suggestion. Could you explain further? I can create the formula, but I am not sure what you mean by Group Selection Formula. I cannot use the formula I have created. (It is not available for grouping) I guess I am a little slow this morning.

I tried that the first round. I have some calculations that made this awkward and inconsistent. What I ended up doing was a series of formulas that took the maximum date from the details section, then matching ID numbers against that max date and performing various calculations from various...

I am sorry, My DB does not support SubQueries either. I am looking for a Crystal solution if it exists.

It seems that I was not very clear. My issue is not one of the data being physically present. What I need to do is a one to many type join that enables me to list all solutions for a case, then do some calculations and find a status based on the last solution timestamp matched against the case...

I am having a dilemma. I am using CR 8.5. I have a DB that does not support stored procedures. I need to know how I can find the last interaction to a customer issue. The structure is such that I have an issue (Case) that may have multiple interactions (solutions). I need to be able to find the...

Please forgive me for being slow, but here is my concern/question with the IP logging. We have users that each have access to multiple workstations. In addition, the users are literally scattered over the globe and at a number of different companies. Tracking individual user information by IP...

Thank you for this lead. I am less concerned at this point with what is happening with the reports than I am with looking a license usage overall. I have looked through the administrator's guide several times, but it does not give me the information I am looking for. In short, report usage is...

This could be a couple of scenarios 1. You have linked your subreport through the parameter and also have the same parameter set up in the subreport separately. If you look at the select expert, you should see two instances of the parameter. To change this, just remove the parameter that you...

Our system is at a point where we are exceeding our CAL licenses on a regular basis (daily). I have tried a number of things to resolve this, such as converting some CAL users to named users and vice versa, but this is not easing the problem. We are at a point where we are considering purchasing...

I suggest placing the 3 formulas individually. You can then use the section expert to create a formula that will suppress rows based on your criteria (I suggest an AND Formula) {Formula 1} = {Formula 1} and {Formula 2} = {Formula 2} and {Formula 3} = {Formula 3} This way, you can suppress rows...

I suggest that you group your data by calendar month. Suppress that group, then group by week. After you do this, you can use the various summary functions to produce the desired totals.