Exporting financial report into excel and exceed rows - need alternative
I also tried to pull is csv and that was a mess.....we only show the Excel 7 and Excel 8 and (etended versions)...
Any help is appreciated!
Paula.
Comments
-
Paula Eyerman:
We are struggling with exporting an RE financial report into Excel - we have done it in the past fine but we have now exceeded the number of rows allowed. Is there ANY way to remove the blank rows (before exporting it) or is there another way to get all the information so it can at least be converted to an Excel document. I know we need a long term solution but for right now I am looking for an easy work around. We have a process set up to use this document. I even tried running the report with two different queries - trying to get 1/2 of the records at a time but that is not proving easy either. I was pulling on the sort key and still not seeming to pull all the records.
I also tried to pull is csv and that was a mess.....we only show the Excel 7 and Excel 8 and (etended versions)...
Any help is appreciated!
Paula.Are you exporting the results of a Report? Have you tried to create an Export with the same info on the Report? That way you can skip all those random blank rows that Excel likes to throw in on the Report results.
1 -
No - I think that is my only option at this point - so I am going to try that this morning.
Thank you!0 -
Amy Dana:
Paula Eyerman:
We are struggling with exporting an RE financial report into Excel - we have done it in the past fine but we have now exceeded the number of rows allowed. Is there ANY way to remove the blank rows (before exporting it) or is there another way to get all the information so it can at least be converted to an Excel document. I know we need a long term solution but for right now I am looking for an easy work around. We have a process set up to use this document. I even tried running the report with two different queries - trying to get 1/2 of the records at a time but that is not proving easy either. I was pulling on the sort key and still not seeming to pull all the records.
I also tried to pull is csv and that was a mess.....we only show the Excel 7 and Excel 8 and (etended versions)...
Any help is appreciated!
Paula.Are you exporting the results of a Report? Have you tried to create an Export with the same info on the Report? That way you can skip all those random blank rows that Excel likes to throw in on the Report results.So as I was creating the export - I realize I can't do it that way because it will create additional columns for the different funds and I need a seperate row for each gift....any other suggestions?
0 -
Have you got any experience with Crystal Reports? You could change the export format from XLSX to MDB and then use that as a data source in Crystal, where it would be relatively straightforward to display each fund split on a separate line (assuming that's what you mean by having a separate row for each gift).0
-
Good suggestion,
I am filling in for a position and I was hoping to get through the interim with a quicker fix. I do think this is how we will need to proceed in the long run - thank you!
0 -
Paula Eyerman:
We are struggling with exporting an RE financial report into Excel - we have done it in the past fine but we have now exceeded the number of rows allowed. Is there ANY way to remove the blank rows (before exporting it) or is there another way to get all the information so it can at least be converted to an Excel document. I know we need a long term solution but for right now I am looking for an easy work around. We have a process set up to use this document. I even tried running the report with two different queries - trying to get 1/2 of the records at a time but that is not proving easy either. I was pulling on the sort key and still not seeming to pull all the records.
I also tried to pull is csv and that was a mess.....we only show the Excel 7 and Excel 8 and (etended versions)...
Any help is appreciated!
Paula.
I also think you were on the right track by pulling the query in parts. You just have to figure out the best way to sort it based on your fields, that will allow you choose choose the first half and second half... or maybe you are at a point where it needs to be in thirds.0 -
every entry has two empty rows after it.....I tried to make all of the columns very small in the report to see if that eliminated the empty rows and it didn't. If you can tell me how to check on the excel spreadsheet to see what is making the empty rows that would be great.
I'm working on the query being split into names - but it looks like I need to add to all the OR statements and this query is used for other things - so not a real easy fix as I was hoping.
Thanks!0 -
Paula Eyerman:
every entry has two empty rows after it.....I tried to make all of the columns very small in the report to see if that eliminated the empty rows and it didn't. If you can tell me how to check on the excel spreadsheet to see what is making the empty rows that would be great.
I'm working on the query being split into names - but it looks like I need to add to all the OR statements and this query is used for other things - so not a real easy fix as I was hoping.
Thanks!
What I usually do is export to Microsoft Access. It looks kind of messy in Access, so I create a query of just the fields that I need, then I export it back to Excel. It' kind of cumbersome, but it gives me a clean export to Excel in the end.
0 -
Christine Cooke:
Paula Eyerman:
We are struggling with exporting an RE financial report into Excel - we have done it in the past fine but we have now exceeded the number of rows allowed. Is there ANY way to remove the blank rows (before exporting it) or is there another way to get all the information so it can at least be converted to an Excel document. I know we need a long term solution but for right now I am looking for an easy work around. We have a process set up to use this document. I even tried running the report with two different queries - trying to get 1/2 of the records at a time but that is not proving easy either. I was pulling on the sort key and still not seeming to pull all the records.
I also tried to pull is csv and that was a mess.....we only show the Excel 7 and Excel 8 and (etended versions)...
Any help is appreciated!
Paula.
I also think you were on the right track by pulling the query in parts. You just have to figure out the best way to sort it based on your fields, that will allow you choose choose the first half and second half... or maybe you are at a point where it needs to be in thirds.
OR saving that canned report as a Query which is the checkbox option on the bottom of the first tab, and then Exporting that Query through Export, you will not get the extra rows between records/names that way.1 -
I exported to an mdb file yesterday but I think your suggestion - is perfect....I will work on that one today.. thank you!0
-
Thanks for the suggestion - so once again I went to export and when there are multiple funds it puts in a new column and I need them to be multiple rows so this won't work.
Paula0 -
Paula, When you go into the export functions for the financial report what options do you see? When I choose the below options, I do not get any blank rows.
0 -
-
Brenda - I think you are a genius!!!! This worked perfectly - THANK YOU!
0 -
Paula,
I'm glad you were able to get what you needed.
Brenda0
Categories
- All Categories
- Shannon parent
- shannon 2
- shannon 1
- 21 Advocacy DC Users Group
- 14 BBCRM PAG Discussions
- 89 High Education Program Advisory Group (HE PAG)
- 28 Luminate CRM DC Users Group
- 8 DC Luminate CRM Users Group
- Luminate PAG
- 5.9K Blackbaud Altru®
- 58 Blackbaud Award Management™ and Blackbaud Stewardship Management™
- 409 bbcon®
- 2.1K Blackbaud CRM™ and Blackbaud Internet Solutions™
- donorCentrics®
- 1.1K Blackbaud eTapestry®
- 2.8K Blackbaud Financial Edge NXT®
- 1.1K Blackbaud Grantmaking™
- 527 Education Management Solutions for Higher Education
- 1 JustGiving® from Blackbaud®
- 4.6K Education Management Solutions for K-12 Schools
- Blackbaud Luminate Online & Blackbaud TeamRaiser
- 16.4K Blackbaud Raiser's Edge NXT®
- 4.1K SKY Developer
- 547 ResearchPoint™
- 151 Blackbaud Tuition Management™
- 61 everydayhero
- 3 Campaign Ideas
- 58 General Discussion
- 115 Blackbaud ID
- 87 K-12 Blackbaud ID
- 6 Admin Console
- 949 Organizational Best Practices
- 353 The Tap (Just for Fun)
- 235 Blackbaud Community Feedback Forum
- 55 Admissions Event Management EAP
- 18 MobilePay Terminal + BBID Canada EAP
- 36 EAP for New Email Campaigns Experience in Blackbaud Luminate Online®
- 109 EAP for 360 Student Profile in Blackbaud Student Information System
- 41 EAP for Assessment Builder in Blackbaud Learning Management System™
- 9 Technical Preview for SKY API for Blackbaud CRM™ and Blackbaud Altru®
- 55 Community Advisory Group
- 46 Blackbaud Community Ideas
- 26 Blackbaud Community Challenges
- 7 Security Testing Forum
- 3 Blackbaud Staff Discussions
- 1 Blackbaud Partners Discussions
- 1 Blackbaud Giving Search™
- 35 EAP Student Assignment Details and Assignment Center
- 39 EAP Core - Roles and Tasks
- 59 Blackbaud Community All-Stars Discussions
- 20 Blackbaud Raiser's Edge NXT® Online Giving EAP
- Diocesan Blackbaud Raiser’s Edge NXT® User’s Group
- 2 Blackbaud Consultant’s Community
- 43 End of Term Grade Entry EAP
- 92 EAP for Query in Blackbaud Raiser's Edge NXT®
- 38 Standard Reports for Blackbaud Raiser's Edge NXT® EAP
- 12 Payments Assistant for Blackbaud Financial Edge NXT® EAP
- 6 Ask an All Star (Austen Brown)
- 8 Ask an All-Star Alex Wong (Blackbaud Raiser's Edge NXT®)
- 1 Ask an All-Star Alex Wong (Blackbaud Financial Edge NXT®)
- 6 Ask an All-Star (Christine Robertson)
- 21 Ask an Expert (Anthony Gallo)
- Blackbaud Francophone Group
- 22 Ask an Expert (David Springer)
- 4 Raiser's Edge NXT PowerUp Challenge #1 (Query)
- 6 Ask an All-Star Sunshine Reinken Watson and Carlene Johnson
- 4 Raiser's Edge NXT PowerUp Challenge: Events
- 14 Ask an All-Star (Elizabeth Johnson)
- 7 Ask an Expert (Stephen Churchill)
- 2025 ARCHIVED FORUM POSTS
- 322 ARCHIVED | Financial Edge® Tips and Tricks
- 164 ARCHIVED | Raiser's Edge® Blog
- 300 ARCHIVED | Raiser's Edge® Blog
- 441 ARCHIVED | Blackbaud Altru® Tips and Tricks
- 66 ARCHIVED | Blackbaud NetCommunity™ Blog
- 211 ARCHIVED | Blackbaud Target Analytics® Tips and Tricks
- 47 Blackbaud CRM Higher Ed Product Advisory Group (HE PAG)
- Luminate CRM DC Users Group
- 225 ARCHIVED | Blackbaud eTapestry® Tips and Tricks
- 1 Blackbaud eTapestry® Know How Blog
- 19 Blackbaud CRM Product Advisory Group (BBCRM PAG)
- 1 Blackbaud K-12 Education Solutions™ Blog
- 280 ARCHIVED | Mixed Community Announcements
- 3 ARCHIVED | Blackbaud Corporations™ & Blackbaud Foundations™ Hosting Status
- 1 npEngage
- 24 ARCHIVED | K-12 Announcements
- 15 ARCHIVED | FIMS Host*Net Hosting Status
- 23 ARCHIVED | Blackbaud Outcomes & Online Applications (IGAM) Hosting Status
- 22 ARCHIVED | Blackbaud DonorCentral Hosting Status
- 14 ARCHIVED | Blackbaud Grantmaking™ UK Hosting Status
- 117 ARCHIVED | Blackbaud CRM™ and Blackbaud Internet Solutions™ Announcements
- 50 Blackbaud NetCommunity™ Blog
- 169 ARCHIVED | Blackbaud Grantmaking™ Tips and Tricks
- Advocacy DC Users Group
- 718 Community News
- Blackbaud Altru® Hosting Status
- 104 ARCHIVED | Member Spotlight
- 145 ARCHIVED | Hosting Blog
- 149 JustGiving® from Blackbaud® Blog
- 97 ARCHIVED | bbcon® Blogs
- 19 ARCHIVED | Blackbaud Luminate CRM™ Announcements
- 161 Luminate Advocacy News
- 187 Organizational Best Practices Blog
- 67 everydayhero Blog
- 52 Blackbaud SKY® Reporting Announcements
- 17 ARCHIVED | Blackbaud SKY® Reporting for K-12 Announcements
- 3 Luminate Online Product Advisory Group (LO PAG)
- 81 ARCHIVED | JustGiving® from Blackbaud® Tips and Tricks
- 1 ARCHIVED | K-12 Conference Blog
- Blackbaud Church Management™ Announcements
- ARCHIVED | Blackbaud Award Management™ and Blackbaud Stewardship Management™ Announcements
- 1 Blackbaud Peer-to-Peer Fundraising™, Powered by JustGiving® Blogs
- 39 Tips, Tricks, and Timesavers!
- 56 Blackbaud Church Management™ Resources
- 154 Blackbaud Church Management™ Announcements
- 1 ARCHIVED | Blackbaud Church Management™ Tips and Tricks
- 11 ARCHIVED | Blackbaud Higher Education Solutions™ Announcements
- 7 ARCHIVED | Blackbaud Guided Fundraising™ Blog
- 2 Blackbaud Fundraiser Performance Management™ Blog
- 9 Foundations Events and Content
- 14 ARCHIVED | Blog Posts
- 2 ARCHIVED | Blackbaud FIMS™ Announcement and Tips
- 59 Blackbaud Partner Announcements
- 10 ARCHIVED | Blackbaud Impact Edge™ EAP Blogs
- 1 Community Help Blogs
- Diocesan Blackbaud Raiser’s Edge NXT® Users' Group
- Blackbaud Consultant’s Community
- Blackbaud Francophone Group
- 1 BLOG ARCHIVE CATEGORY
- Blackbaud Community™ Discussions
- 8.3K Blackbaud Luminate Online® & Blackbaud TeamRaiser® Discussions
- 5.7K Jobs Board