Search results for query: *

Thanks for your replies, I couldn't get the filter to work as I wanted but I managed to remove the blank rows with the conditional formatting in the end

I don't know whether you have sorted this yet and this may not be the solution, but looking at the joins you seem to have one too many as you only need 2 joins between 3 tables and you could loose the join product.product_id = orders.product_id. I was told that having too many joins can cause...

I have a report whch I have been using for many months with no problem. I prompt for the relevant customer and save it as an excel file to send to customers. In the excel file I format the page and in the footer I select from the drop down menu the options 'prepared by <my name>". The other day...

Thank you for that suggestion, I hadn't thought of usomg conditional formatting

I have a simple list report which has rows of jobs and corresponding data. Some of the data is many to one and only want to show it if it meets a certain criteria but I cannot work out how to do this. I have tried making all the relevant data null if the criteria is not met but this has led to 6...

I had 2 days training in usng Impromptu and do be honest the training was not very good - I did not get any written handouts at all. Can anyone recommend a user guide?

I am going to add some columns and change some calcualtions. I seem to remember that when I tried that in the past the changes didn't seem to go through to the final report and I had it in my head that you had to eiether rebuild the catalog or do something to make it 'see' the changes? Sorry to...

I have 4 hotfiles which I have used to create a catalogue and then use that catalogue to produce a report, all running with a macro. I have had to do a few changes to the hotfiles and in the past each time I have chaged a hotfile I have had to create a new catalogue and then a new final report...

I had a 2 day course on how to use Impromptu and am now creating my first report. So sorry for the fact that this is a very basic question. The first time I created the report it ran very slowly - ie a very simple report didnt come back with any values for hours and I had to cancel it. I was...