Results 1 to 9 of 9

Thread: Runtime design of report in crystal reports 8.0

  1. #1

    Thread Starter
    Hyperactive Member shirishdawane's Avatar
    Join Date
    Dec 2004
    Location
    Mumbai,India
    Posts
    363

    Exclamation Runtime design of report in crystal reports 8.0

    Hello All,

    I want to change design of report through VB, I mean to say how can I change any textbox location to other location within same report only?
    My problem is that we have more than 50 reports & if any customer wants to change location of textbox to other location within same report then he not able to do that & for that small reason support engineer have to visit him for minor change in report.
    So saving time as well as man power, can we provide such interface where user can do minor changes in report ?
    Any ideas are appreciated...thanx.......
    On Error GoTo http://www.vbforums.com

    Note :
    1) Please use [vbcode]your code goes in here [/vbcode] tags when posting VB code.
    2) Please mark thread as Resolved using the Thread Tools menu, if you got solution.

  2. #2
    Frenzied Member
    Join Date
    May 2003
    Location
    Sydney
    Posts
    1,123

    Re: Runtime design of report in crystal reports 8.0

    text1.top=somevalue
    text1.left=someothervalue

  3. #3

    Thread Starter
    Hyperactive Member shirishdawane's Avatar
    Join Date
    Dec 2004
    Location
    Mumbai,India
    Posts
    363

    Exclamation Re: Runtime design of report in crystal reports 8.0

    sorry,

    U did not get me. I want to open crystal reports 8.0 reports through VB for runtime design changes by user, but just for minor changes.....
    On Error GoTo http://www.vbforums.com

    Note :
    1) Please use [vbcode]your code goes in here [/vbcode] tags when posting VB code.
    2) Please mark thread as Resolved using the Thread Tools menu, if you got solution.

  4. #4
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: Runtime design of report in crystal reports 8.0

    Moved to reporting section.

  5. #5

    Thread Starter
    Hyperactive Member shirishdawane's Avatar
    Join Date
    Dec 2004
    Location
    Mumbai,India
    Posts
    363

    Re: Runtime design of report in crystal reports 8.0

    Hi Hack,

    Actually I was supposed to post this thread In reporting section but this is link of Vb & Crystal reports therefore I did it in visual basic section... any ways thanx for moving it in reporting section but plz giev me satisfactory answer if it exists......
    On Error GoTo http://www.vbforums.com

    Note :
    1) Please use [vbcode]your code goes in here [/vbcode] tags when posting VB code.
    2) Please mark thread as Resolved using the Thread Tools menu, if you got solution.

  6. #6

    Thread Starter
    Hyperactive Member shirishdawane's Avatar
    Join Date
    Dec 2004
    Location
    Mumbai,India
    Posts
    363

    Re: Runtime design of report in crystal reports 8.0

    Hi,

    can u plz visit this link to get what I am saying :

    http://support.businessobjects.com/library/kbase/articles/c2007290.asp
    On Error GoTo http://www.vbforums.com

    Note :
    1) Please use [vbcode]your code goes in here [/vbcode] tags when posting VB code.
    2) Please mark thread as Resolved using the Thread Tools menu, if you got solution.

  7. #7
    Frenzied Member pnish's Avatar
    Join Date
    Aug 2002
    Location
    Tassie, Oz
    Posts
    1,918

    Re: Runtime design of report in crystal reports 8.0

    I may be wrong, but I don't think you can provide this sort of functionality without purchasing runtime licenses for each user of your application.
    Pete

    No trees were harmed in the making of this post, however a large number of electrons were greatly inconvenienced.

  8. #8
    Ex-Super Mod RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,709

    Re: Runtime design of report in crystal reports 8.0

    You are correct pnish. You need to purchase a single license for each and every instance of your program. So if you want to give this functionality to 10 users using your app then you need to buy 10 licenses.

    The logic is that why would they want to buy other copies of CR if you can create a program and redistribute it thus eliminating the need for the designer.
    VB/Office Guru™ (AKA: Gangsta Yoda®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (C#, VB.NET, VB 6, VBA)
    Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    Reps & Rating PostsVS.NET on Vista Multiple .NET Framework Versions Office Primary Interop AssembliesVB/Office Guru™ Word SpellChecker™.NETVB/Office Guru™ Word SpellChecker™ VB6VB.NET Attributes Ex.Outlook Global Address ListAPI Viewer utility.NET API Viewer Utility
    System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6

  9. #9
    PowerPoster
    Join Date
    Oct 2002
    Location
    British Columbia
    Posts
    9,758

    Re: Runtime design of report in crystal reports 8.0

    If you have the Developer Edition, you are allowed to use certain properties and methods of the CRAXDRT (and distribute the dlls) without purchasing another license. Basically, you can modify existing report objects via properties such as left, top etc. but cannot create reports or add/delete objects onto existing reports.

    Check out the License.hlp file found in your installation folder for further information. It contains a list of properties and methods that can be use "Royalty Free" and those that require an additional license.

    Here is some code to change the Left and Top property. Sorry, I don't have version 8 but 8.5 so not sure if this will work for you.

    VB Code:
    1. Option Explicit
    2. Private objCrystalApp As CRAXDRT.Application
    3.  
    4. Private Sub Command1_Click()
    5.     Dim objReport As CRAXDRT.Report
    6.     Dim objField As CRAXDRT.FieldObject
    7.     Dim objSection As CRAXDRT.Section
    8.    
    9.     Set objReport = objCrystalApp.OpenReport("M:\testing\report1.rpt")
    10.  
    11.     Set objSection = objReport.Sections("Section5") 'details section
    12.     Set objField = objSection.ReportObjects("Field2")
    13.     objField.Left = objField.Left + 2000
    14.     objField.Top = objField.Top + objField.Height
    15.  
    16.     CRViewer1.ReportSource = objReport
    17.     CRViewer1.ViewReport
    18.    
    19. End Sub
    20.  
    21. Private Sub Form_Load()
    22.     Set objCrystalApp = New CRAXDRT.Application
    23. End Sub
    24.  
    25. Private Sub Form_Unload(Cancel As Integer)
    26.     Set objCrystalApp = Nothing
    27. End Sub

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width