.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

I need help to satisfy a new requirement

Posted By:      Posted Date: October 13, 2010    Points: 0   Category :Sql Server
 

A company decided to award its customers a certain percentage of their total amount of the products they purchased. If the total purchase reaches a specific amount the customer will be awarded for example 5% of the total amount as a gift or cash. The company is planning to perform this process every 3 or 4 months.

The company needs to know who the awarded customers are. How much? On which period of time they are awarded? The customer should not be awarded twice for the same period of time.

Please I need your advice on how I can address the above scenario and come up with a way to satisfy this new requirement?

In the current system database there is a customer and invoice tables which represent the customers and their purchase.

Thank you.


View Complete Post


More Related Resource Links

Showing filtered Records in Crystal Report as per User Requirement

  

ReportDocument reportDocument = new ReportDocument();
    ParameterField paramField = new ParameterField();
    ParameterFields paramFields = new ParameterFields();
    ParameterDiscreteValue paramDiscreteValue = new ParameterDiscreteValue();
    
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            paramField.Name = "@Ext";
            //*Remember to reconstruct the paramDiscreteValue and paramField objects
            paramDiscreteValue.Value = 44854
            paramField.CurrentValues.Add(paramDiscreteValue);
            paramFields.Add(paramField);
            CrystalReportViewer1.ParameterFieldInfo = paramFields;
            reportDocument.Load(Server.MapPath("CMS_Report.rpt"));
&

How to work around Share point accessibility requirement ?

  

Hi,

I am somewhat new to things related to accessibility in SharePoint. I am trying to work on section 508 accessibility requirements for SharePoint site. I have tried to see few articles from the internet and still looking for more information on the subject matter including what to consider fro preparing requirement.  

I am looking to know what is possible and what is not with SharePoint?

How to achieve all the possible accessibilities in SharePoint?

Is it possible to make accessible all site types (Publishing, team sites,.)?

Please help me in understanding everything around SharePoint accessibility and first in preparing the requirement document. I have tried to see AKS site but there were some issues that are not clear for me at this level.

Thank you in advance,

<

VS workflow or SPD workflow for this requirement

  

Hi All, 

Following is my requirement.Need some help in finalising the approach.I want to know if this requirement can be achieved using SPD workflow or do i need to go for Visual studio workflow.And any help on steps to do this will be highly appreciated.

 Links to create new form or to show document library,    Document library will show status of open or closed for each document.
 When listing all documents, user can view any form.  The open forms can be edited. 
  Able to attach multiple files at said fields.  (Possible file formats:   word, excel, PDF, jpg, text, ZIP)
 IT Staff can approve and email notification sent to QA staff saying QA process can start
 QA staff can approve and after approval, the form becomes read only.  Email notification sent to IT staff stating QA is complete.
 When QA staff starts QA and find failures, QA Staff has link to fail the form and send it back to IT Staff for corrections with email notification of failure.
 IT staff will need to approve again and email notification sent to QA again to start QA process again.
 Each form should have failure history with what items has failed.
 For each form, I would like to have the ability to add notes like announcements so previous notes cannot be alt

Data Mining requirement specifications

  
  Hello All, Kindly I'm working now in a data mining project and we decided to use SQL server 2008 analysis services data mining algorithms. Now as we are at the start of the project we need to prepare all the required documentations like the requirement specification documents. can anyone help me in getting a template or guidance for the requirement document template or contents.   Regards, HebaHeba El-Desouky

SSAS REQUIREMENT

  
I want to develop one report for that I connected cube from the Excel, my requirement is I want to show data BSM wise, ASM wise, FO wise, Distributor wise, Sales man wise nothing but it is salesman hierarchy. monthly retailing Quantity and retailing value. April 10, may10,june 10 and July10 for the following products No1 90 g all variants,Nupur,Expert,Haircolour,Cinthol How to achieve this plz give suggestion it is an urgent requirement    

Creating service application w/ Requirement for MySite security profile to be maintained

  
Good Day; In Sharepoint 2010 Microsoft has given the developer the ability to create a service application that can have its own database and scale independantly from the rest of the Sharepoint farm.   I wish to create a Service Application that will store data much like a list, but I need to have the ability to use the same security trimming that the profiles offer via MySites.  We need to have the granularity at a user level that we can get in MySites but I do not wish to store this data in the Mysite collections.  Can the security granularity found in Mysites and Profiles be extended into a Service Application?  Any examples of others doing this or case studies around security that I can be pointed to would be most helpful. Cheers C

Creating service application w/ Requirement for MySite security profile to be maintained

  
Good Day; In Sharepoint 2010 Microsoft has given the developer the ability to create a service application that can have its own database and scale independantly from the rest of the Sharepoint farm.   I wish to create a Service Application that will store data much like a list, but I need to have the ability to use the same security trimming that the profiles offer via MySites.  We need to have the granularity at a user level that we can get in MySites but I do not wish to store this data in the Mysite collections.  Can the security granularity found in Mysites and Profiles be extended into a Service Application?  Any examples of others doing this or case studies around security that I can be pointed to would be most helpful. Cheers C

The values provided for the root activity's arguments did not satisfy the root activity's requirem

  
I have flowchart as implementation  of activitybuilder and added two dynamicactivityproperty to it. The flowchart is having flowdecision and 3 other customized activities with same defined arguments. But when i invoke the workflow and pass dictionary, it gives the error: The values provided for the root activity's arguments did not satisfy the root activity's requirements: 'Sample Workflow': The following keys from the input dictionary do not map to arguments and must be removed: FolderName, FolderSize.  Please note that argument names are case sensitive. Parameter name: rootArgumentValues Flowchart       fc = new Flowchart();  protected override void OnInitialized(EventArgs e) { wd.Load(new ActivityBuilder { Implementation =  fc});             ModelTreeManager mtm = wd.Context.Services.GetService<ModelTreeManager>();             ModelItem ab = mtm.Root;             ModelItemCollection argsAndProperties = ab.Properties["Properties"].Collection;                     InArgument<string> foldername = new InArgument<string>();    &n

Challenging requirement in Workflow

  
Hi, As per our requirement, we need WCF enables workflows to be exposed as services(WF 4.0). Also, we need to provide a feature to modify the workflow service using rehosted designer from the client application. How can we load the hosted workflow service(xamlx) files into WF rehosted designer? Is there any facility to create the workflow services dynamically?

Sharepoint Approval Complex Workflow Requirement

  
I have a very complex requirement of workflow to be developed. Here is it... There is a Sales Order form which user fills in. This form should have a header section which is static. Body section consist of questions which should be configurable. There are 2 answers to such questions. 1. Standarad & Other Exception. If user selects exception then more number of fields should be displayed which again should be configurable. For every exception answer to the question, there should be a provision to configure approver with a certain Role... e.g. GM, Controller etc.. This role would then have actual approvers who can change any time and as a result need to be again defined in config database. Again they would be based on the Business unit that form is filled in. Finally more questions can be added by admin which creates a new version of the form and from the day its released, all new records should show new versions however old should continue old. What would be the best sharepoint solution approach for this requirement?

which is best Snapshot Replication or Transaction Replication for my requirement?

  
Hi,    We have a main transaction database where all the live data is there.Now, to run a reporting application,we need a  different database, but the data is as EXACTLY as the live database.So,probaly every noght aroung 1 0'clock,we want to sync these two databases.   In this scenario,which is better, Snapshot replication or Transaction Replication? what are the pros and cons of using them? As I am new to this things,ur answers would be very much helpful..

what kind of a report to be created in SSRS when the requirement is to show the Summary and Details

  
I have some reports to be developed where I need to show the Summary and the details of Students/Particular Product, Please advice what kind of Report format/ drill down or is there a way that on clicking on the summary it would show Details in a child report using SSRS 2008. it would be helpful if there are some tutorial links too thanks in advance for response.

Solution requirement word template SP2010

  

I am trying to create solution requirements for SP2010?, can someone he;p me to provide me a barebones to start with

thank you


SSRS REQUIREMENT

  

I created one report in ssrs using Cube as a data source, i want to display the data total no of invoices as column based zone wise now  I am getting an error, the error message is:

[rsInvalidAggregateScope] The Value expression for the textbox ‘Brand_Code’ has a scope parameter that is not valid for an aggregate function.  The scope parameter must be set to a string constant that is equal to either the name of a containing group, the name of a containing data region, or the name of a data set.
Build complete -- 1 errors, 0 warnings


SSRS report requirement

  

Hi,
I am new to ssrs. I have a report requirement. There are 4 rdls out of which first one is a home page. It displlays three category names in a table column. I want to navigate to the other reports based on the selected category name. Like (if row.selectedvalue= C1, then goto c1.rdl). Is this possible in ssrs. Please help me out. 


Why does Output clause have the INTO requirement for tables with enabled triggers?

  

What is the reason for this restriction for Output clause?

If the OUTPUT clause is specified without also specifying the INTO keyword, the target of the DML operation cannot have any enabled trigger defined on it for the given DML action. For example, if the OUTPUT clause is defined in an UPDATE statement, the target table cannot have any enabled UPDATE triggers.


Range dimension: how to address this requirement?

  
Hi All,

Let me describe the requirement using 'FactInternetSales' table.

I have a Date_Range dimension with members 7 days, 14 days, 30 days, etc. To associate this dimension I need
DateRangeKey in the FactInternetSales table but FactInternetSales doen't have TimeKey (it has OrderDateKey, DueDateKey, ShipDateKey).
So how I can calculate DateRangeKey in the FactInternetSales named query using OrderDateKey, DueDateKey or ShipDateKey as they relate to their respective dimension but I need DateRangeKey from TimeKey (I guess OrderDateKey - 7, etc would work instead of TimeKey )?

Without Date_Range dimension I can meet some of my reporting requirement using filter or range operator but not all and for
performance I would like to use Date_Range dimension instead of filter or range.

Any help will be greatly appreciated.

Thanks
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend