Recent content by lechuz

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?