|
Thanks in advance
I want to create report writer (user can create reports on run time by selecting field)
in VS 2008 / 2005 by using SQL Server on Back end and crystal report or any other report writer for reporting
Best of Regards,
SOFTDEV
Reply·Email
|
|
|
|
|
softdev_sup wrote: I want to create report writer (user can create reports on run time by selecting field)
in VS 2008 / 2005 by using SQL Server on Back end and crystal report or any other report writer for reporting
Is a statement, not a question. So go ahead and let us know the outcome.
Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP
|
|
|
|
|
any guidlines
|
|
|
|
|
Ask your user to go for MS or Crystal Report training...
|
|
|
|
|
|
Seriously, what you are asking (letting user create whichever kind of report they like) has been asked by many users years before. But the fact remains that creating a report requires knowledge of database and the schema of that system, and the knowledge of the reporting engine/IDE, which generally need a developer.
Unless you are talking about "prefixed" dynamic report, where user choose the columns from a pre-defined list.
|
|
|
|
|
Yes i Want actually a very simple report writer where a user can make his own desire reports on run time , i know their are Discrepancies but still wanna do it bcz of some requirements
Best of regards,
SOFTDEV
|
|
|
|
|
softdev_sup wrote: any guidlines
Several, take your pick;
* The guidelines on UI-design alone amount to a whopping 38 mb (850 pages) and can be found here[^].
* The guidelines for designing a class-library can be found here[^].
* The coding guidelines of Brad Abrams can be found here[^].
Your question is too broad to give a more specific answer.
"Walking on water and developing software from a specification are easy if both are frozen." -Edward V Berard
|
|
|
|
|
thank you so much so nice of u
|
|
|
|
|
Hi all,Are there any application running in recovery console mode ???
And how can we run the native using api application in recovery console mode.
|
|
|
|
|
AFAIK, you can't run any applications in the Recovery Console. You're limited to what the Command Prompt provides.
|
|
|
|
|
That's not possible since the .NET Framework isn't loaded when Windows starts in the recovery console.
You'll have to write in a language that compiles to native code.
|
|
|
|
|
Hi all
I am using vs2005 and windows form
I want add a control inside the datagridview's (windows control ) cell
I dont find any method similar to gridview webcontrol's
gridview.rows[0].cells[0].controls.add()
anyone can post the code snippet for this
thanx a lot
|
|
|
|
|
Take a look at DataGridView Custom Column Sample[^] from MSDN.
Or This article[^] from Code Magazine.
If neither of these is quite right, I found them and loads more by Googling custom datagridviewcolumn
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
Hi,
I try to export datagrid data to one excel spread sheet (i called it ExcelA).
Then, when I want to close ExcelA, I wrote this codes to kill excel.exe.
wExcel.Quit()
System.Runtime.InteropServices.Marshal.ReleaseComObject(wExcel)
System.GC.Collect()
Dim proc As System.Diagnostics.Process
For Each proc In System.Diagnostics.Process.GetProcessesByName("EXCEL")
proc.Kill()
Next
wExcel = Nothing
But then, it killed all the excel that I currently open. (those that are not related to this ExcelA.)
How can i only kill the excel.exe that belonging to this ExcelA ?
Please help. I had tried to search.. but failed to get it.
Thanks in advanced. Appreciate your help.
Here is my codes:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
ds.Clear()
ds.Tables.Add()
If ds.Tables(0).Columns.Count <= 0 Then
For i As Integer = 0 To myTable.Columns.Count - 1
ds.Tables(0).Columns.Add(myTable.Columns(i).ColumnName)
Next
End If
Dim dr1 As DataRow
For k As Integer = 0 To myTable.Rows.Count - 1
dr1 = ds.Tables(0).NewRow
For j As Integer = 0 To myTable.Columns.Count - 1
dr1(j) = dgSearch.Item(k, j)
Next
ds.Tables(0).Rows.Add(dr1)
Next
Dim wExcel As New Excel.ApplicationClass
Dim wBook As Excel.Workbook
Dim wSheet As Excel.Worksheet
wBook = wExcel.Workbooks.Add()
wSheet = wBook.ActiveSheet()
Dim dt As System.Data.DataTable = ds.Tables(0)
Dim dc As System.Data.DataColumn
Dim dr As System.Data.DataRow
Dim colIndex As Integer = 0
Dim rowIndex As Integer = 0
For Each dc In dt.Columns
colIndex = colIndex + 1
wExcel.Cells(1, colIndex) = dc.ColumnName
Next
For Each dr In dt.Rows
rowIndex = rowIndex + 1
colIndex = 0
For Each dc In dt.Columns
colIndex = colIndex + 1
wExcel.Cells(rowIndex + 1, colIndex) = dr(dc.ColumnName)
Next
Next
wSheet.Columns.AutoFit()
Dim strFileName As String = "C:\M2.xls"
Dim blnFileOpen As Boolean = False
Try
Dim fileTemp As System.IO.FileStream = System.IO.File.OpenWrite(strFileName)
fileTemp.Close()
Catch ex As Exception
blnFileOpen = False
End Try
If System.IO.File.Exists(strFileName) Then
System.IO.File.Delete(strFileName)
End If
Try
wBook.SaveAs(strFileName)
wExcel.Workbooks.Open(strFileName)
wExcel.Visible = True
Catch ex As Exception
MsgBox(ex)
Finally
' MsgBox("closing now")
End Try
End Sub
Private Sub Excel_WorkbookBeforeClose(ByVal wBook As Excel.Workbook, ByRef Cancel As Boolean) Handles wExcel.WorkbookBeforeClose
wExcel.Quit()
System.Runtime.InteropServices.Marshal.ReleaseComObject(wExcel)
System.GC.Collect()
Dim proc As System.Diagnostics.Process
For Each proc In System.Diagnostics.Process.GetProcessesByName("EXCEL")
proc.Kill()
Next
wExcel = Nothing
End Sub
|
|
|
|
|
Try using environment.exit(exitcode) in the workbook close event.
|
|
|
|
|
Hi ,
I would like to edit 2 columns in datagrid. How can i do that?
I know dgSearch.ReadOnly = False, is to be able to edit all columns.
But now i only want certain columns only.
How should I go about?
Please help and guide me. Thanks in advanced.
regards,
eunice
|
|
|
|
|
You need the DataGridViewColumn.ReadOnly property. MSDN[^]
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
Hi All,
I am loading usercontrols inside form(Pannel).Upon click on button on usercontrol it opens popup(form) which minimizing the toplevel form. The pop up should open above Toplevel form. Any idea please help.
I tried by setting TopMost property to true but no luck.
Many Thanks,
Sri
|
|
|
|
|
Try to set this property after displayed by Show() method. That usually fixes it.
|
|
|
|
|
Hello,
Thanks for the reply. Which property i need to set.
Regards,
Sri
|
|
|
|
|
Same TopMost like below.
Dim f As New Form2
f.TopMost = True
f.Show()
Me.TopMost = True
|
|
|
|
|
i dont think so it will work in MDI i have same problem also
if i put one control box or any other container control on MDI form then the child form goes back
|
|
|
|
|
Hi All,
After loading form loosing focus. I tried by setting focus in "Deactivate" and "LostFocus" event of form but no luck. Form loosing focus after 5-10 sec(After loading).
Many Thanks,
Sri
|
|
|
|
|
Please provide some code for what exactly you are doing on load, Deactivate and LostFocus events.
|
|
|
|