Search results for query: *

Hi! I would like to know if anyone knows how to dinamically change the DSN of my reports, I have my reports running on the RAS, I send them the username, password and the report parameters and they work fine, but they use the DSN saved on the report... I want my user to be able to change the...

Your code it's helpfull, but, you are working with mysql, I'll try to find the same commands for SQL server in wich I am working. Thanks a lot.

Hi! I have an stored procedure that returns to my PHP page a recorset with data. Does anyone have a sample code in how can I fill my combo box with the data in the recordset? I'm a begginer in PHP and I can't find on web a sample code for this... I will appreciate a lot your help

What did I have to do on the RDC to display all the information on a single page? I just don't want pagination on my report. I'm using Crystal Reports 9.

Hi! We are migrating from ASP - SQL Server to PHP - SQL Server on a first stage (later we will change sql server with Postgress SQL). But in ASP we always used Windows Integrated security to access the database and to solve all the security issues in our application. Does anyone knows if it's...

The solution: The problema was that I was using: NewParam.DefaultValues.add NewVal instead of: NewParam.CurrentValues.add NewVal Thanks anyway!!!

Hi I want to pass a formula to my report with the following code... I'm trying to do this similar of sending parameters but I can't find the property or method to use the "current formula" in my report I made the following code to receive parameters for the report: Set NewParam =...

Yes, look at my code there is a line like this: NewParam.DefaultValues.add NewVal Change it for: NewParam.CurrentValues.add NewVal you don't need to specify the parameter prompt option to false after doing this... hope it helps...

Hi! Hi, I'm running Crystal Reports 9 and Report Aplication Server.... I have some html forms that send the parameters to an asp that use the interactiveviewer to display the report... this is working fine, and I can see the report, but when I press the "next page" button, all the...

Check that the property .EnableParameterPrompt of the viewer is never set to "False"

How can I avoid the parameter prompting? I have a report that uses 2 parameters... I made the following code to pass these parameters trough the URL in the "interactiveviewer.asp" and works fine It sends the parameters to the report, but it still prompting me for the parameters (the...

I edited the code to the following: Set NewParam = ObjectFactory.CreateObject("CrystalReports.ParameterField") With clientDoc.DataDefinition.ParameterFields .Item(0).CopyTo NewParam Dim NewVal Dim ValContent ValContent = 1 Set NewVal =...

Some people helped me to edit the "interactiveviewer.asp" to log into the database instead of always prompting for it... now I want to embedd in the code the values for some parameters of my report... I receive a value from a form and now I want to pass it to the report, I received...

Yes I understand that, but in that case, I will have the same report everytime... What I want to do, it's to pass the parameters trough the URL or a Get method or something, then my asp to take this parameters and send them to the report... Look at this code...

Ok, could you explain me also how to pass two parameters to my report? Is that also in this file? I'm not sure where to code them and wich crystal object to use to refer to each of them. Do you have a similar example?

I have my reports running in my ePortfolio and when I access them I have to provide the parameters and the UserID and Password to log into the database. I don't want my users have to do that, Is there a way to simply pass this parameters trough the URL in Crystal 9? How can I run unmanaged...

You need to configure your DNS correctly to NOT use the NT authentication. I suggest you to create a new dns to your database that uses SQL server authentication (or whatever your server is), and disable the integrated security. Then point your reports to this new DNS. Also, your server has to...

Thanks to Naith I finally got the solution. ePortfolio does not work with windows Authentication to log into the SQL Server and my DNS was configured to use that Authentication. I have created new DNS with SQL server authentication, and then pointed my reports to that new DNS and now I can log...

Mmmm... I'm a kind of new on this... wich is the Crystal Management Console? how can I run that on Crystal 9? I'm working on the Crystal Reports 9 Advanced Edition, but it's the trial version (because I dont wan't to buy the license before knowing if it's going to work) and the only access that...

I was thinking the same Naith, but unfortunately I have the web server, the RAS server and Crystal Reports running on the same machine... I'm starting to think that maybe It's something related to the authentication to the SQL Server from web, maybe it's configured to allow only NT...