Search results for query: *

I have a Crystal 8.5 report which has part of it being grouped on a team field. I've had it sort this group to display in a specified order by named groups. In the Others tab of the group options window I've selected "Put All others in the group named:" and typed in "Other". In spite of...

*gnaws on Mouse cord* Recently reintroduced to querying SQL, and at an absolute loss on how to get it to only feed me records for the 12 months prior to the current month (last 12 full months in other words)based on a datetime field in the database. I can get it to do this year and last year...

We just installed Crystal Reports v 10. Upon opening a report created in 8.5 and trying to preview it, I get sent into a string of verify database messages like the following: Upon clicking through I eventually get to an updated message: Clicking through this starts the messages all over...

I need a means of counting only the number of records which do not have a null in a specific field. ie, there needs to be a value of 1-5 in Field X for the record to be counted. I then need the total number of these non-null records. Any idea how to accomplish this?

Crystal reports 8.5 dilemma. I'm at my wits end here. I've tried to set up a record sort to only show records from the last 12 months, but although it worked the last time I had the report open, now whenever I refresh the data it goes back to drawing records from all the way back to April of...

I've tried a bunch of different things, but I can't seem to get this 8.5 chart to sort by ascending date. I can't use "specified order" as this is specifically reporting date for the last 12 months, and that will change as time passes. Right now it tries to sort numerically or alphabeitcally and...

Using Crystal 8.5. According to Crystal Help, the LastYearMTD function does the following: "Specifies a range of Date values in the previous year that matches the current month to date." I'm trying to use it as a stepping stone to reporting based on activity in each of the last 12 months. We...

I'd like to shoot whoever set up our database, but there is no full name field, nor any comprehensive field that would be unique enough to make a selection with a parameter which has LastName, FirstName of employees. I can put in a manual list of them, but how would I then get it to select...

I'm a beginner who has only had a crash course in CR 10 and is working on CR 8.5. The report I am writing has a parameter to select which sites you wish records from based on a field with that data in it, but I also want to add an "ALL" option so that they don't have to manually add all the...

Just when you think your app is perfect, the people you wrote it for add another little qualifier. At current, the SQL query below pulls the required info for all records in the database, and orders them by ResearchID: SQLStmt ="SELECT R.CreatedBy, R.ResearchID, R.AccountName...

I'm posting this here and the Javascript forum at the recommendation of someone in the ASP Forum. Although I'm more familiar with VBScript, I'll gladly look at any javascript solution. I have an ASP page with a form in it. In the form there is a text input box for an account number. Users can...

I'm posting this here and the Javascript forum at the recommendation of someone in the ASP Forum. I have an ASP page with a form in it. In the form there is a text input box for an account number. Users can enter multiple account numbers in it and often do. The department using the app wants it...

I have an ASP page with a form in it. In the form there is a text input box for an account number. Users can enter multiple account numbers in it and often do. The department using the app wants it to check that only numbers and spaces are in that box. I've got code to check for numbers only...

I've been developing a web-based application revolving around a SQL dB, and up until last week, it was working just peachy. However, within the last week, it seems to have entirely ceased to be able to initiate a session. The app needs to start a session, to gather some session info based on a...