Help needed on reporting

Thread Solved

Join Date: Aug 2008
Posts: 6
Reputation: preethi99 is an unknown quantity at this point 
Solved Threads: 0
preethi99 preethi99 is offline Offline
Newbie Poster

Help needed on reporting

 
0
  #1
Aug 17th, 2008
I need to do reporting in VB6. Can I use Crystal Reports ? My program doesn't get its data from a database. I need to pass simple variables to the report rather than link it to a database. Please enlighten me.
Thanks and regards
Preethi
Reply With Quote Quick reply to this message  
Join Date: Aug 2008
Posts: 304
Reputation: aktharshaik is an unknown quantity at this point 
Solved Threads: 37
aktharshaik's Avatar
aktharshaik aktharshaik is offline Offline
Posting Whiz

Re: Help needed on reporting

 
0
  #2
Aug 17th, 2008
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
Last edited by aktharshaik; Aug 17th, 2008 at 12:06 pm.
Reply With Quote Quick reply to this message  
Join Date: Aug 2008
Posts: 6
Reputation: preethi99 is an unknown quantity at this point 
Solved Threads: 0
preethi99 preethi99 is offline Offline
Newbie Poster

Re: Help needed on reporting

 
0
  #3
Aug 17th, 2008
Hi aktharshaik,
Thanks, I do not want to link a database to the Report. I want to pass variables directly to it.
Reply With Quote Quick reply to this message  
Join Date: Apr 2008
Posts: 1
Reputation: bc070400525 is an unknown quantity at this point 
Solved Threads: 1
bc070400525 bc070400525 is offline Offline
Newbie Poster

Re: Help needed on reporting

 
0
  #4
Aug 17th, 2008
Originally Posted by preethi99 View Post
I need to do reporting in VB6. Can I use Crystal Reports ? My program doesn't get its data from a database. I need to pass simple variables to the report rather than link it to a database. Please enlighten me.
Thanks and regards
Preethi
use visual studio 2008
Reply With Quote Quick reply to this message  
Join Date: Aug 2008
Posts: 304
Reputation: aktharshaik is an unknown quantity at this point 
Solved Threads: 37
aktharshaik's Avatar
aktharshaik aktharshaik is offline Offline
Posting Whiz

Re: Help needed on reporting

 
0
  #5
Aug 17th, 2008
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
Reply With Quote Quick reply to this message  
Join Date: Aug 2008
Posts: 6
Reputation: preethi99 is an unknown quantity at this point 
Solved Threads: 0
preethi99 preethi99 is offline Offline
Newbie Poster

Re: Help needed on reporting

 
0
  #6
Aug 17th, 2008
I will go through the thread you have suggested. I am using crystal reports 9
Regards
Preethi
Reply With Quote Quick reply to this message  
Join Date: Aug 2008
Posts: 6
Reputation: preethi99 is an unknown quantity at this point 
Solved Threads: 0
preethi99 preethi99 is offline Offline
Newbie Poster

Re: Help needed on reporting

 
0
  #7
Aug 18th, 2008
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
Reply With Quote Quick reply to this message  
Join Date: Nov 2007
Posts: 58
Reputation: guest11 is an unknown quantity at this point 
Solved Threads: 2
guest11 guest11 is offline Offline
Junior Poster in Training

Re: Help needed on reporting

 
0
  #8
Aug 18th, 2008
passing variable values is also possible in crystal report. But type of value you want to pass explain using example means what you want to pass report title or what ?
Reply With Quote Quick reply to this message  
Join Date: Aug 2008
Posts: 6
Reputation: preethi99 is an unknown quantity at this point 
Solved Threads: 0
preethi99 preethi99 is offline Offline
Newbie Poster

Re: Help needed on reporting

 
0
  #9
Aug 18th, 2008
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
Reply With Quote Quick reply to this message  
Join Date: Nov 2007
Posts: 58
Reputation: guest11 is an unknown quantity at this point 
Solved Threads: 2
guest11 guest11 is offline Offline
Junior Poster in Training

Re: Help needed on reporting

 
0
  #10
Aug 18th, 2008
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
Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text)
  1. CrystalReport1.Formulas(1) = "aaaa=' " & urVariableValue & "'"
  2. CrystalReport1.ReportFileName=yourCrystalReportPath & yourCrystalReportFileName
  3. CrystalReport1.DiscardSavedData = True
  4. CrystalReport1.Action = 1
  5. CrystalReport1.WindowState = crptMaximized
Reply With Quote Quick reply to this message  
Reply

This thread has been marked solved.
Perhaps start a new thread instead?
Message:



Similar Threads
Other Threads in the Visual Basic 4 / 5 / 6 Forum
Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC