Search results for query: *

Lastfullmonth works fine in my record selection formula too. You shouldn't have any problems using it in there.

Another way that you could do without the variable is to use this formula: if {dbt_Patient.pt_Sex} = 2 then 1 else 0 then you can do a summary on that.

Yea I just did and it seems to work ok. I think it would really slow the report down if I had more records but as it is I think it will work great. Thanks for the suggestions.

Do you think it would cause any problems to just remove the can grow option on the field and size it so that only the first line is displayed? I should only have about 30 - 40 records on this report.

Do you think it would cause any problems to just remove the can grow option on the field and size it so only the first line is displayed? I should only have about 30 - 40 records on this report.

Sorry should have mention that in the first place. It is a memo field.

I need formula that will pull only the first line of a notes field. The line are seperated by a single returns in the DB.

You are correct. The subreport does not process immediately when opening the preview page. I believe this is because the subreport makes a seperate connection to the Database and does not use the one already established by the main report. One thing you could do so that you don't get the delay...

I didn't get the problem solved but I found a better solution for my problem. Since I mainly do the report for the previous month I just used "lastfullmonth" to pull the dates in automatically. Thanks for all the suggestions.

Is there a way to create a Table of Contents that updates automatically when the report is run? Currently I have to modify the TOC every time because the page numbers change. I don't know if this makes it simpler or more difficult but I'm using subreports to display a majority of the data...

I've checked that and the correct information is being passes on. It's just that the subreport won't run. I don't any errors and it runs fine standalone. It just won't run as a subreport. Anything else I can try?

Does anyone have anything I can try??? I desperately need working.

Here is the record Selection formula for the Subreport: {PROBLEM_VIEW.ORGANIZTION_ID} = "5" and {PROBLEM_VIEW.OPEN_DATE} in {?Pm-?Startdate} to {?Pm-?EndDate} The report that I'm inserting does not contain any subreports and the report does work when I put values in instead of the...

I'm using CR 8 and am now adding a couple of parameters to a couple of subreports. The parameters are being used in the selection formula. The problem is as soon as I put in the parameter the subreport no longer runs. I can run the subreport by itself and it will run but it doesn't run as a...

Does anyone have any Ideas that I can try?

I have a problem, I need to sort the others group in with the rest of the data by the same percentage. Here is an exampleof what is happening: data 1 40% data 2 20% data 3 13% data 4 7% data 5 5% Others 15% What I need to happen is to have "others" sorted above data 3...

**"I would creae a running total field that counts the groups"** What is the best way to create a running total field in CR 8.0?

Basically my data needs to add up to 100%. So the others field is displaying the remaining percentage. I don't however need to display all of the details under others because it is basically a remainder field.

I am displaying the Top 5 in group #1 and leaving the rest marked as "others". In group #2 I need to suppress the data only if it is in the "others" list. I know I can suppress it by not displaying "others" but I need that information. Any Ideas on this? Thanks in...

I am displaying the Top 5 in group #1 and leaving the rest marked as "others". In group #2 I need to suppress the data only if it is in the "others" list. I know I can suppress it by not displaying "others" but I need that information. Any Ideas on this? Thanks in...