• Replies 5 replies
  • Subscribers 338 subscribers
  • Views 94 views
  • Users 0 members are here
Related

SSRS report unable to create tessitura list

Michael Sampson
$organization

We are attempting to "save as list" from a SSRS report and get this message in red "Cannot create list as report doesn't have any data to be saved"

Any ideas what step did we missed when creating this report ?

Thanks

Michael

Parents
  • $organization

    Check the DataElement properties for the text field in the report.  There are three to inspect:

     

    DataElementName – if this is blank, it assumes the name of the object itself (could this be named “textbox_34” or something?)

    DataElementOutput – Try changing this to Output instead of Auto

    DataElementStyle – Try changing this to Element instead of Auto

     

    If you save the output of the report in question to XML you can see what the WebReports app is trying to inspect.  The save to list feature works with attributes or elements named:

    ConstituentId

    Constituent_Id

    CustomerNo

    Customer_No

     

    The names are case-insensitive.

     

    +Ryan Creps

    +Tessitura Network

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Michael Sampson
    Sent: Tuesday, August 07, 2012 3:53 PM
    To: Ryan Creps
    Subject: RE: [Tessitura Technical Forum] SSRS report unable to create tessitura list

     

    Thanks for the response, we definitely have Customer_no in there….

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Jared Mollenkopf
    Sent: Tuesday, August 07, 2012 3:27 PM
    To: Michael Sampson
    Subject: Re: [Tessitura Technical Forum] SSRS report unable to create tessitura list

     

    Hi Michael,

    The first thing to check is that the output data set contains a field named "customer_no" .

    Jared

    From: Michael Sampson <bounce-michaelsampson5116@tessituranetwork.com>
    Sent: 8/7/2012 12:53:32 PM

    We are attempting to "save as list" from a SSRS report and get this message in red "Cannot create list as report doesn't have any data to be saved"

    Any ideas what step did we missed when creating this report ?

    Thanks

    Michael




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Reply
  • $organization

    Check the DataElement properties for the text field in the report.  There are three to inspect:

     

    DataElementName – if this is blank, it assumes the name of the object itself (could this be named “textbox_34” or something?)

    DataElementOutput – Try changing this to Output instead of Auto

    DataElementStyle – Try changing this to Element instead of Auto

     

    If you save the output of the report in question to XML you can see what the WebReports app is trying to inspect.  The save to list feature works with attributes or elements named:

    ConstituentId

    Constituent_Id

    CustomerNo

    Customer_No

     

    The names are case-insensitive.

     

    +Ryan Creps

    +Tessitura Network

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Michael Sampson
    Sent: Tuesday, August 07, 2012 3:53 PM
    To: Ryan Creps
    Subject: RE: [Tessitura Technical Forum] SSRS report unable to create tessitura list

     

    Thanks for the response, we definitely have Customer_no in there….

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Jared Mollenkopf
    Sent: Tuesday, August 07, 2012 3:27 PM
    To: Michael Sampson
    Subject: Re: [Tessitura Technical Forum] SSRS report unable to create tessitura list

     

    Hi Michael,

    The first thing to check is that the output data set contains a field named "customer_no" .

    Jared

    From: Michael Sampson <bounce-michaelsampson5116@tessituranetwork.com>
    Sent: 8/7/2012 12:53:32 PM

    We are attempting to "save as list" from a SSRS report and get this message in red "Cannot create list as report doesn't have any data to be saved"

    Any ideas what step did we missed when creating this report ?

    Thanks

    Michael




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Children
No Data