ASP.NET : How to pass parameter field value to the sub report that have parameter fields?
405050
In the report designer right-click on the sub report. Choose edit subreport links. The pop-up window allows you to select a field from the main report which you can assign as a ?Parameter value in the sub report. \n\ngood luck
96922
I believe you should search the "ASP components" site\nmaybe you will find such a component.
645786
By using -- String val=request.getParameter("name of Form field"), and if u want this value to use on multiple pages taht u have to use java beans
277931
design time : column collection->add column\ncode : listview1.items.add("text here")\nlistview1.items(1).subitems.add("abcd")\n\nnote : use loop to generalise
74561
It's hard to tell exactly what you are asking, but it sound like what you are looking for is:\nSELECT Categories.field1, Categories.field2, ...SubCategories.field1, SubCategories.field2, ...\nFROM Categories INNER JOIN subCategories ON Categories .catID = SubCategories.catID\nORDER BY Categories.catID;\n\nWhen you walk through the recordset, you keep track of PreviousCatID. When the Categories.catID doesn't match the PreviousCatID, you print the Category data items before the subcategories and update the PreviousCatID. If CategoryID hasn't changed, you just print the subcategory items.
849138
Usually MSDN pages aren't the best, but this one is actually really descriptive and has a section on this topic alone. How to edit data through a bound formview. So I will provide you the link below and you can read up on it. It even provides you an example.\n\nRemember to create yourself an edit template and the rest is cake.\n\nEnjoy!
353874
First you have to have a variable assigned to the edit box, one called, say, m_String. Then in your code you write:\n\nUpdateData(TRUE);\n\nNow m_String has the contents of the edit box.
1023038
The file structure looks pretty close to what you would want.  Have a table with EmployeeId (PK), ManagerId (nullable), name, etc etc..  Then create a check constraint on the ManagerId field to ensure that a value exists inside of employees table already (except when null).  If you then want to have two different queryable objects you could create a view like ManagerEmployeeView and PeonEmployeeView =)
899331
'procedure to export data\nPublic Sub Export(rs As ADODB.Recordset, Optional FileName As String = "Export.csv", Optional Delimiter As String = ",")\n\nIf rs.EOF Then Exit Sub ' nothing to print\nDim Fnum As Integer '\nDim strName As String\nDim filePath As String\nDim i As Long\nFnum = FreeFile\nfilePath = Application.CurrentProject.Path & "&#92;"\nOpen filePath & FileName For Output As Fnum\nFor i = 0 To rs.Fields.Count - 1\n    strName = strName & rs.Fields(i).Name & ","\nNext i\nPrint #Fnum, strName\nPrint #Fnum, rs.GetString(adClipString, , Delimiter, vbCrLf)\nClose #Fnum\nMsgBox "File exported"\n\nEnd Sub\n\n\n\n' ummm yeah I usually don't give out my code but here its thanksgiving. are you able to understand it?? Good luck
650047
What does "hit all of the control form fields and report the information back to SQL" mean? \n\nDo you mean, you want a button that will run a given stored procedure on the server, using parameters?\n\nDo you mean, you want to obtain the value of the form fields and use them to build a SQL statement that you then execute on the server?\n\nAlso, are you using SQL server, MySQL, SAP, whatever as a SQL database?\n\nUPDATE:\n\nYou still haven't told me what kind of DB server you are using, so I'll assume is SQL Server.\n\nYou don't need to create a VBA Script to do what you want. You can simply link the relevant SQL tables in your Access project file, then work with them as though they were tables in the Access DB itself.\n\nIn other words, you can build a form based on a linked table, just like you would build a form for a regular Access table; it will insert data for you into the linked table, the same way it would for a regular table.\n\nSee link below for more information.
253594
Sure.  You have to use a parameter for the date in the criterion for each of your queries, like:\n\n    >= [LowestDate?]\n\nor\n\n    = [ExactDate?]\n\n(You set this up by editing the query in Microsoft Query -- add a comment if you can't find this step.)\n\nThen,  make sure the External Data toolbar is showing (using View -> Toolbars -> External Data), click any cell in the results of the first query, and click 'Query Parameters' on the toolbar.  That will open a dialog box which will allow you to set the query parameter to obtain its value from a particular cell.\n\nThen, repeat the same procedure with each query, setting the same cell for the parameter value in each query.\n\nSo, every query will depend on the value in a single cell.
361351
You can do this with ASP>net and SQl connection object.\nYou can also use Jav and JDBC
911832
I'm assuming you mean values from form elements in an HTML page. Just specifiy the form elements in your HTML, be sure to mention the servlet in your form action and the method (get/post); the parameters will be sent to the servlet.\n\nTo receive these parameters, use the getParameter(...) method on the request.\n\nThe link in my source explains what I said above with an example.\n\nHope this helps.\n\nAndy
404668
In Report Design right-mouse click on the detail section and select "Sorting and Grouping" ... you can select the desired field and set the properties for the group and / or sort.
87907
The previous answer is correct.  The Javascript prompt just gets the value into the CLIENT side - it does not invoke the SERVER side, where the aspx runs.  Somehow, after you do this, you have to send the request to the server.\n\nLogically, in you application, is there a form the user is filling in?  If so, pass the value in the form as a hidden field or on the query string.\n\nOr, are you wanting to end the current page right after the prompt, and go directly to the page the aspx builds?  If so, immediately after your prompt, do a\nlocation.replace="http://...nameofpage?valueInAspx="+variablevalue\nand pick in up in the request collection.
95799
Assuming you do this on the server side, look for the user name and password in the request collection in you particular language - the variable name will be the names you give them in the input text items on the form.\n\nIf you are talking client side, have the form call a javascript function on the onclick event, the use a location.replace or location.href method to ship them off.
311080
Your question is not clear.\n\nThe parameters will depend on what exactly you wish to inspect except that it should be possible to visually inspect it i.e. should be visible & visually distingushable.