How to access ms access password protected database
How to access password protected database
Thanx for ur answer but it did't solve the prob i am using crystal report 8.0 and ther is no property or method of logoninfo
crReport.LogonInfo(0) i counld not found this property in crystal report 8.0 but there is a method crReport.database.tables(0).setLogonInfo "Servername,uid,pass") but i am using database file driver not oledb or dsn i am using direct database file.
Please help me to solve this prob
thanx in advance
Nazim
Accessing database Field by it's name?
Hello!
I've got a situation here, where I would like to access to a database field by providing it's name. For example, I've got a table containing the 'ItemCode' and quantity columns/fields named after it's branchcode, e.g. '0000'. So the table might looks like this
--------------------------------------------------------
ItemCode 0000 1123 2251 ..........
--------------------------------------------------------
01-12345 5 2 12 ...........
01-32321 1 9 11
Additionally, I have a parameter field called 'CounterCode'. The report should then display all the item codes together with the quantity of the counter code entered by user.
Is it possible to do so? If yes, then how?
Thank you.
Limix
change SQL Server in VB runtime
Hi K.Babu,
I have used CR 9 to create report that uses SQL Server data.
Now I want in VB to change so that I get report for some other database server.
Server: thienloc
Database: payroll
User: sa
Password:
I am beginner for learning report.
Could you give me Connectivity Technology? Detail as possible.
Please give me detail for use LogonInfo?
What pdsoledb.dll? pdssql.dll?
Thnx in advance.
Search in Crystal report 9
Hi, I am currently using CR9 and I hit some problems, just wondering is there anyone out there can help to answer these query?
I created a parameter wif the param name ='myName'
I use the search expert to attempt a search on the following sql
'select * from biodata where name like '%myName%'
I find that I couldn't find any related condition from the drop down condition ...can anybody help to advise on this??
Thanks
Adeline
Shared variable returns 0
Hi,
I'm using Crystal Report 8.5 and i want to shared some variable from sub report to use them in another sub report or main report. The shared variable in my first sub report return correctly but when my other sub report with shared variable is called in the shared variable from the first sub report now return 0. The report is correct when i look to it in Crystal Report. This problem only happen when i preview the report with my application in Visual C++. How can i fix that ?? Please help me !