Report logo quality + query sorting problems

Tumoz

Board Regular
Joined
Mar 9, 2015
Messages
68
Hi guys!

1st problem:
I set the search criteria in query design view, from column A I want to filter 3 different search terms, and of those three, I just want column B data which do not contain blanks. When I press the "Run" column A is different from the amount of data B, i.e., Filtering does not work. Column A should have the same amount that B has.
query view: View image: query
RUN result: View image: Isnotnull


2nd problem:
I want to make a report and add my logo on top right corner. All looks good until I press the "print preview", the image appears blurred and unclear, when i print it, it looks as terrible on paper. I am confused.. :eek:
logo settings: View image: blur logo

Please help me.
 

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.
Could anyone help me with logo quality? I can manage the first case by creating lots of excel files.
 
Upvote 0

Forum statistics

Threads
1,221,877
Messages
6,162,579
Members
451,776
Latest member
bosvinn

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top