mje_1964
asked on
CR11 & Excel- How can to make Field Names the same as what is shown in header row?
I am working in Crystal Reports 11 trying to pull data from an Excel Spreadsheet.
When I grab data from Excel for my report, it pulls the field names in as F2, F3 etc instead of the header rows. The only field that is ever assigned a name and the name is wrong- is F1- for some reason CR11 pulls this from the Excel Spreadsheet Name & Sheet title.
I have to beleive this is something very simple that I am missing- can someone please help me?
Thanks!
When I grab data from Excel for my report, it pulls the field names in as F2, F3 etc instead of the header rows. The only field that is ever assigned a name and the name is wrong- is F1- for some reason CR11 pulls this from the Excel Spreadsheet Name & Sheet title.
I have to beleive this is something very simple that I am missing- can someone please help me?
Thanks!
Last Comment
ASKER
Kevin-
I can't seem to figure out how to do that- It has been some time since I tried to capture data from an Excel Spreadsheet through CR11. When I went into CR11 and started report- I added the sheet and then selected the fields I wanted included. I only wanted what is in the print preview area, but I can't seem to get that to work- I had to select the whole sheet. What am I missing here? Something simple, I'm sure.
I can't seem to figure out how to do that- It has been some time since I tried to capture data from an Excel Spreadsheet through CR11. When I went into CR11 and started report- I added the sheet and then selected the fields I wanted included. I only wanted what is in the print preview area, but I can't seem to get that to work- I had to select the whole sheet. What am I missing here? Something simple, I'm sure.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Kevin-
I will give this a try- I guess your comments above explain why I couldn't use Print_Area.
I will get back to you and let you know one way or the other if it works. Thanks
I will give this a try- I guess your comments above explain why I couldn't use Print_Area.
I will get back to you and let you know one way or the other if it works. Thanks
ASKER
I did what you said and it solved my problem- I have been fighting with this all day. I should have asked for help sooner.
THANK YOU SO MUCH!
THANK YOU SO MUCH!
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
Kevin