SSRS Dataset Not Binding To Table

Posted on 2011-10-25
Last Modified: 2012-06-27

I have a dataset created on a custom report that I am doing against an Oracle database, when I open the dataset and click on "!" to run the dataset I am prompted for parameter values...

Dataset Prompt.
..after supplying the values and clicking on "Ok" values are returned so the dataset is working correctly...

Dataset Results.
...however when I switch to layout view and drag an table control to the surface and set it's properties to point to the dataset shown above & bind the docnum field to the table...

 Table Properties.
...when running the report from the preview and supplying the same values as I did when I ran the dataset above...

Preview Report.
...nothing gets returned. Am I doing something wrong?

Thank you,
Question by:SpaceLaika
    LVL 3

    Accepted Solution

    It can be due to error converting the dates.

    Check that the format on server is equal to the one on the SSRS-SERVER.

    Try hardcoding the dates in the dataset, and see if it works..

    Author Closing Comment

    Thank you!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    How to increase the row limit in Jasper Server.
    Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
    This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
    This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now