Recent content by RohanP

Hi There, I have created an application which show list of files in a listbox eg:- ListBox Values D:\File1.doc D:\File1.xls D:\File1.mdb D:\File1.pdf I want my app to open selected file on click of a button. if user select value 1 then file1.doc should open with its associated program i.e...

Hey Dude, Thankz a thousand times. I had to use simple logic rather that useing next & prev functions. it worked out fine i just had to use sub-report to get the result in the header. Thankz Again ______________________________ - Regards Rohan (India,Mumbai)

Hi There, I have a 3 groups in a report. Group 3 has a Formula (Formula1) returning average of a field based on group 2. eg:- Average({Table.Field},Group3) I want to display the minimum Value returned by Formula1 in Group2's Header. How can I do that? if i write Minimum(Formula1,Group2) it...

Hello Guys I hv a sub report in the detail section of the main report. if there is a duplicate subreport record in the same group the sub report should be invisible. I tried checking the Suppress If Duplicate option of sub report but it dosent work. Pls Help ______________________________ -...

Hi There, I have made a Client/Server App in VB6 & used CR8 for Reporting. Package is installed on 3 client machine whenever there is some change in rpt files I have to replace rpts on all the client machines. Is there a better way of distributing CR Rpt Files? ______________________________...

I am using RDC to display reports frm vb6 I am getting an error on client's PC that Database DLL cannot be found & client is not able to view reports. I have used pdsoledb.dll in my rpt files, as per information I got the dll should be present even on the client machine but I am not able to...

Server Name - Rohan username - sa dbname - exports1 ______________________________ - Regards Rohan (India,Mumbai)

I unchecked the Save Data with Report option but still the report is not refereshing with specified Database. :( is it so difficult to get this solution? ______________________________ - Regards Rohan (India,Mumbai)

I tried this out MsgBox crxDatabaseTable.TestConnectivity) & " " & crxDatabaseTable.Name Every Table is returning True Value I asume that means connectivity is successful. But database is still not changing. But If I pass SqlString to the report object it is working fine. Giving...

I Tried the below code but was not opening Exports1 DB but showing Exports DB's data :(. But When I added this line of code (Report.SQLQueryString = "Select * From Customer") as there is only 1 table in the dummy report, Between code Report.DiscardSavedData and...

I have tried this Report.Database.LogOnServer "pdssql.dll", "Rohan", "Exports1", "sa" 'Use a For Each loop to change the location of each 'DatabaseTable in the Reports DatabaseTable Collection For Each crxDatabaseTable In Report.Database.Tables...

In this example the location property of the DatabaseTable Object for each table in Report is set to MDB File. ****************** For Each crxDatabaseTable In Report.Database.Tables crxDatabaseTable.Location = App.Path & "\xtreme. mdb" Next crxDatabaseTable ****************** I...

How to limit records in the detail section? eg:- Suppose DetailSectionRecords is a property Report.DetailSectionRecords= 10 Only 10 records in detail section per page will be printed. what is the code for doing the same?? pls help its very urgent ______________________________ -...

In this example of Procedure SetTableLocation For the DatabaseTable, Location is set to the MDB File i.e. the access DB, but i want to set the location to Sql Server 7 with the Login Name - sa & Blank Password? object.SetTableLocation "xtreme.mdb", "Customer", "&quot...

Thankzzz all u guys for ur help. :) ______________________________ - Regards Rohan (India,Mumbai)