Okay, this one is slightly complicated.
I have a program that I use at work that I download a report from, and that report is TOTALLY unhelpful, so it gives you an option to produce all the information in the database in an excel import.
With me so far? I didn't think so...But onwards:
Once I have imported that into excel, it is MUCH more useful, and instead of using the canned reports, I create pivot tables that give me the info I need.
HOWEVER; my boss has recently asked that I add a particularly LONG text field to the table and I have done so, and it is exactly where I want it.
Problem? The text trails off and not all of it shows up. Needless to say, this sucks. I can see in the worksheet that the data originates from that I have all the text, it just isn't showing up in my report. How can I make it do what I want it to?
Thanks!
I have a program that I use at work that I download a report from, and that report is TOTALLY unhelpful, so it gives you an option to produce all the information in the database in an excel import.
With me so far? I didn't think so...But onwards:
Once I have imported that into excel, it is MUCH more useful, and instead of using the canned reports, I create pivot tables that give me the info I need.
HOWEVER; my boss has recently asked that I add a particularly LONG text field to the table and I have done so, and it is exactly where I want it.
Problem? The text trails off and not all of it shows up. Needless to say, this sucks. I can see in the worksheet that the data originates from that I have all the text, it just isn't showing up in my report. How can I make it do what I want it to?
Thanks!