|
Hi
After 3 years of bodging our reporting requirements with anything and everything from HTML browser based reports to Tall PDF based reports, and a brief flirtation with ComponentOne's reporting engine we have now decided to attempt to solve this issue once and for all LOL!!!
Anyway we have some very complex reports, some include charts intermingled with tabular data, some require the titles to be displayed vertically etc. and then more simple mail merge type requirements so a good varied range of reporting styles and layouts.
So what are peoples opinions, what are peoples experiences of different tools, anybody used Crystal Reports??
Suggestions please, all help greatly appreciated it looks like a mine field out there everybody claims the earth but little has delivered to date!
Thanks in advance
Andy
|
|
|
|
|
I used to use SQL reporting Service in ASP.NET project..
|
|
|
|
|
Is this SQL 2005 specific?
|
|
|
|
|
Nope.. It can be used with SQL 2000..
|
|
|
|
|
thanks for your feedback Michael much appreciated 
can I build reports in the SQL 2005 environmentand then migrate them to SQL 2000, do you know?
does SQL EXPRESS 2005 support trport services?
thanks in advance
Andy
|
|
|
|
|
A point of clarification should be made regarding the relationship between SQL Server and SSRS. Reports developed using SSRS can link to a variety of data sources. These include SQL Server, Oracle, any ODBC-compliant data source and XML. This means that the data for your reports doesn't need to be stored in SQL Server. However SSRS requires an instance of SQL Server to be installed as it stores the metadata for its report catalog in a SQL Server database. This can be either SQL 2000 or SQL 2005.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
AndyBrew70 wrote: can I build reports in the SQL 2005 environmentand then migrate them to SQL 2000, do you know?
downgrading? I wonder why you want to do like that. I never try before..
AndyBrew70 wrote: trport services
I'm not so sure what you meat by trport service.
|
|
|
|
|
I have been looking through an ASP .NET project that is written in VB .NET. I was wondering what #If was and also if that's any different than just an if statement. Could someone please explain? I have been unable to find any information on it.
|
|
|
|
|
I think this is something that is used in C/C++ world. (but of course, it can be used in C# too.)
Check-out the link below for more details..
#if[^]
I never use this in my project so I don't have that much idea about that..
As this article " Conditional Attribute in C# compared to #if #endif[^]" said, conditional attribute might be more readable than #if.
Hope it helps.
|
|
|
|
|
Those are pre-processor directives. It begins with a # symbol. Preprocessor directives are handled by compiler.
|
|
|
|
|
Hi,
i want to upload file in perticular IP Address(Server),
becuase my application is hosted in Three diffrent web servers,
i want save this file in Perticular sand Device which is contain the user uploded files.
Never Think That You Have Failed Instead Always Think That u hav Better Chance Next Time...
|
|
|
|
|
And what is your problem?
|
|
|
|
|
how i upload file in Sand Device.
means one server to another server.
Never Think That You Have Failed Instead Always Think That u hav Better Chance Next Time...
|
|
|
|
|
i have a drop down list inside a gridview,i need to get the selecteditem.value of the selected item ,but i am getting only the value for the first item only,even if i select any other item..
heres the code i used plz help me...
int index = Convert.ToInt32(e.CommandArgument);
GridViewRow selectedRow = ((GridView)e.CommandSource).Rows[index];
string value = selectedRow.Cells[0].Text;
DropDownList ddl = (DropDownList)selectedRow.Cells[5].FindControl("ddlVendorName");
string mystr = ddl.SelectedItem.value;
|
|
|
|
|
mithun narayanan wrote: GridViewRow selectedRow = ((GridView)e.CommandSource).Rows[index];
I think this code might be wrong. As you are getting only one selected row, you won't get the list of rows that you want. So, maybe. You should try to for-loop all rows and get the value..
|
|
|
|
|
i want help for bind data on dropdown selectedindex_changed event
|
|
|
|
|
Hello Everybody
This is the second time im posting same problem.
What I want to do is, On my gridView I have a linkButton name linkSelect if you click it then will send memberID for memberDetails (which will fill details view inside a panel called by popup extender)
Im giving you my code:
ASPX CODE FOR GridView:
<asp:GridView ID="gvBorrowedBooks" runat="server" AutoGenerateColumns="False" Style="font-size: small;
font-family: Verdana" Width="100%" Visible="False">
<Columns>
<asp:TemplateField HeaderText="Sl.No.">
<ItemTemplate>
<asp:Label ID="lblSlNo" runat="server"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="MemberID">
<ItemTemplate>
<asp:HyperLink ID="linkMemberID" runat="server">[linkMemberID]</asp:HyperLink>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="BookID">
<ItemTemplate>
<asp:HyperLink ID="linkBookID" runat="server">[linkBookID]</asp:HyperLink>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Due Date">
<ItemTemplate>
<asp:Label ID="lblDueDate" runat="server"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Delay">
<ItemTemplate>
<asp:Label ID="lblDaysDelay" runat="server"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField>
<ItemTemplate>
<asp:LinkButton ID="linkSelect" runat="server" ForeColor="#C04000" CommandName="Select" >Select</asp:LinkButton>
<cc1:ModalPopupExtender ID="mpeDetails" runat="server" TargetControlID="linkSelect" PopupControlID ="pnlDetails" CancelControlID ="ibtnOK">
</cc1:ModalPopupExtender>
</ItemTemplate>
</asp:TemplateField>
</Columns>
<HeaderStyle BackColor="Blue" Font-Size="X-Small" ForeColor="White" HorizontalAlign="Center"
VerticalAlign="Top" />
<AlternatingRowStyle BackColor="Silver" />
<RowStyle BackColor="#9999FF" Font-Size="X-Small" HorizontalAlign="Center" VerticalAlign="Middle" />
<EditRowStyle Font-Size="X-Small" HorizontalAlign="Center" />
</asp:GridView>
ASPX CODE For DetailsView which is inside the panel
<asp:Panel ID="pnlDetails" runat="server" CssClass="modalPopup" style="display :none ; vertical-align: top; text-align: left;" Width="380px">
<table style="width: 100%">
<tr>
<td colspan="3">
<span style="font-size: 8pt; font-family: Verdana">Details information about member
and book</span></td>
</tr>
<tr>
<td colspan="3">
<asp:DetailsView ID="dvBooksMembers" runat="server" BackColor="White" BorderColor="#3366CC"
BorderStyle="None" BorderWidth="1px" CellPadding="4" Width="100%">
<FooterStyle BackColor="#99CCCC" ForeColor="#003399" />
<EditRowStyle BackColor="#009999" Font-Bold="True" ForeColor="#CCFF99" />
<RowStyle BackColor="White" ForeColor="#003399" />
<PagerStyle BackColor="#99CCCC" ForeColor="#003399" HorizontalAlign="Left" />
<HeaderStyle BackColor="#003399" Font-Bold="True" ForeColor="#CCCCFF" />
</asp:DetailsView>
</td>
</tr>
<tr>
<td style="width: 100px">
<asp:ImageButton ID="ibtnOK" runat="server" ImageUrl="~/Reports/images/ok_22.gif" /></td>
<td style="width: 100px">
</td>
<td style="width: 100px">
</td>
</tr>
</table>
</asp:Panel>
CODE BEHIND
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
lblMessage.Text = ""
gvBorrowedBooks.Visible = False
Dim _bbMembersList As bbMemberList = _bbMemberData.BorrowedBooksMembers()
If Not _bbMembersList.Count = 0 Then
gvBorrowedBooks.Visible = True
gvBorrowedBooks.DataSource = _bbMembersList
gvBorrowedBooks.DataBind()
Else
lblMessage.Text = "No Borrowers Found !!"
End If
End Sub
Protected Sub gvBorrowedBooks_RowDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles gvBorrowedBooks.RowDataBound
Dim _bbMembers As bbMember = New bbMember()
_bbMembers = CType(e.Row.DataItem, bbMember)
If _bbMembers Is Nothing Then
Else
Dim lblSlNo As Label = e.Row.FindControl("lblSlNo")
Dim linkMemberID As HyperLink = e.Row.FindControl("linkMemberID")
Dim linkBookID As HyperLink = e.Row.FindControl("linkBookID")
Dim lblDueDate As Label = e.Row.FindControl("lblDueDate")
Dim lblDaysDelay As Label = e.Row.FindControl("lblDaysDelay")
'Dim linkSelect As LinkButton = e.Row.FindControl("linkSelect")
lblSlNo.Text = _bbMembers.SlNo.ToString()
linkMemberID.Text = _bbMembers.MemberID.ToString()
linkBookID.Text = _bbMembers.BooksID.ToString()
lblDueDate.Text = _bbMembers.DueDate.ToString()
lblDaysDelay.Text = _bbMembers.DaysDelay.ToString()
' I want to put some code here like if click the linkSelect then it will pass selected memberID to fill details view
End If
End Sub
Protected Sub FillMemberDetails(i want to send memberID here when i click linkSelect button)
Dim row As GridViewRow = gvBorrowedBooks.SelectedRow
Dim conn As SqlConnection = New SqlConnection(Web.Configuration.WebConfigurationManager.ConnectionStrings("TCCLMS").ConnectionString)
Dim queryString As String = "SELECT MEMBERID as 'Member ID:', FIRSTNAME +' '+ LASTNAME AS 'Member Name:', Email as 'Email:', ContactNo as 'Contact No:' From Members Where MemberID = '" & _MemberID & "'"
Try
conn.Open()
Dim comm As SqlCommand = New SqlCommand(queryString, conn)
Dim _dataReader As SqlDataReader = comm.ExecuteReader()
dvBooksMembers.DataSource = _dataReader
dvBooksMembers.DataBind()
conn.Close()
Catch ex As Exception
conn.Close()
End Try
End Sub
Sarfarj Ahmed
|
|
|
|
|
Sarfaraj Ahmed wrote: Protected Sub FillMemberDetails(i want to send memberID here when i click linkSelect button)
Set LinkButton.CommandArgument = _bbMembers.MemberID.ToString()
in the GridView_RowDataBound function and fetch this memberID in the RowCommand Event like
dim memberID as string = e.CommandArgument
Now call the Protected Sub FillMemberDetails(memberID) function in the RowCommand event.
Hope this works for you!!
|
|
|
|
|
thank you very much for your help
Sarfarj Ahmed
|
|
|
|
|
How can we deploy a Asp.net 1.1 project with only .aspx files and no code behind should be present in the deployed project. I don`t wan`t to show code files..
can any one help pls
|
|
|
|
|
Just build the website and copy only ASPX pages,bin directory and config files. No need to supply source code
|
|
|
|
|
I have a below Label:
<asp:label id="DateFromLabel" runat="server" style="visibility: hidden" text="From: ">
I have to write a code to set its visibility to true and false. Hence I am using the Javascript as below
function makeVisible()
{
var dtfromlabel = document.getElementById('<% =DateFromLabel.ClientID %>');
dtfromlabel.style.visibility='visible';
}
The above code works perfect but If I try to pass a variable it doesn;t work? I am passing the variable as below
DateFromToCombo.Attributes.Add("onChange"," makeVisible('<%=DateFromLabel.ClientID%>')");
Please suggest me as it will help me to remove the javascript ffrom the code and place in .JS file. What is the issue with passing a variable?
Regards,
Pavas
-----------------------
[http://longjump.com/]
Dynamic business applications that manage and coordinate teams and information
-----------------------
|
|
|
|
|
mpavas wrote: DateFromToCombo.Attributes.Add("onChange"," makeVisible('<%=DateFromLabel.ClientID%>')");
Have you looked to the viewsource ? Is that coming correctly there ? Are you able to alert the id from makeVisible function ?
|
|
|
|
|
Yes the ID comes properly.
Regards,
Pavas
-----------------------
[http://longjump.com/]
Dynamic business applications that manage and coordinate teams and information
-----------------------
|
|
|
|
|
Opps sorry, When I use alert. It says ID is null or not an object.
Regards,
Pavas
-----------------------
[http://longjump.com/]
Dynamic business applications that manage and coordinate teams and information
-----------------------
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
