Will this card show up on my credit report?

Yes. It will be listed on your credit report just like other credit cards and loan products.