| | |
Help needed on reporting
Thread Solved |
Yes surely u can use crystal reports. What is the Database u r using? Is it MS-Access or SQL Server or other. If u r stuck up at any point just post the code at which u r stuck up with. will try to do the needful.
Also can u tell me the version of crystal reports u r using.
Regards
Shaik Akthar
Also can u tell me the version of crystal reports u r using.
Regards
Shaik Akthar
Last edited by aktharshaik; Aug 17th, 2008 at 12:06 pm.
I think u can get some clue from this following thread, please have a look at it and if solves ur need, please post the reputation of the solution to the poster hell_tej.
http://www.daniweb.com/forums/thread140360.html
Let me know if there is something else than this is what u need along with the Backend and Crystal Reports Version u r using.
Regards
Shaik Akthar
http://www.daniweb.com/forums/thread140360.html
Let me know if there is something else than this is what u need along with the Backend and Crystal Reports Version u r using.
Regards
Shaik Akthar
•
•
Join Date: Aug 2008
Posts: 6
Reputation:
Solved Threads: 0
Hi,
The thread is not helpful. I am not particular about using crystal reports. Is there any reporting tool which would allow me to pass variables to the report directly without using a database. Migration to another platform is difficult at this point of time. (Have used C++ Builder in the past and was able to achieve the same using the built in QuickReport Tool)
Thanks and regards
Preethi
The thread is not helpful. I am not particular about using crystal reports. Is there any reporting tool which would allow me to pass variables to the report directly without using a database. Migration to another platform is difficult at this point of time. (Have used C++ Builder in the past and was able to achieve the same using the built in QuickReport Tool)
Thanks and regards
Preethi
•
•
Join Date: Aug 2008
Posts: 6
Reputation:
Solved Threads: 0
Hi Guest11,
Thanks for your reply,
okay, let me explain. The application collects data through the ports and displays it on the screen. These are typically Label Controls whose caption displays the values. We also have certain information entered at the start into text boxes and whose character or numerical values are stored away in appropriate variables. At a point in time the application freezes the screen and we have the option of generating the report. The Headings and other static text on the report is to be set at design time. The values from variables that the text boxes have stored away and that of the label controls displaying on screen have to be passed to the report and the report is to be previewed and printed. Here a database is an overkill and unnecessary overhead as we do not need any of the info to be archived etc.
Therefore if we could pass the variables directly to the reporting tool it would be better.
regards
Preethi
Thanks for your reply,
okay, let me explain. The application collects data through the ports and displays it on the screen. These are typically Label Controls whose caption displays the values. We also have certain information entered at the start into text boxes and whose character or numerical values are stored away in appropriate variables. At a point in time the application freezes the screen and we have the option of generating the report. The Headings and other static text on the report is to be set at design time. The values from variables that the text boxes have stored away and that of the label controls displaying on screen have to be passed to the report and the report is to be previewed and printed. Here a database is an overkill and unnecessary overhead as we do not need any of the info to be archived etc.
Therefore if we could pass the variables directly to the reporting tool it would be better.
regards
Preethi
•
•
Join Date: Nov 2007
Posts: 58
Reputation:
Solved Threads: 2
try this code
first of all make fields in your crystal report by using this steps
1. Open ur Crystal Report using crystal report wizard
2. select insert menu
3. select Field Object from Insert menu
4. Field Explorer window will open
5. In Field Explorer window right click Formula Fields then select New
6. Give to ur field say for example "aaaa"
7. Then Formula Editor window will open close that window
8. Popup window ask for saving changes click yes
9. Then from Field Explorer window double click ur field "aaaa"
10. take mouse out from that window and click in ur crystal report where u want to place ur variable value
11. then through vb coding if u hace button for displaying report then write this code ont button click event ..........
Add Crystal Report Control and Crystal Report Viewer Control form components and add control on ur form
first of all make fields in your crystal report by using this steps
1. Open ur Crystal Report using crystal report wizard
2. select insert menu
3. select Field Object from Insert menu
4. Field Explorer window will open
5. In Field Explorer window right click Formula Fields then select New
6. Give to ur field say for example "aaaa"
7. Then Formula Editor window will open close that window
8. Popup window ask for saving changes click yes
9. Then from Field Explorer window double click ur field "aaaa"
10. take mouse out from that window and click in ur crystal report where u want to place ur variable value
11. then through vb coding if u hace button for displaying report then write this code ont button click event ..........
Add Crystal Report Control and Crystal Report Viewer Control form components and add control on ur form
Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text)
CrystalReport1.Formulas(1) = "aaaa=' " & urVariableValue & "'" CrystalReport1.ReportFileName=yourCrystalReportPath & yourCrystalReportFileName CrystalReport1.DiscardSavedData = True CrystalReport1.Action = 1 CrystalReport1.WindowState = crptMaximized
![]() |
Similar Threads
- FT Junior Java Developer Needed for Major Media firm in NYC (Software Development Job Offers)
- SEO full time needed in Egypt (Internet Marketing Job Offers)
- CPC and SEO junior needed in Greater London (Web Development Job Offers)
- AS400/PKMS Contractor Needed - Ohio (Software Development Job Offers)
- Identifying Drivers needed (Windows 95 / 98 / Me)
- For Kali2005: HackTool.Rootkit - Help Needed (Viruses, Spyware and other Nasties)
- Help needed for project (Java)
- Computer Resetting itself help needed (Viruses, Spyware and other Nasties)
- Aurora Help Badly needed! Thank you! (Viruses, Spyware and other Nasties)
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: retrieve from DB using ADO
- Next Thread: VBA Code
| Thread Tools | Search this Thread |
* 6 429 2007 access activex add age application basic beginner birth bmp calculator cd cells.find click client code college component connection connectionproblemusingvb6usingoledb copy creat ctrl+f data database datareport date delete dissertations dissertationthesis dissertationtopic edit error excel excelmacro file filename form hardware header iamthwee image inboxinvb internetfiledownload keypress label listbox listview liveperson login looping machine microsoft movingranges number objectinsert open oracle password prime program prompt range-objects readfile reading record refresh remotesqlserverdatabase report save search sendbyte sites sort sql sql2008 sqlserver subroutine tags textbox time urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window windows





