I have created one crystal report which has one Group name field too. My Crystal report has 3 pages. But the Group Name field is displayed only in the first page. I want to display the Group Name field in the next pages also.
View 1 Replies
I have created one crystal report which has one Group name field too. My Crystal report has 3 pages. But the Group Name field is displayed only in the first page. I want to display the Group Name field in the next pages also.I am using Crystal Reports 2008.
View 1 RepliesHow can one create/display a continuous Image marquee.
View 5 RepliesI'm trying to write a form for a user to leave a testimonial on the website. I would like a group of inputs related to the users name (title, firstname and surname) or an input for their company name to be required. They can leave both if they like, but they must at least either fill in all the inputs related to their name or the input for their company name.can I do this with the RequiredFieldValidator?
View 3 RepliesI have three asp checkbox controls and button click. If any of those three checkboxes is not selected it shoudld validate . How can i accomplish this?
I have createdate field in a table and I want to use that field to group items in a gridview based on the date. For instance, if the datediff is less than 25 hours ago then I want to show the word "Today" or if greater than 24 but less than 48 hours show the word "Yesterday" etc.
View 6 RepliesI have a web forms where i have 10 required field validators for 10 textboxes. Validation group for these required field validator needs to be determined when the page loads. I tried to change the validator in the .cs file but failed.
rfvBT.ValidationGroup = "registration";
how to set required field validator for radio button based on the group names
View 1 RepliesI am using a GridView Control to display multiple fileds with 0's and 1's.
I am using template fields where CheckBoxes are used.
Where exactly and how do I apply the Logic to get a checked CheckBox when field Value=1 and unchecked CheckBox when field Value=2 .Also some times to be able to write a YES where fieldValue=1 or NO where filedValue=0
Do I apply this logic using asp or C#? How?
Im a newbie in sql.. I have a query which display a list of program by college..This is the example:
my problem is the user wants the report to be display followed by college..like this:
i try to do select by select query but incorrect..anyone having the same xperience...?
Given some rows of records as follows:1) 5 Continent headers2) Country subheader grouped under each continent3) City items (with links to individual city pages) displayed under each Country subgroupWhat would be the best control used to display the above data. Would a report viewer be good?
View 1 RepliesI have an application where I display every Active Directory group that the current user belongs to. When I have my config setup like this:
<authentication mode="Windows"/>
<authorization>
<deny users="?"/>
<allow users="*"/>
</authorization>
It works fine. When it's like this:
<authentication mode="Windows"/>
<authorization>
<!--<deny users="?"/>-->
<allow users="*"/>
</authorization>
No groups are found. Why does this make a difference? Does asp.net only authenticate if we are specifically denying access to unauthenticated users? If it helps this is how i'm getting the groups:
protected string GetUserGroups()
{
StringBuilder userGroups = new StringBuilder();
ArrayList groupMembers = new ArrayList();
DirectoryEntry root = new DirectoryEntry("LDAP://myldap/DC=nc,DC=local");
DirectorySearcher ds = new DirectorySearcher(root);
ds.Filter = String.Format("(&(samaccountname={0})(objectClass=person))", User.Identity.Name.Substring(User.Identity.Name.LastIndexOf(@"") + 1));
ds.PropertiesToLoad.Add("memberof");
try
{
foreach (SearchResult sr in ds.FindAll())
{
foreach (string str in sr.Properties["memberof"])
{
string str2 = str.Substring(str.IndexOf("=") + 1, str.IndexOf(",") - str.IndexOf("=") - 1);
groupMembers.Add(str2);
}
}
}
catch
{
//ignore if any properties found in AD
}
return String.Join("|", (string[])groupMembers.ToArray(typeof(string)));
}
I've written this code to display a group of events when the value is 12/19/2010. This means each day I need to change the "default value" to the current date to display the events of the day. I would like to make this such that the change occurs automatically, that is, on 12/20/2010, I'd like to see just the events for 12/20/2010.
<asp:SqlDataSource ID="testeventdate" runat="server" ConnectionString="<%$ ConnectionStrings:testdateConnectionString %>" SelectCommand="SELECT [eventDate], [eventDesc] FROM [programEvents] WHERE ([eventDate] = @eventDate)">
<SelectParameters>
<asp:querystringparameter DefaultValue="12/19/2010" Name="eventDate" QueryStringField="eventDate" Type="DateTime" />
</SelectParameters>
</asp:SqlDataSource>
I'm developing a Asp.Net website and I need to display the four most recent tweets from a group of users (around ten) that will be set in the admin area of the website. I know twitter has an API, but I don't know where to start.
View 3 RepliesI want to display records randomly in gridview from database
Eg :
id city category compname rate
1 newyork Books mediatech 1000
2 newyork Books Info tech 1000
3 newyork Books Sysmach 999
4 newyork Books Wifi texh 0
Now the data are displaying in descending order by rate wise and there are two company booked in same price which is 1000 . i want to display random which is one day mediatech should be in top and next day info tech should be in top.
so i need group by rate with newid()
I want to display records randomly in gridview from database
Eg :
id city category compname rate
1 newyork Books mediatech 1000
2 newyork Books Info tech 1000
3 newyork Books Sysmach 999
4 newyork Books Wifi texh 0
Now the data are displaying in descending order by rate wise and there are two company booked in same price which is 1000 . i want to display random which is one day mediatech should be in top and next day info tech should be in top.
I'm trying to use a ListView to display product specs. I also want to display the group headings such as "Dimensions", "Input Ports", etc.
How do I display these group headers? My code below lists the specs but doesn't show me the header. If I put some static text however, that shows up. What am I doing wrong?
[Code]....
i have a data driven web application, in my database i have this datetime column,
and in my web application i have this gridview, but the only data that i need to display are the records with todays date until the past 6 days from today, so its like 7 days all in all.
I am using the GridViewHelper [URL]to display gridview with group and subtotals. This seems to only work on BoundField and I am wondering how to get this work with TemplateField.
Dim helper As New GridViewHelper(Me.GridView1)
helper.RegisterGroup("DeptDesc", True, True) - Works
helper.RegisterSummary("Reg", SummaryOperation.Sum, "DeptDesc") - Throws Error Below
helper.ApplyGroupSort()
DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'Reg'.
<asp:BoundField DataField="DeptDesc" HeaderText="DeptDesc" SortExpression="DeptDesc" />
<asp:TemplateField HeaderText="Reg" SortExpression="Reg">
<ItemTemplate>
<asp:Label ID="Label2" runat="server" Text='<%# IsSplit(Eval("EmployeeID")) %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
I'm using Report.rdlc for report definition. The following instruction provides the sum of the values in the Cost text box for the page:
=Sum(ReportItems!Cost.Value)
But I want to get sum of the values in the Cost text box for pages from first page to the last page that we are at now. For example page1 has sum of 80 and page2 has sum of 70, Now I want to get 150 in the second page(ie, Page2).
i have 2 tables company(companyId,companyName,City,state,country) and people(peopleId,peopleName,City,state,country) i want to display the total no of contacts and Total no of companies with respect to countries
i tried with group by: select country,count(*)companyId from company group by country is displaying the total number of companies with respect to country select country,count(*)peopleId from people group by country is displaying the total number of peoplewith respect to country
but i want to combine these two quries i want the output as :
Country Companies Contacts
India 10 5
USA 0 10 (usa is having only contacts ,i doesn' have the companies)
UK 8 0 (ukis having only companies ,i doesn' have the contacts)
I'm using a linq group by query (with two grouping parameters) and would like to use the resulting data in a nested repeater.
var dateGroups = from row in data.AsEnumerable()
group row by new { StartDate = row["StartDate"], EndDate = row["EndDate"] };
"data" is a DataTable from an SqlDataAdapter-filled DataSet. "dateGroups" is used in the parent repeater, and I can access the group keys using Eval("key.StartDate") and Eval("key.EndDate").
Since dateGroups actually contains all the data rows grouped neatly by Start/End date, I'd like to access those rows to display the data in a child repeater. To what would I set the child repeater's DataSource? I have tried every expression in markup I could think of; I think the problem is that I'm trying to access an anonymous member (and I don't know how.) In case it doesn't turn out to be obvious, what would be the expression to access the elements in each iteration of the child repeater? Is there an expression that would let me set the DataSource in the markup, or will it have to be in the codebehind on some event in the parent repeater?
Stack-Overflow :3 I've got a kind of hard-case question.
So I'll try clearly explain my idea with my poor english :/ need select to DataTable SOME values from ???_**GetDisplayData **procedure for each day of previos month (GROUP IT) where group rules for different columns is different
I need to select some values in stored procedure from other stored procedure like this :
SELECT X FROM Y_Procedure(@ProcedureParameters)Also I need to select from dynamic SQL Procedure like
Y_Procedure=@Y+'_Procedure'
SELECT X FROM Y_Procedure(@ProcedureParameters)
Also I need to load it to DataTable :-/INSERT INTO @Report (CellHorizontal, CellVertical, CellValue) --to TABLE
SELECT Date,X2,X3 FROM Y_GetDisplayData(@Param)
SET NOCOUNT OFF;
SELECT *
FROM @Report
GetDisplayData works as select with parameters and that doesn't returns SQL DataTable
And there is no way to recode GetDisplayData's procedures, it's just constant procedures for me.Finally I need to Group nodes from this table
INSERT INTO @Report (CellHorizontal, CellVertical, CellValue)
SELECT T1.Date,
IF ((Select grouptype...)=1) T1.X2 + T2.X2
ELSE IF ((Select grouptype...)=2) AVG(T1.X2,T2.X2),
IF ((Select grouptype...)=1) T1.X3 + T2.X3
ELSE IF ((Select grouptype...)=2) AVG(T1.X3,T2.X3),
(SELECT T2.Date,X2,X3 FROM Y_GetDisplayData(@Param) T2
WHERE T2.Date>T1.Date AND T2.Date>=T1.Date)
FROM Y_GetDisplayData(@Param) T1
GROUP BY EVERY DAY ???--and here is epic fail
I can make all stuff on asp server :And C# allows me to use something like SelectCommand = IzmProc + "_GetDisplayData"; And then I will work (select special data) with DataTables on ASP.NET Server but it's better to make all on SQL ... But looking like it's just unrealizable on SQL >_<
I gonna think about C# realization,but my code is very weird , got errors and doesn't works >_<
public static DataTable GetReport(string Param)
{
System.Configuration.ConnectionStringSettings connSetting = ConfigurationManager.ConnectionStrings["FlowServerConnectionString"]; [code].....
I have a website in C#/ASP.NET that is currently in development. When we are in production, I would like to do releases frequently over the course of the day, as we fix bugs and add features (like this: [URL]. If you upload a new version of the site or even change a single file, it kicks out the users that are currently logged in and makes them start over any forms and such. Is there a secret to being able to do deployments without interfering with users for .NET sites?
View 5 RepliesHow can I put counter like this. [URL]. Is there any way to do this , we can do it via sql server triggers or else.
View 7 RepliesI need a Continuous integration tool that will support both .Net Unit tests and Javascript unit tests and perform the builds.It looks like my main options are CruiseControl.NET using JUnit and NUnit or Team City and JS Test Driver.
Are there any other options and which ones have you used or had good or bad experiences with.
