9 Replies Latest reply on Aug 8, 2014 11:38 AM by bialae

    How to add information to IncidentManagement.Incident.rpt"

    bialae Apprentice

       

      Dear LANDesk Community,

       

      I am desperately in need of your help, I contacted Support two weeks ago but I haven’t heard from any of them. My problem is that I am working to add information on the “IncidentManagement.Incident.rpt”. One of the information I needed to add is Software Type. I tried every attribute that has a name “Software…” but every one of them is blank.

         

       

      Then I saw the Table named usr_softwareversions. I browse the attribute usr_title and it contains the information that I needed on the report. Therefore, using the Database Expert, I added it.

         

       

       

      When I tried it, after I clicked , it returns an error which says that it cannot retrieve data because of some link problem (I did not capture the error because it is very lengthy).

       

      Please would someone kindly help me please and thank you so very much.

      Gratefully,

      Ernesto

       

        • 1. Re: How to add information to IncidentManagement.Incident.rpt"
          ProServices

          Ernesto,

           

          Please check if you have Automatic Smart linking turned on in your Crystal Reports client.  Im not 100% but the way those tables appeared to be linked in your screenshot makes me think that the setting is turned on.  If it is it will probably make your joins incorrect and your report will malfunction.  Please check and if it is turned on, please turn that option off.

           

          Then you'll need to double check the linking on that report.

          • 2. Re: How to add information to IncidentManagement.Incident.rpt"
            bialae Apprentice

            Hi SBW,

            I really appreciate your reply. Let find that option where to turn if off. I think it is on because I am seeing this right now:

            Thank you so very much. I shall let you know when I manage to turn it off. Thank you again.

            Gratefully,

            Ernesto

            • 3. Re: How to add information to IncidentManagement.Incident.rpt"
              bialae Apprentice

              Hi SBW,

              I managed to turn it off. I found it under File -> Options -> Databse (Tab) -> Advanced Options.

              I unchecked the Automatic Smart Linking.

              I will add that table again and test. I shall let you know.

              Thank you so very much.

              Gratefully,

              Ernesto

              • 4. Re: How to add information to IncidentManagement.Incident.rpt"
                bialae Apprentice

                Hi SBW,

                I am still getting this:

                Please let me know if you have further suggestions I can try.

                Thank you so very much.

                Gratefully,

                Ernesto

                • 5. Re: How to add information to IncidentManagement.Incident.rpt"
                  ITSMMVPGroup

                  You need to run the CrystalDSN setter against that report so it knows where to pick data up from.  I'd also make sure it works in crystal as well. II would have thought that item you need to use is the one marked usr_softwaretypes, not version.  If that is correct, you'll need to add the relationship from that attribute to the user table.  I'd use a left outer join type of link

                  • 6. Re: How to add information to IncidentManagement.Incident.rpt"
                    Expert

                    Hi

                     

                    I would also check that you have not got smart linking on.  Looking at the small picture it is hard to tell.

                    For information about smart linking please see the following.

                    https://community.landesk.com/support/docs/DOC-4063

                    https://community.landesk.com/support/docs/DOC-3853

                     

                    If this is turned on and you edit a report then it will try and link more tables and attributes then what is needed and this can cause the report to fail as some or many of the new links are the wrong join type.

                     

                    if it is on then that report would take a long time to correct, and it would be better to turn it off in crystal and then go to a backup of the original report and then make the changes you need.

                     

                    Thanks

                    Paul

                    • 7. Re: How to add information to IncidentManagement.Incident.rpt"
                      Expert

                      Sorry I just noticed you have turned it off, but if you have edited the report with the smart linking on then the damage may already be done.

                       

                      and from the previous post "if it is on then that report would take a long time to correct, and it would be better to turn it off in crystal and then go to a backup of the original report and then make the changes you need."

                      • 8. Re: How to add information to IncidentManagement.Incident.rpt"
                        Expert

                        When I work with reports and need to add a table that wasn't there before I use Microsoft Access to test the linking to see what shows up.  It's real easy to link a table incorrectly and get nothing as your originally saw.  Everything above is true and helps but when you get past all that if your data is linked wrong, you get blank data.  I like using Access to see how data links.  Most of the database is fairly intuitive once you see how it's laid out and get a feel for it.  But still, things don't always work as intended.  So I add the tables to Access via ODBC and then link and preview.  It's amazing how fast you can change and test things.  SQL does the same thing but joins take more brain work and it's slower.  Just a few seconds to change a query and test it.  When you see the correct data, you win.  Then you look at the SQL view of the query to see how it linked everything together.  That helps a lot for using other report writers like SSRS.

                        • 9. Re: How to add information to IncidentManagement.Incident.rpt"
                          bialae Apprentice

                          Thank you all so very much!!! I removed all the tables and added them one by one and did every one of your advise and I am not able to see data into the report. I am just trying to figure out why when I create a regular query on the Incidents there is an attribute with relationship called 'Workstation [usr_workstation]' and I can see the asset tag by the attribute 'Title [cf_title]'. However in my Crystal Report design, I can also see a table called 'usr_worstation' but there are less number of attributes (fields) and the attribute 'Title' is not there. I am really sure where to find all these.

                           

                          THANK YOU ALL SO VERY MUCH!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! YOU ARE ALL SO KIND!!!