Solved

Setting up group/header name based on page number

Posted on 2004-10-18
9
185 Views
Last Modified: 2008-03-06
Hello,

I am trying to setup the title for the headers of my groups in a reports so that the On the first page I have "ABC Compay" and the second page of the group I have "ABC Compay continued..."

This is what I have:

if PageNumber = 1 then " " & "Provider: " &  Trim({rpt_RPN_ByProvider_ByMonth;1.ProviderName}) else

" " & "Provider: " &  Trim({rpt_RPN_ByProvider_ByMonth;1.ProviderName}) &  " continued..."


But it gives me an error: "A Summary Has Been Specified for a non-recurring field. Details: @headerName"

Please Help.

Thanks
0
Comment
Question by:bkourouma
  • 3
  • 3
  • 2
  • +1
9 Comments
 
LVL 10

Expert Comment

by:ebolek
ID: 12338777
Do you have a group on the provider name. How many different providers are there in the report. Did you place that formula in the group header1?

try this
if OnFirstRecord = true then " " + "Provider: " +  ({rpt_RPN_ByProvider_ByMonth;1.ProviderName}) else

" " + "Provider: " +  ({rpt_RPN_ByProvider_ByMonth;1.ProviderName}) +  " continued..."
0
 
LVL 28

Expert Comment

by:bdreed35
ID: 12338800
What section are you trying to put the formula in?

Are you grouping by ProviderName?  If so, I suggest trying this:

Change your Group to Repeat Group Header on each page.
You can do this by right clicking the left margin where it says Group Header X (ProviderName) and choose Change Group.
Under Options, select the property "Repeat Group Header on each page".
Next, change your above formula to the following, and place it in the Group Header:

if inRepeatedGroupHeader then
    " " & "Provider: " &  Trim({rpt_RPN_ByProvider_ByMonth;1.ProviderName}) &  " continued..."
else
    " " & "Provider: " &  Trim({rpt_RPN_ByProvider_ByMonth;1.ProviderName})

0
 
LVL 1

Author Comment

by:bkourouma
ID: 12339598
Both of those solutions give me the same error message.

I have 3 groupings: first is providername, then isNew and then month.

I am trying to put the @HearName in the Group providername header so that I know which provider it is. But ib the subsequent pages I want the "..continued."

Thanks
0
 
LVL 28

Expert Comment

by:bdreed35
ID: 12339698
Are you getting the same error message that you were getting in your original formula?

If so, you must not have posted the whole formula.  The error that you got indicates that you are trying to perform a summary function at a grouping level, and you are trying to summarize using a different field.
For instance, if you were trying to sum an amount field for the Provider Name group, you would need to write it like this;

sum({rpt_RPN_ByProvider_ByMonth;1.Amount},{rpt_RPN_ByProvider_ByMonth;1.ProviderName})

That would be valid assuming that you have a grouping in your report on ProviderName.
If you didn't have a group on ProviderName, than the logic above would give you the error you are getting.

Can you post the whole formula?
0
Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

 
LVL 100

Expert Comment

by:mlmcc
ID: 12339941
Are you grouping on @headerName instead of ProviderName

mlmcc
0
 
LVL 1

Author Comment

by:bkourouma
ID: 12340023
Yes I get the same error message. And I am doing the grouping on the providername. I did in fact post everything in the formula editor.

If I leave the formula like this: "" " & "Provider: " &  Trim({rpt_RPN_ByProvider_ByMonth;1.ProviderName}) " I have no problem. But as soon as I do an if statement, I get the same message,
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 250 total points
ID: 12342368
I just tried one like your first one in CR7 and it works fine.

if PageNumber = 1 then
  " " + "Provider: " +  Trim({rpt_RPN_ByProvider_ByMonth;1.ProviderName})
else
  " " + "Provider: " +  Trim({rpt_RPN_ByProvider_ByMonth;1.ProviderName}) +  " continued..."

I assume you have the formula split on lines like mine above.  I did get an error when I used & to concatenate.  You may need to change the & to +

mlmcc
0
 
LVL 28

Expert Comment

by:bdreed35
ID: 12374552
bkourouma:

Just for my own knowledge, was it the ampersand(&) that caused the problem?
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 12375979
Glad I could help

mlmcc
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now