Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-08-10 : 09:39:50
|
SESHU writes "Hi Everybody1.I want to create a stored procedure using Access Module.The module having some code for X_form, X_report.Here getting Data from X_Parms,X_Opt,X_rs tables. for the X_form and X_report Asume data like---------------------------------------------------------------Tab 1:X_parms coulmnsReport Name ReportSortOption ---------------------------------------------------------------Tab 2:X_rs columnssales orders --------------------------------------------------------------Tab 3:X_Opt columnsm1-n1-o1-p1-q1-r1--------------------------------------------------------------2.In X_form one combo Box SORT BY---(i)by country by region by city.(ii)by area by manager by division.(iii)by country by division by emp. like that (multi combinations)If select one sort option------(i)by country by region by citycorresponding report i want to display. Here internally filter the multi combnation sorts and insert the exact sort option in the report like given example [by country]3.Report display like this_______________________________________________________________ By country details prod1 prod2 prod3 -SALES sum(p1) sum(q1) sum(r1) -ORDERS sum(m1) sum(n1) sum(o1) ------------------------------------------ Grand Total:200 300 500 ------------------------------------------_______________________________________________________________This is the embeded logic in the Access module. i want to create a stored procedure in SQL Server2000 In this Scenario How to create a stored procedure plz guide me.from that procedure i want to create a crystal report similar to a Access module functionalitythanksSESHU" |
|
|
|
|
|
how to create a stored procedure from MS-Access module