Based on the information provided, this is relatively simple to achieve using a macro to call a userform in which you can select the birth sign based on the birth date and write various values to the report as in the rudimentary example attached. See also
Create a userform
Personally I would probably use content controls rather than docvariables to display the text again as in the attached, but either is possible.