New Front End to Reports

Question

New Front End to Reports

DeanORenO

SSC Eights!

Points: 865
More actions
September 14, 2010 at 10:35 am

#229289

I've been asked to create a new front end to our reports that were built using reporting services (SSRS).
the front end is dynamic and changes by report, and it will prompt for the parameters of the report. Help me someone!! I don't even know where to begin developing this front end.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Chris Johnson-445534 SSC Veteran Points: 250 More actions · Answer 1

You're going to have to be more specific about what you need to accomplish. Do you have a set of requirements describing the "front end" that is desired?

Chris

Thanks,

Chris

Newtek Web Hosting

DeanORenO SSC Eights! Points: 865 More actions · Answer 2

Sorry, I'm muddling through this and finding out more as I go along. My company doesn't provide me with full disclosure of requirements up front (frustrating), however, I've never been presented with any deadlines (not frustrating). Thanks for your attempt to help me, I'm given vague requirements and I'm trying to deal with them.

Dave Klug SSCertifiable Points: 5811 More actions · Answer 3

I've built a custom web app in ASP.NET/C# using the SSRS API's, but this is a failry involved process but can be done. The built-in SSRS parameters are pretty limited on what you can do.

DeanORenO SSC Eights! Points: 865 More actions · Answer 4

I'm trying to bind to a ReportViewer object, however I'm not binding a stored procedure but dynamic sql that selects <dynamic columns> from <dynamic views or tables>

nice huh? My boss has fallen in love with the front end on Microsoft Dynamics and issued a task for me to develop the same type of front end to our reports (which he likes to call reports but are really just about a hundred views and tables) he expects me to use the ReportViewer object because he loves this thing (I, myself hate it). I am therefore, forced to try to use ReportViewer with absolutely no developed rdl's since all I have is dynamic sql that runs against views or tables. I'm also developing in C# (my boss's favorite, again not mine). Anyway here is my source as it is:

char[] endlim = { ',' };

String strItem = String.Empty;

String sqlStmt = String.Empty;

int x = 0;

// Setup Connection string

cnstr = "server=serverIP;user=mylogin;password=mypassword;"

+ "database=db;";

// Create a new Sql Connection

SqlConnection cn = new SqlConnection(cnstr);

//Create the DataSet

ds = new DataSet("ds");

sqlStmt = "Select ";

//string querystring = "EmployeeReportViewer.aspx?ViewOrTable=" + ReportList.SelectedValue.ToString();

foreach (ListItem listItem in ColumnListBox.Items)

{

if (listItem.Selected)

{

strItem = listItem.ToString();

sqlStmt += strItem + ", ";

}

sqlStmt = sqlStmt.Trim();

sqlStmt = sqlStmt.TrimEnd(endlim);

sqlStmt += " FROM " + ReportList.SelectedValue.ToString();

SqlDataAdapter da = new SqlDataAdapter(sqlStmt, cn);

// Fill the Data Adapter

da.Fill(ds);

DsRpt = Microsoft.Reporting.WebForms.ReportDataSource();

DsRpt.Name = "Test";

ReportViewer1.LocalReport.DataSources.Clear();

//ReportViewer1.LocalReport.DataSources.Add(ds);

}

How in the h double hockey sticks can I create an RDL on the fly, with no defined columns or ReportDataSource?

Thanks anybody in advance.

Dean

Dave Klug SSCertifiable Points: 5811 More actions · Answer 5

Dave Klug

SSCertifiable

Points: 5811

September 17, 2010 at 11:42 am

#1223227

Have you looked into using ReportBuilder?

DeanORenO SSC Eights! Points: 865 More actions · Answer 6

unfortunately, I can't allow our end users to have access to this type of a tool. it would allow too much access to the database, they wouldn't know how to use it. The goal is to provide a guided method of viewing instances of only particular tables/views, our end users don't know sql querying or anything about that, I'm required to allow dynamic choosing of columns and tables/views with searching parameters on the columns and limit parameters. (see Microsoft Dynamics front-end)