Joined: 18 Aug 2021
Online Status: Offline
Posts: 12
Topic: How to pull all values of field in page header? Posted: 18 Aug 2021 at 7:55pm
Hi,
I am working on crystal report where I have to display the same field with different value from stored procedure in the page header suppressing the field value based on another field value. The problem is that in page header only first value of list fetched is displayed hence suppression is not working to fetch another values from list of values and showing blank in preview. How can we achieve other values of same field based on suppressed formula in page header ?
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Posted: 19 Aug 2021 at 8:11am
there are couple of ways to accomplish this...
You could run a subreport in group header 1a and use the results in group header 1b for your suppression.
You could do put all the information in a column in the stored proc.
You could mark the rows to be suppressed in the report in the stored proc.
As you see, I like to do as much logic in the stored proc as possible. It makes the report less intensive to code, and makes the report more transportable if you ever decide to change reporting platforms.
Also, I can see what the stored proc is doing much easier than the report making it easier for me to verify the results.
If you cannot modify the procedure, the subreport is probably the way to go. It will make for a slower report overall due to the subreport being called repeatedly, and you may not even notice...just something to think about.
Joined: 18 Aug 2021
Online Status: Offline
Posts: 12
Posted: 31 Aug 2021 at 12:47am
I have already pulled the information in stored procedure column and trying to display the column values in a field in group header but want to display value based on condition.
For eg:
DB column name = A,B
Field in group header :
Field1, Field2
Field1 value : column A:value1 when Column B value='B1'
Field2 Value: Column A:value2 when Column B value='B2'
but in group header only first value is displayed that is column A:value1 and for field 2 value blank is displayed.
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Posted: 31 Aug 2021 at 9:54am
is the group based on field1 and field2 or just field1?
If it is on both, as you have noticed you will only get 1 line.
If you want more, I would use a subreport which can group differently and display the results however you want.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
