Using more data sets in Report Server from one stored procedure

Question

I am deploying a lot of report lately. And so to I kept code and version clear and understanding, Ill like to have one stored procedure per report. Mostly time I need more data sets for one reports. Is there possibility to I have more then one data set in report SSRS for calling only one stored procedure for that report. (I am using remote reports hosted on Sql Report Server 2008 ).

I uses familiar Issue whit sample console application for creating multiple CSV files from SQL using one stored procedure. snipes of code looks something like this:

        SqlConnection conn = new SqlConnection(strConn); 
        SqlCommand command = new SqlCommand("sp_ado_pos_data", conn);
        command.CommandType = CommandType.StoredProcedure;
        command.Parameters.Add("@skl_id", SqlDbType.Int).Value = 158;
        SqlDataAdapter adapter = new SqlDataAdapter(command);
        DataSet ds = new DataSet();
        adapter.Fill(ds);
        for (int i = 0; i < ds.Tables.Count; i++)
        {
            string datoteka  = (string.Format(@"{0}tablea{1}.csv", direktorij, i));
            DataTable tabela = ds.Tables[i];  
            //Here I fill datasets with multiple results from one stored proc.
            CreateCSVFile(tabela,datoteka );
            Console.WriteLine("Generišem tabelu {0}", datoteka);
        }

Ed Harper · Accepted Answer · 2009-04-17 12:03:31Z

1

It appears that this isn't possible with standard reports presented through the default report viewer - SSRS ignores all but the first result set from a multi result-set source.

However, based on this article, it appears that it is be possible in stand-alone reports (.rdlc extension). I'm not sure whether this means that, with a custom report viewer, standard .rdl reports could be configured in a similar way.

answered Apr 17, 2009 at 12:03

Ed Harper

21.6k5 gold badges60 silver badges85 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Using more data sets in Report Server from one stored procedure

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related