Hi there, I have a report where a formula field is generating multiple values. I need the report to be exported to excel where the formula that is generating multiple values are display in excel as per data per row/column box.
any help/suggestions are appreciated!
Hey Lb, is there anyway ref_num and ser_num records be displayed as individually for example..
ref_num_1 ref_num_2
1 2
We must export the data to excel and have those records in separate columns instead of the same columns.
I do see where I have confused you now, my fault. :) Well, before adding in your formulas, here is an example of the data I have.
table1:
team_id
child_id
last_name
table2:
referral_num
table3:
service_num
Here's the report that it outputs without any formulas:
teamid childid last name...
Yes, I started to add in more fields to better understand what the data is reporting. As for service_num, I did the same thing with service_num as you gave me for referral_num.
To better understand the data a little more, if I can explain, a referral_num is associated with a specific...
Hey LB, if you could be kind enough to help me with one more little detail, I highly appreciate it. I've been working on this for hours.
The reports work perfectly, generating reports the way I want it. Although, after looking closely at the data after printed, I notice some of the records were...
This is exactly what I need! THank you so mych LB.
Although, some of the records are repeating more than once.
Example:
Smith 3 2 2
Smith only has 3 and 2
Thank you so much for responding. I am trying the Crosstab method, but I would like to know how to do the report the regular way. I need to customize some fields as the report progresses. Any suggestions?
Hi everyone! I am too new to CR but i know my way around it a little. I tried this method, and it don't seem to work for me. I need to get data on one line. For example, for my data.. I have this:
Child_ID
Child_BirthDate
Child_LastName
(this data is on the same table)
Referral_Num
(this...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.