Results 1 to 5 of 5

Thread: DataSources???

  1. #1

    Thread Starter
    Fanatic Member
    Join Date
    Feb 2000
    Location
    Dunmow,Essex,England
    Posts
    898

    DataSources???

    Hi All,

    I have created a standard web App. I have now intorduced a silverlight project into the solution with the intention of using Silverlight for reporting. The first thing Silverlight wants is a service reference, but I have no service. I simply want to connect to SQL Server and select a particular table as my source.

    How do I place this in a service for silverlight to use? I've downloaded Silverlight 4.

  2. #2
    Lively Member
    Join Date
    Jul 2008
    Location
    UK
    Posts
    101

    Re: DataSources???

    Hello, this is the tutorial that enabled me to understand how Silverlight connects to SQL Server...

    http://www.codeproject.com/KB/silver...3_SQL_WCF.aspx

    Hope this helps
    Regards, John

  3. #3

    Thread Starter
    Fanatic Member
    Join Date
    Feb 2000
    Location
    Dunmow,Essex,England
    Posts
    898

    Re: DataSources???

    Thanks for this. I've since been told by the client that they do not want me to use Silverlight (I'll still check this out for my own benefit).

    the client want me to use the standard reporting features of VS2010. I've started too use the Reporting tools that have and extension rdlc. I've had some success with this in that I am obtaining data into a basic report based on a Stored Proc, However I'm having trouble setting data in a text box as an expression. I'm splitting a single item of data by using the instr functions etc, which work well for data that I can gaurentee is in the string, however I now need to expand on this and test for data that may or may not be in the string and I am struggling to do this in the Expression builder of the taextbox that I have placed on the rdlc designer.

  4. #4
    Lively Member
    Join Date
    Jul 2008
    Location
    UK
    Posts
    101

    Re: DataSources???

    I'm afraid I can't help with VS Reporting Tools, as I don't use them. I normally create Excel files and print from there, sometimes to PDF.
    Regards, John

  5. #5
    ASP.NET Moderator gep13's Avatar
    Join Date
    Nov 2004
    Location
    The Granite City
    Posts
    21,963

    Re: DataSources???

    Bill,

    Can you confirm which technology that you are using for reporting? Perhaps a link?

    I don't think this question belongs in this forum anymore, and I would like to get it moved to the correct one.

    Thanks

    Gary

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