September 14, 2010 at 10:35 am
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.
September 15, 2010 at 8:34 am
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
September 15, 2010 at 2:14 pm
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.
September 16, 2010 at 2:18 pm
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.
September 17, 2010 at 11:24 am
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
September 17, 2010 at 11:42 am
Have you looked into using ReportBuilder?
September 17, 2010 at 12:26 pm
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)
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply