Search results for query: *

Thank you so much for your help. Everything is working as intended (atleast no one is yelling yet ;-). I would have never figured this out without you! I really appreciate it. Have a great day.

Okay, thanks so much. That worked for my monthly grand totals, now is the process the same for the far right totals (by physician)? The number should be the same as the ContSupp.LASTDATE (ranking field), but it won't let me reinsert that same count field.

LB, Thanks so much. Just to clarify, I should do a test formula (in the details) of: if year({ContSupp.LASTDATE})=Year({?EndMonth}) and Month({ContSupp.LASTDATE}) = 1 then 1 ...and insert a summary and grand total on it?

Okay. Thanks again. You might recall me saying that the calculations were done on a row by row basis. The grand total formula is a successive process. The following formulas are what build the grand total. CONTACT1CNT WhilePrintingRecords; NumberVar Contact1Cnt; NumberVar...

I may have to go back and implement your suggestion (with sums inserted at the group level) in order to get the grand totals to work. if year({ContSupp.LASTDATE})=Year({?EndMonth}) and Month({ContSupp.LASTDATE}) = 1 then 1

Thanks so much. After deleting the group#2, the sort worked; however it got rid of my grand totals across the bottom. I think that relates to them using so many formulas to get the sums.

Okay. I right clicked on ContSupp.LASTDATE in the details section and clicked insert. Then I created a summary (count) of ContSupp.LASTDATE. I then did the Top/N sort step. See screenshots (I hope I'm not violating any rules with these screenshots).

Yes "Rank" is the count of {ContSupp.LASTDATE}. I tried the topN/Group Sort, but that didn't do anything. I chose the group level of "Contact", because that is the physician name field. However, it is just repeating what I already have on the far right column of the page (total)>

Thanks I'll try that. Yes, it is in Preview mode, but I can post any others in design mode.

Sorry better image. I just whited out some info so as not to disclose info.

Hmmm that worked as it was supposed to; however, now I'm th inking that I need to try a different approach. The attached screenshot shows the results. However, the intended result is to have the top-ranked physician (with the most referrals) listed first. For example, the last physician in the...

Thanks. I'll try that.

The last formula is in the details section and completes across the page for each month (it's incremented by one). So, actually I pasted the code for the formulas in reverse order: the first two are found in the group #3 footer and last one is in the details section. Thanks so much for your...

Here is a screenshot of the report. Sorry about the size.

For every month the previous programmer has a count field (i.e. Contact1Cnt). Here is the total that I'm trying to sort by: WhilePrintingRecords; NumberVar ContactTotal...

I' ve also read over the posts in the forum, and while they were helpful, I couldn't figure out my problem. I'm sure it is due to my lack of expertiise with this tool. My biggest issue is not being able to type the SQL Directly. I've been spoiled by doing queries in sql server query analyzer...

I inherited a CR 8.5 Report, and I am definitely a newbie. The report has three groups: 1 by contact, 1 by zip code, and 1 by account mgr. Each acct mgr has certain zip codes within which the contacts fall. Currently, the report counts how many times a referral was made by each contact each...

I have a data stream with three distinct data sources. The sample row rate is 1 and (for testing only) the maximum input rows is 5000. The problem is that the execution only reads the first data source in the data stream. I've tried changing from parallel processing to serial processing, as...