I am not sure how the best way to do this, but I have 30 branches.

I am working on a report that not all the branches have data in the database (yet). 

I need to be able to list those branches with a zero (0) qty. The other branches will be a count of records.

Example:

Branch 1 - 0 (This is not in database so I need to have a list of branches somewhere) (I tried an excel sheet but I got "Data types are not compatible", my crystal data is String. 
Branch 4 - 5
Branch 6 - 3

Any ideas?

I need to hard code my requirements.  But how do I do that in the report?

I need to hard code all the branches.

Branch 1
Branch 15
etc.....

Here's the issue that I brought up in my first post.

I get an error back when I try to join the excel document.  I cannot figure out how to change my branch #'s to a string to match the string from Crystal/my database.

Any ideas on how to either convert or what type of table to use to get the two to join?