Recent content by mrpauly

Hi, I have Excel files on the server and is accessed by a webpage with a link. When the user opens the file, it will shows the Excel file that has been cached to the system. So updates to the Excel file will not be shown to the user. How can I prevent this from happening? Thanks Paul Millard

Hi, I need help creating a query that pulls all records from the prior month date. For example, if the report is ran today (Jan 4th) I want all records for December. Thanks, Paul

Thanks Rudy and Swampboogie for your time and efforts. Yeah, the first query worked well. Thanks, Paul

Hello, I'm trying to run the SQL union query and would like to have this merged into one record...Right now, the results are displayed into two records. Eventually, I will be removing the Customer Number where clause to run against all customers. Thanks, Paul select t1.ShipNum as CustNum...

Dave, As always, thanks for your quick and helpful response to my question. You've helped me and others out numerous times and your valuable work does not go unnoticed. Best wishes, Paul

Hi again, I have a query that runs fine until I add fields from another table. What I want is to have one unique record for each tracking number (I work at FedEx) shipment. The problem is one table contains one or more relatated records (same tracking number) in another table. The number of...

There are plenty of examples in this forum if you read. Just do a keyword search like 'vb' or 'visual basic' 'vb export report', etc. If you still need help, email me your specific needs. Also, if you click on Impromptu help under macros you find some good info. Have fun... Paul Here is...

Hi Everyone, I want to run an Impromptu report to retrieve detailed records with (I think) a summary filter. For example, at FedEx we would like to see detailed records for shippers who shipped 100 bills or more during the prior month. How can I do this? I added the fields I wanted then...

Dave, I have these unchecked. For some reason I got it to work once and that is it. I even created a new report, changed the field names, and left uncheck...and it still did not fix. Do you what is causing this not to work?? PS - Thanks for the my prior two posts several weeks ago. I do...

Folks, I have edited the column headers in a report. Saving in PDF will keep modified name however in Excel or CSV will revert back to original (database) column names. Does anyone have a fix or know if this is a bug? Thanks Paul

I've tried in simple list reports to take away the borders around the data. Is there a way to do this? I've tried using format, borders, and none. That does not seem to work. Please look at sample report: ProdPrice Under 165 Thanks-Paul

Hi, I have not found a way to change the filter definition using VB. However, you can change certain parameters by using prompts. This is one method I use. If you do find a way, please share this with us. Too bad Cognos can't find away to do this. This would allow for greater flexibility...

Hello, Using macros, I've automated the process to run about 50 reports passing parameters via prompts. My question is I would like to export to PDF the report only if records are found. Is there a method to verify records exists? Thanks - Paul

Hi Folks, My question is for someone to show me some code or help to use OLE DB, SQL Server and SQL Server Authentication in an ASP. I'm trying to use the asp page with passed parameters to show a report using backend SQL Server. I can get the report to show in design mode. SQL login and...

Folks, My question is for someone to show me some code or help to use OLE DB, SQL Server and SQL Server Authentication in an ASP. I'm trying to use the asp page with passed parameters to show a report using backend SQL Server. I can get the report to show in design mode. SQL login and...