-
February 27th, 2003, 08:25 AM
#286
HI! this is Guru here
i want to convert currency into words for printing varification.
i tried towords function but no use
i wan to convert 422306.50 in to words, it print it as
four hundred twenty two thousand three hundred six and fifty
i want in some other format.
four lakh twenty two thousand three hundred six and fifty
Guru
GuRu
-
February 27th, 2003, 10:12 AM
#287
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
-
February 27th, 2003, 11:55 AM
#288
Hello K.Babu!
I need help with this report. It seems it should be simple, but .....
What I have is 2 tables related by a ProjectID. The project being a building and the database is used to track the development of the building by floors. I need for the report to calculate the total square feet of the bulding, and total square feet in material produced.
The first table is the project details which is broken up by floors (levels).
Code:
ProjectID | Level | TotalSqFt
10001 1 1000
10001 2 1000
The second table is the production details which is broken up by production ID's
Code:
ProductionID | ProjectID | ComponentID | Area
1 10001 401 80
2 10001 402 80
3 10001 402 80
The result of the report should be the following
Code:
Job# | Project Name | Total Sq. Ft. | Total Produced | Remaining
10001 Some Name 2000 240 1760
The problem is that I do not know how to total the values from the 2 tables. I tried grouping but it does not seem to work because there are a different number of records in each table.
Any idea?
Mike B
-
March 1st, 2003, 11:14 AM
#289
Using CR with VS.net
I am relatively new to crystal report. I am using CR 9 with VS.net. I have made a simple CR report on a aspx Webform using CrystalReportViewer and bind the datasource to a mdb through the viewer's properties without much coding. I can view the report on web browser with no problem, however, the data is static. How can I make the data to be real-time? The web server is IIS on Window 2000 server box. The VS.net is on a development machine. I search a lot of places and find nothing about this. I have installed CR 9 advance on the server box. Is there a good book that you can recommended to learn CR.Net?
PM
-
March 2nd, 2003, 02:01 AM
#290
Crystal Report with ASP
I found some problems when I create report (crystal report) on ASP.
Every time I press print icon, it always print another one blank page.
for example: I have 1 page result of report, the printer always return 2 pages for me, one is report detail, another one is blank page
does anybody found this problem, how to solve
i'm very serious about this problem.
thanks in advance.
Last edited by japslam; March 2nd, 2003 at 02:05 AM.
-
March 4th, 2003, 07:56 PM
#291
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
-
March 4th, 2003, 10:05 PM
#292
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.
-
March 5th, 2003, 09:48 PM
#293
Flat File Export
Hi,
I am generating a report (using crystal report 8.5) automatically at a preset timing. The report is fine. All i wanted to do is i want this report to be exported to a flat file (CSV format) automatically. Can this be done? Please help me out.
Thanks.
Siddha
-
March 10th, 2003, 12:44 AM
#294
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
-
March 12th, 2003, 06:05 AM
#295
Help needed urgently
Dear Mr Babu,
I want to know urgently whether Crystal report has all the below listed
functionalities..
Query Capability
Dedicated Module to create Structured Query
Ad-hoc Query
Multidimensional Analysis
Web Enabled Query Capability
Interface with MS Access and MS Excel
Read from these files Capability
Complete Integration of Excel
Storage in other Formats
PDF
BI Metadata
Metadata support
Network And Internet Access
Web Support
Web Module
Central Repository
Zero Administration client
Graphs
Capability to Produce Complex Graphs
Security
LDAP Support
User Management
Report Level Security
Security Modules
Integration
External API Support
OGL interface
Data entry
Maintain user personal database
Scheduling and Distribution
Service
User Specific Capabities - Summary
For Executive Users
Multi Dimensional Analysis
User Interface
Summarizing, Ranking, filtering Etc.
For Reports Users
Quick Report Viewing
Viewing in Other formats
Parameterized Reporting
For Power Users
Developing Reports
Report Distribution
Zero Administration Client
Provision for entry
Provision for data entry
----------------------------
you can even mail me at mzmulla@kanbay.com
-
March 12th, 2003, 07:35 AM
#296
Re: Help needed urgently
Hi,
Crystal Report is a tool for generate reports effectively, It don't have integrated database, you should have to use external database.
Originally posted by gokakian
Dear Mr Babu,
I want to know urgently whether Crystal report has all the below listed
functionalities..
Query Capability
Dedicated Module to create Structured Query
Ad-hoc Query
Multidimensional Analysis
Web Enabled Query Capability
Interface with MS Access and MS Excel
Read from these files Capability
Complete Integration of Excel
Storage in other Formats
PDF
BI Metadata
Metadata support
Network And Internet Access
Web Support
Web Module
Central Repository
Zero Administration client
Graphs
Capability to Produce Complex Graphs
Security
LDAP Support
User Management
Report Level Security
Security Modules
Integration
External API Support
OGL interface
Data entry
Maintain user personal database
Scheduling and Distribution
Service
User Specific Capabities - Summary
For Executive Users
Multi Dimensional Analysis
User Interface
Summarizing, Ranking, filtering Etc.
For Reports Users
Quick Report Viewing
Viewing in Other formats
Parameterized Reporting
For Power Users
Developing Reports
Report Distribution
Zero Administration Client
Provision for entry
Provision for data entry
----------------------------
you can even mail me at mzmulla@kanbay.com
Please avoid sending emails to my personal mail:
write your doubts as thread in Codeguru
Crystal Reports Forum.
This will help all people having similar matters, and will let people who know solutions on the specific topic
share their knowledge.
Visit my company web site (Qmax Test Equipments Private Limited)
Yours friendly,
K.Babu
-
March 12th, 2003, 11:57 PM
#297
Crystal Report
Thank you for your response sir,
My qustion is " I am getting error 'Physical data base not found' when i am running my report where crystal report is not installed.
Now i have found solution.
When i have included "P2smon.dll" to program directory & system32 on client through setup i got solution i am using MS Access, VB.
-
March 14th, 2003, 08:13 AM
#298
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 !
Last edited by Azdjekel; March 14th, 2003 at 08:15 AM.
Sorry for my poor english
-
March 14th, 2003, 01:36 PM
#299
Hello Babu,
Need your help to solve my problem.
I have created tens of programs in VB 6.0 with reports created in Crystal 8.0 using RDC. They are already distributed to multiple sites. Initially I didn't pay attention that exporting doesn't work. Now many clients complaining that they can't export to rpt, exel, and other files. Seagate has a patch for this, but it doesn't resolve this problem. I am looking for a less paintfull way to resolve this problem. I have already Crystal 9.0, but it will require to recompile everything and to reinstall on all computers. This is nightmare.
Babu, do you have any idea how to restore exporting with less trouble and pain? Maybe I can replace some DLLs or something like this?
My executables are on the server, so just to recompile isn't big trouble with the same set of DLLs, the trouble is to reinstall on all machines.
I will really appreatiate you for any good idea.
Thank you.
Victor
-
March 17th, 2003, 05:15 AM
#300
SQL query in CR9
Hi Babu,
I built a CR9 report that obtain from mssql via odbc. Supposedly, the default database should be determined by the odbc. However, I found that the database name is embedded into the sql query. So the report won't work even i change the database setting in odbc unless i update all tables location in
the report. How could i avoid that? I can't update the query as in 8.5 as the update mechanism is different now.
Thx.
Lee Man Kei
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|