Adding Related_CI_Name var creates blank report

Open discussion about using Crystal Reports with Alloy Navigator 6

Adding Related_CI_Name var creates blank report

Postby rcs-tech on Wed Apr 27, 2011 5:04 pm

I am trying to edit Incident List to include Related_CI_Name so i can view incidents created in a specific date range by tracked software name.

I edited the following:

\\db expert -> command
UNION
SELECT DISTINCT 'Related_CI_Name.'+IsNull(Related_CI_Name,' No Related_CI_Name') 'Value','Related_CI_Name' 'Group_Name'
FROM Incident_List

\\DynamicField2 -> Select {@ParentGroup}

Case "Related_CI_Name":
{Incident_List.Requester}

\\DynamicField3
Case "Related_CI_Name":
{Incident_List.Status}

\\DynamicGrouping1 -> Select {@ParentGroup}
Case "Related_CI_Name":
If {Incident_List.Related_CI_Name}="" Then "No Related CI Names Found"
Else {Incident_List.Related_CI_Name}

\\DynamicLabel2 -> Select {@ParentGroup}
Case "Related_CI_Name":
UpperCase("Requester")

\\DynamicLabel3 -> Select {@ParentGroup}
Case "Related_CI_Name" :
UpperCase("Status")

The report is able to run without any error but the report apart from the report header is blank. I even created test incident with specific related ci but report is blank.

Thanks :?
rcs-tech
Junior
 
Posts: 8
Joined: Wed Nov 10, 2010 10:56 am

Re: Adding Related_CI_Name var creates blank report

Postby surint on Tue May 03, 2011 10:49 pm

I would check SQL account you trying to run report under. Incident_List view is secured, so account should be registered in the Navigator and has permissions to view Incidents. If account is not in the technician account list then Incident_List view returns no incidents.
surint
Senior
 
Posts: 77
Joined: Fri Mar 01, 2002 8:58 am

Re: Adding Related_CI_Name var creates blank report

Postby rcs-tech on Thu May 05, 2011 6:05 pm

I am using my technician account which has access to incidents list. When i ran the original report w/o modification, it runs and report populates. But when i added the entry, the report does not like being grouped by related ci name.

Trying to make a report that gives all ticket for a date range by tracked sofware name so i used the related ci to pull the names for tracked software list but the report keep returning blanks.

Thanks for the help
rcs-tech
Junior
 
Posts: 8
Joined: Wed Nov 10, 2010 10:56 am

Re: Adding Related_CI_Name var creates blank report

Postby janstonselig on Wed May 11, 2011 10:54 am

I admit I haven't looked through all of what you have here, but could it be because of the joins and the fact that some related_ci fields are blank? Just a quick guess.
User avatar
janstonselig
Senior
 
Posts: 174
Joined: Thu Aug 30, 2007 1:12 pm

Re: Adding Related_CI_Name var creates blank report

Postby rcs-tech on Tue May 17, 2011 5:19 pm

yeah. i thought so too and created some test incident with a valid related ci name for a specified date range which also brought back a blank report.

would you know the permission that i would need to have enabled to give full access to database for report creation by related ci name?
rcs-tech
Junior
 
Posts: 8
Joined: Wed Nov 10, 2010 10:56 am

Re: Adding Related_CI_Name var creates blank report

Postby tccwrd on Fri May 20, 2011 10:23 am

rcs-tech wrote:would you know the permission that i would need to have enabled to give full access to database for report creation by related ci name?


Not sure, but given that sysadmin is the highest permission maybe give that and see if it at least solves the issue. It might not be that.
Gary
User avatar
tccwrd
Senior
 
Posts: 49
Joined: Tue Nov 30, 2010 9:22 am


Return to Report Creation Using Crystal Reports

Who is online

Users browsing this forum: No registered users and 1 guest

cron