|
|
Christian rantings in the author's signature
|
|
|
|
|
Hi,
In my report, I use "DateString" to get today date. But it's in "mm-dd-yyyy" format. I want to change the date format to "dd-MMM-yyyy". How can I change it?
Thanks.
|
|
|
|
|
Hi, how to generate RDLC at run time and how to group runtime generated RDLC?
|
|
|
|
|
i want to make a 5 column(detail) rdlc report for which
i have sql table i want to fetch the records from table and then do som evalidation in the fields wheather it has to be bold or cnetre of the report etc. after the validation i want to pass it to the report and then that report i will handover to reportviewer
by taking textboxes in the but dont want to use talbe of report i ll not be able to centre the text
can any one help me
|
|
|
|
|
Hi Robert,
It is a great joy to read your article and it helps me a lot in building a database report display which is charaterised by a date within the past 30 days. On the left panel, I have a date tree labelled by the business date and using your method I am able to retrieve/display the data on the right panel, based on the specific date node clicked.
I have one problem in generating the report for the selected date, though.
The report generated by Export button,contains the data for all the dates.
What should I do to make the report contain only the data associated with the specific date chosen?
Could you help me to solve this problem? Thank you very much.
Best Regards,
Franklin
|
|
|
|
|
Sometimes I get the #Error text for different reasons. Can I do anything to get a more friendly text like "-"?
_____________________________
...and justice for all
APe
|
|
|
|
|
I have a Master Detail report that I need to change. It prints customer orders, so (to simplify), the master is the customer information and the detail is the line item information. I need to add a message file where the user can enter multiple lines of free form text that would print after the detail lines.
I can't really incorporate the text lines into my existing line item table which has several different fields in the report table.
Can I add a 2nd table that points to a different data source?
Additionally, I have not found any source other than your article that describes how to create reports in .NET using the Report Designer. Can you recommend anything?
Thanks
MGothelf
|
|
|
|
|
Hi,
I am doing the web report with reportviewer control. But my toolbar buttons are different from what I saw in some online examples. I didn't see the print button on toolbar. Can I add print button to toolbar? thanks a lot for the help,
Don Yang
|
|
|
|
|
How can we extend this to multiple hirerachiesreport. For eg. a report showing parent, children, grand children and great grand children hirerachies?
Steve
|
|
|
|
|
I have created a number of reports following the directions and it works great. However, in one case, I would like to print the report without opening a viewer at all. I don't need to launch another thread, the report is small and quick to run, it just always gets printed and user does not want to see the report on screen, or go through the printer dialog.
|
|
|
|
|
Go to the link below for the code to print directly from the report. Note that you do not need a reportviewer control for this. Just print the report directly as in the code. They are using filestreams to store the temporary print pages. You should use memorystreams instead. They are also filling the dataset from an xml file. You should use a DataAdapter.Fill to fill from the database instead. The printerName is hardcoded here, but you will need to use the PrintDialog.
Finally, use:
report.ReportEmbeddedResource = "Report.rdlc"
instead of:
report.ReportPath = "..\..\Report.rdlc"
http://msdn2.microsoft.com/en-us/library/ms252091(VS.80).aspx[^]
- Robert R Freeman
|
|
|
|
|
I have tried to do this the whole day, but to no luck.
My report gets the data from:
Me.PrintedJTNTableAdapter.Fill(Me.JTNDataSet.PrintedJTN, frmMain.ToolStripLabel6.Text)
PrintedJTNTableAdapter.GetData(frmMain.ToolStripLabel6.Text)
Me.ReportViewer1.RefreshReport()
All the examples that I can find on how to print the report without viewing te report uses local xml files.
The user needs to print three different reports when they click on print on going the reportviewer way is very long.
PLEASE HELP...
|
|
|
|
|
Here is all the code to export the report to PDF and print the report automatically.
###########################################################################
Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
If PrintSelect.chkLaser.Checked = True Then
Timer1.Enabled = False
On Error Resume Next
Me.PrintedJTNTableAdapter.Fill(Me.JTNDataSet.PrintedJTN, frmMain.ToolStripLabel6.Text)
PrintedJTNTableAdapter.GetData(frmMain.ToolStripLabel6.Text)
With Me.ReportViewer1
.RefreshReport()
End With
Else
Timer1.Enabled = True
End If
End Sub
Private Sub ReportViewer1_RenderingComplete(ByVal sender As Object, ByVal e As Microsoft.Reporting.WinForms.RenderingCompleteEventArgs) Handles ReportViewer1.RenderingComplete
Dim format As String = "PDF"
Dim deviceInfo As String = Nothing
Dim mimeType As String = Nothing
Dim encoding As String = Nothing
Dim fileNameExtension As String = Nothing
Dim streams As String() = Nothing
Dim warnings As Microsoft.Reporting.WinForms.Warning() = Nothing
Dim returnValue As Byte()
returnValue = ReportViewer1.LocalReport.Render(format, deviceInfo, mimeType, encoding, fileNameExtension, streams, warnings)
Dim fs As New IO.FileStream("c:\a001.pdf", IO.FileMode.Create)
fs.Write(returnValue, 0, returnValue.Length)
fs.Close()
Dim psi As New ProcessStartInfo
psi.UseShellExecute = True
psi.Verb = "print"
psi.WindowStyle = ProcessWindowStyle.Hidden
psi.FileName = ("c:\a001.pdf")
Process.Start(psi)
Timer1.Enabled = True
End Sub
Private Sub Timer1_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Timer1.Tick
'res = AcroExchAVDoc.Close(False)
Dim myProcesses As Process() = Process.GetProcessesByName("acrobat")
Dim myProcess As Process
For Each myProcess In myProcesses
myProcess.Kill()
Next myProcess
Timer1.Enabled = False
Form2.Show()
Me.Close()
End Sub
End Class
############################################################################
If there are any questions regarding this code, please email me on mjohl@laserf.co.za
By struggling we learn...
|
|
|
|
|
|
Hi,
I'm having an issue when adding any fields from my dataset to the report. It crashes VS2005. I can create a new report and see the datasets, however, when I drag-drop a field from my dataset to the report, it crashes immediately. Anyone run into this issue? I have included the trace. Thank you.
I have also posted a screenshot @
http://www.jennewine.com/cpdump.htm
and a log file @
http://www.jennewine.com/cpdumpText.htm
|
|
|
|
|
Hi
The article is great and resourceful. Thanks for it.I am using vs.net 2005 and reporting with ssrs 2005 bundled with it.I am programmatically binding data from Oracle 9i database through datatables. The problem is my reports are running smothly when i run them from my application (i.e from the asp.net development server) but when i precompile the website the reportviewer containing aspx page is giving the following error:
data at root level is invalid:
Please let me know what i am doing wrong Thanks again.
|
|
|
|
|
Hi All,
I want to use PDF export functionality of report viewer. But i do not want Report Viewer to display to the user.
Is it possible?
Can I customize report viewer?
Thanks in Advance
|
|
|
|
|
Hi,
Great easy to follow article.
I have the following problem though. I have 2 different tables from 2 different databases (one ORACLE and one Access) that have a one-to-one relationship. I want to be able to just join the 2 tables in a dataset with a one-to-one relationship between the 2 primary keys and then use this dataset to display the data in a table on the report.
But the Dataset designer will only allow me to create a one-to-many relationship and the Report designer insists that I have a grouping for the field that is supposedly coming from the many table.
How can I get around this?
thanks
Vicky.
|
|
|
|
|
For a one to one relationship you can do 2 adapter fills on a single datatable. If using a loosely typed dataset, then the data adapter would automatically add the additional columns if the correct schema properties are set on the SelectCommand object The primary key would need to have the same name in both databases or else you would need to do the column mapping.
If using a strongly typed dataset, then generate the datatable using one adapter and then manually add in the second table's columns ensuring that each column is nullable. Specify column mappings on the secondary select command if the primary key column name is different. When filling make sure to fill from the first database first, which will leave nulls in the secondary columns until you do the fill from the other database.
- Robert R Freeman
|
|
|
|
|
Didn't know how to do 2 adapter fills on single datatable so I have gone with the second option. Here is what I did :
Private Sub frmReportAll_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Me.ABN_TBLTableAdapter.Fill(Me.ds_LOPBS_ABN_rpt.ABN_TBL)
Dim dt As DataTable = Me.ds_LOPBS_ABN_rpt.ABN_TBL
Dim dr As DataRow
Dim cnn As New OracleClient.OracleConnection(gEDBPUser.EDBPConnStr)
cnn.Open()
For Each dr In dt.Rows
Dim strSQL As String = "SELECT ALLEGED_OFFENDER_FIRST_NAME, ALLEGED_OFFENDER_SURNAME FROM CM.CM_NOTIFICATION " & _
"WHERE NOTIFICATION_ID = " & dr("ABN_ID")
Dim cmd As New OracleClient.OracleCommand
cmd.CommandText = strSQL
cmd.CommandType = CommandType.Text
cmd.Connection = cnn
Dim rdr As OracleClient.OracleDataReader
rdr = cmd.ExecuteReader
rdr.Read()
dr("ALLEGED_OFFENDER_FIRST_NAME") = rdr("ALLEGED_OFFENDER_FIRST_NAME")
dr("ALLEGED_OFFENDER_SURNAME") = rdr("ALLEGED_OFFENDER_SURNAME")
rdr.Close()
rdr = Nothing
cmd = Nothing
Next
cnn.Close()
Me.rpvAll.RefreshReport()
End Sub
|
|
|
|
|
Good Example but how does one provide Page Number if the Details in the Group Span Across Multiple Pages.
The Report Will ONLY allow Paging in the Report Footer Section(Which Pirnts Pages for the Whole Report) NOT In the List Box on the Page Section!!! Is there a Formula Expression one ca use in a Textbox at the Bottom of the Group?
MAHENKE
-- modified at 10:04 Tuesday 16th January, 2007
|
|
|
|
|
Thanks for the article and code were very helpful for to get up to speed quickly using Microsoft Reporting Services (first experience). I was curious if you have much experience supplying business object classes as the datasource instead of datasets? You see, my application uses an ORM and all data objects are returned to me from my data layer in collections (IList). It appears passing the IList collection to the reporting source will work just fine, but what about passing a one-to-many data collection? Just curious if you have had any experience in this areas using the MS Reporting Services?
|
|
|
|
|
HI
I have Problem with the Microsoft Report Designer in VS2005
Cause i Want to write a custom code in my Report and Call in the report elemnts
But i cant found , my written Function . when I Call it
Please Help me , about It
Thanks and Regards
sa_tabrizi@yahoo.com
|
|
|
|
|
Hello,
I am currently working on VS 2005, and using SQL Server 2005 database. I am designing a rdlc report, in which I don't know the columns in advance, the columns can increase or decrease. So I am thinking to create a report file at runtime, and provide it data. Can anyone help me in this... It would be great if I could see some sample code as how to create file and send data through the form (Windows Form).
Thanking in advance...
Priya
|
|
|
|