Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mrpauly

    Cache Excel Files

    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
  2. mrpauly

    SQL Query: Prior Month Date

    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
  3. mrpauly

    SQL Union Query Help

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

    SQL Union Query Help

    ...Eventually, I will be removing the Customer Number where clause to run against all customers. Thanks, Paul select t1.ShipNum as CustNum, Count(*) as Shipments, Sum(t1.Rev) as Revenue, Sum(t1.AdjCost) as AdjCost from tblRawAccess as t1 where t1.ShipNum = 'KKL2712SKM' and t1.FbType = 'P'...
  5. mrpauly

    Another Impromptu Query

    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
  6. mrpauly

    Another Impromptu Query

    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...
  7. mrpauly

    How to run an Impromptu report into VB

    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...
  8. mrpauly

    Impromptu Report Query

    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...
  9. mrpauly

    Impromptu edit column headers error when saving

    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...
  10. mrpauly

    Impromptu edit column headers error when saving

    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
  11. mrpauly

    Impromptu: Change Border to None

    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
  12. mrpauly

    Filter Definition on Impromptu Reports using VB

    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...
  13. mrpauly

    Running Macro - Verify records exists

    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
  14. mrpauly

    Using ASP, OLE DB and SQL Server

    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...
  15. mrpauly

    ASP Connect SQL Server using OLE DB

    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...
  16. mrpauly

    Enable Export Button on Distributed Application

    Hi Folks, I am currently using CR 8.5 Dev. I am building a vb application that will distributed to several other computers. Not with CR installed. How can I get the Export button to work on other machine? Is there a missing .dll file? If so, can this file be packaged up in the application...
  17. mrpauly

    Crystal Web Hosting

    Anyone know where to find Crystal Reports web hosting at a reasonable price? Looking at connecting to ms access or sql server. Primarily use is for small scale development. Paul
  18. mrpauly

    Newbie Question - Crystal Viewer

    Folks, If anyone can please help me out I would appreciate it. I'm having trouble viewing a crystal report on my machine without the software? I have the software at home but I would like to send the report to work and view but my existing machine does not have crystal installed. Is there a...
  19. mrpauly

    Newbie Viewer Question

    Folks, If anyone can please help me out I would appreciate it. I'm having trouble viewing a crystal report on my machine without the software? I have the software at home but I would like to send the report to work and view but my existing machine does not have crystal installed. Is there a...
  20. mrpauly

    upgrade to Crystal Reports 8.5?

    Hey Folks, What are the advantages for upgrading from 8.0 to 8.5 and is it worth it? If you are a current user of 8.5, please give me your opinion. Paul

Part and Inventory Search

Back
Top