C# - How To Create Own Reporting Controls With .net Framework
Apr 15, 2010
I want to create fast loading reports like ActiveReports or DevExpress but the problem is I don't know where to start. Also I want it to be light and take less space in setup file.
Does anybody tried to do this? Can I write this component with .net?
I have a requirement to create a XML file from sql server data.I need to schedule this job to run at specific intervals of time.I don't know, if I could do with Reporting services.I would like to know, if it's possible with Sql server reporting services? how to do that.
I can't to understand clearly how to create strong and quickly application using EF. For example, I have class ForumPost (table ForumPost) for select one of record I write method like:
public ForumPost ForumPost(int ForumPostID) { return (from i in _dataContext.ForumPostSet where i.ForumPostID == ForumPostID select i).First(); }
all works. But on page (I use ASP.NET MVC) I should display info from another linked tables, ForumName (each post have ForumID) etc. So, I modify this method to:
public ForumPost ForumPost(int ForumPostID) { return (from i in _dataContext.ForumPostSet .Include("ChildPosts").Include("ParentPost").Include("Users").Include("Forums").Include("Tags").Include("ForumPostPolls") where i.ForumPostID == ForumPostID select i).First(); }
ok, all works. Then I want to make some actions in model with ForumPost, i.e.
public void RootPost(int PostID, ref Models.ForumPost Root) { ForumPost post = ForumPost(PostID); if (post.RootPost != null) { Root = ForumPost(post.RootPost.ForumPostID); } else Root = post; }
it works too. But problem is in speed. I not need in RootPost all those includes. So, I should to create one more method like:
private ForumPost ForumPostIncludes1(int ForumPostID) { return (from i in _dataContext.ForumPostSet .Include("ChildPosts") where i.ForumPostID == ForumPostID select i).First(); }
then ForumPostIncludes2, ForumPostIncludes3 etc... second way - redesign RootPost with LINQ expr, not with call another method. But in this way difficulties to change DB. third way? How to do it correctly?
I,am trying to create a self association relation for an organization chart data tree in Entity Framework,after trying different ways for prevention of exceptions like 3007 and etc. I found that when I put my foreign key in my POCO near Parent and Items navigation properties its work.but I think this is not correct that we have both ParentID scalar property and Parent navigation property. review this and tell me is it correct or not.I'm using VS 2010 RC and ofcource .net framework 4.0 RC
How do I create a .net framework 2.0 website in Visual Web Developer Express Edition? The only option I get when trying to create a new website is for it to be .net version 3.5.
I need to create chat application in asp.net.But I don't need to store chat messages in database. Only I retrieve user list from database. I have to create group chat also. I have to show list users but online user's image in green color offline user image in red color for differentiating people.
I like to create a desktop widget framework using asp.net. its like yahoo widget or google widget any one able to create a simple widget application and plug in to this framework. how to develop this framework?
I am working in framework 2.0 and currently I am using two SliderExtenders to select the minimum and maximum values. Are their any way to make a single control with two handles, just like MultiHandleSlider.
I am very new to dotnetnuke. and want to know. steps to create and build a webapplication in dotnetnuke.how can we add module using dotnetnuke.how can we handle database in sqlsever 2005 or later on it.
Are there any patterns in 3.5 or rules of thumb? The widget is supposed to be multi paged (registration). Is it possible to POST data back to parent page? Do parent and child (widget) share the same session variables?
I'm staring to learn T4 .I want to create a framework for my self that enable me to generate DAL and UI.Like Code generator softwares that maps Codes and User Interface from database .i don't have any question about generating data access layer.my challenge is to generate UI ( asp.net controls and HTML)
I need to create stored procedure to use it for multi value parameter.. I createdd new data set and changed the type to stored procedure but how can I write my select statement in it?
I would like to know how to build interactive dashboards using sql server reporting services. I am using the .rdl reports where I can generate a static gauge report but I want my user to interact with gauge at runtime to see its effects .I hope am making myself clear.
I am new to MDX and Sql Server Analysis Service and I've searched this high and low and read a lot of articles, but cannot figure out how.I know this is tough after reading so many articles online, and thus I am only trying my slim chance of getting something helpful from here. I need to create a sales report and want to parameterize the region, so, I'd like to have something likeSELECT blah blahFROM [MySsasWarehouse]WHERE @regionThe @region may take values such as [USA].[Northeast].[New Hampshire], for example.How do I make this happen with MDX? I learned that I can doSELECT blah blahFROM [MySsasWarehouse]WHERE STRTOMEMBER('[USA].[Northeast].[New Hampshire]')But, I have no idea how to have something like STRTOMEMBER(@region)and to be able to pass values to that @region variable.
In the end I would like to create a SSRS report using this MDX query and pass different values to @region. Do NOT point me to articles about how to pass parameters to SSRS, because I know how to do it through the URL query string.My question is How to create parameters for MDX query per se, and I haven't been successful in attempting to do so.
I would like to create the dynamic ServerReport, thru which end users can select the required fields according to the required conditions.The required fields and conditions has to be decided in ASP. NET page(aspx. cs)
I need to create a subscription for my SSRS reports in an asp.net page.I can show the reports in a reportviewer using Reporting.WebForms. SSRS is on the another computer in my network. For reportviewer, I use "admin" and "pass" for credentials which is the SSRS machine's admin username and password and it's ok. And admin has all the roles for SSRS reports. But when I try to createSubscription via ReportingService2006 web service I can't make it. I'm not a professional nor amateur. searched the web a lot. tried this and the odetocode version of this: 1. technet - something similar 1
I am trying to create a ad-hoc reporting system and plan to create the report rdl programatically using a wizard where user selects the attributes of the report.
point me to any documentation, sample application that I can refer to on how to create the rdl file programatically?
I'm new to creating reports. I created a report rdlc, and created three report parameters and placed in data region. See the code below
[Code]....
When I build this..I got the error saying "The table 'table1' is in the report body but the report has no data set. Data regions are not allowed in reports without datasets. "
I need to create rdlc without dataset and to bind dataset at runtime.
I want to create header for reports(.rdls).Now i am designing reports ,all reports have same header ...so i want to create fixed header file for all of my reports.
When I create a new website in IIS and its associated application pool, I get the option of setting the .NET framework to 1.0 or 2.0.Via windows updates I have installed versions 3.0 and 3.5..however these dont show up in the drop down list.I read that the aspnet_regiis -i command needs to be run in the installed .NET framework folder for it to be visible in IIS.However, the aspnet_regiis.exe is only present in the 1.0 and 2.0 folders. Can I use the same exe to register the 3.5 framework with IIS?