Recent content by mickyd

Does anyone know how the licensing for Crystal Reports works when users are running it on the web? Is it controlled through the activeX object used to view the reports?

Does anyone know how to specify the file name to be embedded into an ole object? I am currently working on a report that retrieves by id and by date. The files to be displayed in the ole objects will depend on the id that is passed. I need to embed both an excel file and a picture file in...

I forgot to add that I also need to know where to find the following codes: U2FWORDW U2FRTF U2FXLS U2FCR Any ideas? I need the code for ADOBE Acrobat here as well. I looked in my help files in Crystal reports, and in MSDN library for this and the other codes but was unable to find them. Even...

I wasn't able to find it. Do you happen to know the code for ADOBE ACROBAT?

IN THE RPTSERVER FILE PROVIDED BY CRYSTAL DECISIONS, THE TYPE OF APPLICATION TO EXPORT TO CAN BE SPECIFIED IN CODE. I.E WORDFORWINDOWS HAS THE EXPORT FORMAT NUMBER OF 14. DOES ANYONE KNOE WHERE I CAN FIND A LIST OF EXPORT FORMAT VALUES?

Are you using a DSN to connect to your database? If so, when you create a new report and click on the database button, select the ODBC option. There is a button here which is called "options". Click on the check box beside stored procedures. This will allow you to view the stored...

When I design my reports in Crystal Designer on my computer, I have the date format: yyyy-mm-dd and it works fine on my computer. However, when I view these reports on the web, the date shows as: m/d/yyyy. We know that CR takes the system default short date and we have checked to make sure...

good idea. I'll give it a try. Thanks for the help!

I don't know if it will be that easy. the parameters that can be null are not actual fields in my report. Rather, they are retrieval arguements in the stored procedure. I can either retrieve data based on a specific report number or by a range of report numbers. If the report number passed...

The parameters automatically come in from my stored procedure. I did set the default to null and I'm trying to pass parameters through a link. http://servername/reports/Incident_Report.rpt?prompt0=800,prompt1=0,prompt2=0' I want to pass the values through the link so that the user is not...

I have several parameters for one report which can be null. I have been unable to pass null parameters across the web. How can I do this?

I used the following to convert my fieldname to a phone number format Left (CStr(fieldname or variable),3 )&"-"&Right(CStr(fieldname or variable), 4) fieldname or variable- name of the field from the table or variable that holds the number to format. Left- takes the first three...

I have a system DSN on my machine for developing reports and connecting to my SQL Server database. I have used a stored procedure, which can accept 3 numeric parameters but requires only one to work, to develop my report. As I was developing the report, I was able to preview the report with...

When I open go to http://servername/CrystalReportsEval/, then click on the report, it opens fine. But, when I go to http://websitename/reports, then click on the report, it tries to download the file rather than running it inside the browser. Also, if I go to...

I wish I had some advice to give but, instead I have a question. Before you set Crystal Reports to run under an administrative account, what was the error you were getting? Was it "An Error has occured on the server in attempting to access the data source"? This is the error I have...