Report Portal

ReportPortal
ReportPortal
Home | Profile | Register | Active Topics | Members | Search | FAQ
 All Forums
 ReportPortal General Forum
 Report Portal General Issues
 Cell Comment

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Anti-Spam Code:
Message:

* HTML is ON
* Forum Code is OFF
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
nm8201 Posted - 09/28/2010 : 12:40:16
The cell comment feature is failing if the dimension text contains an embedded quote.

TIA Ron
3   L A T E S T    R E P L I E S    (Newest First)
admin Posted - 10/01/2010 : 11:04:10
This bug will be field in the next build 172. To get an immediate hot fix please contact support@ReportPortal.com.
nm8201 Posted - 09/29/2010 : 17:43:34
This is what appears in the comment dialog box. The dimension contains a single quote.

GetComment() - Unclosed quotation mark after the character string ''.
Incorrect syntax near 's'.; SQL: SELECT Comment FROM ReportComment WHERE ReportId = '344' AND Tupple like '![PendCodes!].![Pend Flag!].&![Pends!], ![PendCodes!].![Pend Descr!].![All!],
![PendCodes!].![Pend Descr!].&![Auth is New; Refer to Med Services!],
![PendCodes!].![Pend Descr!].&![By Report!],
![PendCodes!].![Pend Descr!].&![Default Benefit - Hold for Configuration!],
![PendCodes!].![Pend Descr!].&![Electronic Claim; review!],
![PendCodes!].![Pend Descr!].&![Hold for examiners review!],
![PendCodes!].![Pend Descr!].&![Hold for Supervisor review!],
![PendCodes!].![Pend Descr!].&![Medical Director's Review!],
![PendCodes!].![Pend Descr!].&![Medical Records needed for review!],
![PendCodes!].![Pend Descr!].&![Not authorized to Approve based on user's approval limit!],
![PendCodes!].![Pend Descr!].&![Pend EDI- Claim Detail Line Issue!],
![PendCodes!].![Pend Descr!].&![Pend EDI- Claim Header Issue!],
![PendCodes!].![Pend Descr!].&![Pend EDI- Member Issue!],
![PendCodes!].![Pend Descr!].&![Pend EDI- Prov Hospital Matching Issue!],
![PendCodes!].![Pend Descr!].&![Pend for Checkrun processing!],
![PendCodes!].![Pend Descr!].&![Provider Ineligible!],
![PendCodes!].![Pend Descr!].&![Provider Pend!],
![PendCodes!].![Pend Descr!].&![Referral or Authorization not on file for these services!],
![PendCodes!].![Pend Descr!].&![Referred to CCS, poss eligibility!],
![PendCodes!].![Pend Descr!].&![Visits or Days Exceed Referral/Auth Visits or Days!], ![ClaimType!].![ClaimType!].![All!], ![LOB!].![LOB Xpress!].![All!], ![PendCodes!].![Pend Code Descr!].![All!], ![RunDate!].![Date Name!].&![2010/09/18!], ![Measures!].![Total Claims!]' ESCAPE '!'


Comments











style="font:menu" bgcolor=buttonface>








Comments




style="PADDING-LEFT: 20px;PADDING-RIGHT: 20px;PADDING-TOP: 4px">







 

 

 






admin Posted - 09/29/2010 : 08:37:02
Is it a single or double quote?
What error to you receive?

Please try to reproduce it on the demo server: http://www.reportportal.us/reportportal
My Reports > Bar/Line Chart 3D

ReportPortal © 2000-2002 Snitz Communications Go To Top Of Page