Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

Hi folks, Newbie using Crystal 8 at home on local machine. After creating the report I would like to close down Crystal editor and open (view) .rpt in actual viewer rather than re-opening the Crystal design editor. How can I open .rpt in viewer and please let me know if I'm missing any...

Hello, I am a beginner at Crystal Reports. I would like to publish reports to the web using web hosting company. Can someone give me advice such as can it be done and does the provider need the software, can you use a connection string to connect to db, etc. I would like login/password...

Hello, I am a beginner at Crystal Reports. I would like to publish reports to the web using web hosting company. Can someone give me advice such as can it be done and does the provider need the software, can you use a connection string to connect to db, etc. I would like login/password...