I have a active report and I need to group it on my country attribute. I have been looking around on the active reports API and came across grouping. Is this the best way to do this and how do I go about doing this?
View 1 Replies
I have a table in my oracle database, with the following schema: student(studentNumber,name, dateOfCreation).
dateOfCreation is the date in which the student record was created.
In crystal reports, I have to group the records into the following groups, using the dateOfCreation field:
Older than 4 weeks(Records whose dateOfCreation is more than 4 weeks ago). Between 2 and 4 weeks (Records whose dateOfCreation is more than 2 weeks ago, but less than 4 weeks ago). Between 1 and 2 weeks(Records whose dateOfCreation is more than 1 week ago, but less than 2 weeks ago). Less than 1 week (Records whose dateOfCreation is less than 1 week ago).
I have tried grouping in specified order using group expert
I have a query (qryTallyMedalInformation) that i bound on datagridview and it has 5 columns ( country, athlete, medal, game and date). Instead of having country in the datagrid, I want to use it in a combobox to display records base on country selected.what i did (with wizard) doesnt work fine though. My country combobox shows duplicate data and the datagrid is showing all the records from different country. In one word I JUST DID NOTHING.
View 12 Repliesis there anyway to retrieve and list all the attributes for an active directory user to be used for updating with using the following
de.properties.contains(propertyName)
Is there a way to manually set the pwdlastset attribute in Active Directory? I need to have an account in this state for testing purposes.
View 1 RepliesI'm writing a report in VB .NET (using Active Reports) that displays details about a location, and then displays a bunch of images, which are stored in a database. The images are displayed in my main report via a subreport. However, I can't get the images to load. I have two files, the main report (rptMain) and the image subreport (rptSubImages). The sub Detail1_Format in the rptSubImages never gets ran, which is why the images are not appearing, and I can't figure out why! I've included the code below... can anyone pinpoint why my subreport detail section isn't getting called? The rptSubImages report gets initialized, but if I put a stop point inside the detail sub, it never gets caught during debug.
[code]...
Im trying to detect if an active report has been closed to close the "main form". Basically what im doing is populating an active report from parameters passed to the main form then the active report is populated, once the active report is closed i want the form to be closed. However, i have not been able to find an event that will close both. Unless i close the mainfrom which inturn closes the active report, which i want to happen opposite.
View 1 RepliesI've been doing research on reporting suites for a project my company is about to undertake, and have narrowed the candidates down to Active Reports and Crystal Reports. During the demo yesterday, it was clarified to me that one of the capabilities our client would like is the ability for the end-user to create custom reports integrated into the Web-Based client. I know that both packages have options for integrating an end-user designer to a WinForms based app, but I can't find a definitive straight yes or no answer for either suite as to whether or not it's possible to attach them to an ASP.Net based app.
View 2 Replies64-bit Windows 7 Profesinoal running a project I have done vb2005. Reporting as a tool I'm using active reports 2.0. Normal data base connection is very slow. The first problem this.The second problem, none of my reports does not work. gives the following error:is not a valid Win32 application.
View 2 Repliesi added the COM reference to:Crystal Reports 9 ActiveX Designer Run Time Library 9.0 i have some code that prints a crystal report:
'print report
Dim Appl As New CRAXDRT.Application
Dim CrystalReport As New CRAXDRT.Report
[code]....
Code works fine on my Windows 7 64 bit computer because I have Crystal Reports 9 installed on that computer but i want this to work on other computers that don't have Crystal installed.I have published my app and installed it on another Windows 7 64 bit computer and it doesn't work.I think i need to have the craxdrt.dll install and register on the users computer.
how can i include this in my setup? I already include the Interop.CRAXDRT.dll when i publish (publish status: INCLUDE/Download Group: Required/Hash: Include) but it doesn't make a difference.i am using vb.net 2010 express?
I've got an intranet based reporting tool (VB.Net + ASP.Net Integrated Windows Authentication) that looks up users and managers from a SQL Server 2005 table to roll up the reporting to manager level. This table is currently manually maintained and I've been asked to make it more dynamic as it is going to be up-scaled for far more users. Therefore I'm looking to link in with the Active Directory to create an Org table in the back end which will replace the current manually entered one.I'm comfortable getting user data from the AD, but not so sure as to the best approach to set this up, I was thinking of the following table:
CREATE TABLE dbo.Employees
(
EmpID nvarchar(8) PRIMARY KEY,
EmpName nvarchar(30),
[code]...
EmpID will be the NetworkID (sAMAccountName).Then this will need populating from the AD, I'm guessing through recursive calls to fill in the fields. I'm then not sure how to structure the code so that it will capture every employee under every manager starting at a given level. I'm currently using the below to capture the direct reports for a given manager:
Public Function GetDirectReports(ByVal ADFullName As String) As ArrayList
Dim adItems As ArrayList = New ArrayList
Dim rootEntry As New DirectoryEntry("LDAP://" & ADFullName)
[code]...
In the Active Direcotry mmc snap-in you cant see attributes that are "Not Set". When you use ADSIEDIT.MSC tool, if attribute values are null you do see them as "Not Set". How can I set an attribute to "Not Set" in .Net code? Here is the answer in Powershell but I need to do it with some .Net code (VB.Net/C#). [URL] ps msExchHideAddressLists is the culprit attribute, when its True or False in this domain it prevents user information replicating from AD to Sharepoint.
View 1 Replieshere any algorithms/pseudocode for reading/parsing 3-column csv data and determining unique objects/attributes/values?
example data:
john,height,1.75
george,age,21
[Code]....
i have already implemented a solution of my own but it's too slow and i can't find any relevant literature on the internet.
Possible Duplicate: Unrecognized attribute 'targetFramework'. Note that attribute names are case-sensitive
I am using window xp and iis 5.1 to run the application.
error is occurred Unrecognized attribute 'targetFramework'. Note that attribute names are case-sensitive.
[Code]...
I get an error when I try to build my project.'SSLAccessFiltercannot' be used as an attribute because it does not inherit from 'System.Attribute'. [code]
View 1 Replieshow to resolve country name from ip address.
View 3 RepliesI was create a web services(Ip2Country)
i send my visitor Ip to this service and return his/her country information(like US|USA|United State of America)
and it's work correct.
BUT if our visitor connect useing (vpn or proxy) it does not work correct
Dim hostname As IPHostEntry = Dns.GetHostEntry(TextBoxIP.Text)
Dim ip As IPAddress() = hostname.AddressList
TextBoxIP.Text = ip(0).ToString()
I have a windows form with the code above to get the ip address of the user. what would be the easiest way to get the country location of the user? based on the IP in the textbox. The solution doesnt need to be 100% accurate but good enough to work most of the time. the simpler the better.is there are any work arounds or built in fuctions for pulling a users country or language, this would be better than creating or managing a giant database.
I have the following code which reports the users Ip address but need to display another textbox which the country of the IP belongs to.[code]...
View 2 RepliesI have written simple code to determine country location using the suffix on the url eg..cn, .se, .br etc. even if its possible to determine country or location using urls that end in .com or .net? I was just reading up on something and found online apps that can determine location/country from the ip so how would I determine the ip or look it up using the url? can I do this in .net?
OK
So I have the following code and I get an exception when the url is invalid or faulty, can anyone help me to catch the error and add the url to another list and continue with my loop.
Public Sub getIpAddress(ByVal querylist As ArrayList)
Dim IPList As New ArrayList
Dim badList As New ArrayList[code].....
I'm trying to get user's country and continent, in VB.NET.
View 4 RepliesI have a csv file with countries and their IP ranges. The numbers are numeric representations of the dotted IP address, calculated with the following formula.[code]...
View 4 RepliesI am creating reports in Crystal Reports that is integrated within Visual Studio 2008, and I noticed that some of the features are disabled. One is the ability to link tables with a Right Outer Join or Full Outer Join. I also cannot "Show SQL Query" in Crystal Reports. Is this something I can enable or do I have to purchase or upgrade?
View 1 RepliesBasically, I am looking for a method on how to preview reports from a datagrid or it can be from the access database which populates the data to the datagrid (then displays this in the datagridview) in vb.net vs 2010.I believe there are two methods using the ReportViewer or using Crystal Reports, but so far, I have no idea how to get them to work. The first idea would be favourable - using the data from a datagridview (which may of already been sorted, filter etc) and be able to produce a report on that.
View 1 RepliesI am able to have checked menu items show the variables that I need to show, but they don't uncheck themselves unless I go back and click them. I want to have only one checkmark on a country at a time...is there any way? I've tried if...elseif , but that doesn't work....example below (If I only want Mexico checked and NOT United States, but both are checked still).
If MexicoToolStripMenuItem.CheckState = CheckState.Checked Then
UnitedStatesToolStripMenuItem.CheckState=CheckState.Unchecked...
End IF
I know you can get a currency symbol or a data format for a country using System.Globalization. However, is it possible to get the phone number format for a country from it as well. If not is there a way to get this information from the .NET Framework?
View 11 RepliesI've searched around but can't find a clear answer for this. From my winforms VB2010 app, I'd like to be able to detect the country of the user's PC at runtime. Specifically, all I really need to detect is whether the user is in Australia or Canada.Most things I've seen will say "have a look at System.Globalization.CultureInfo", but with no clear example. I also know that the old-school "GetLocaleInfo" API can be used for this as well. I do have some code using the latter, which detects Australia when LOCALE_ICOUNTRY returns a value of 61. However, that won't work for Canada, as it returns 1, which is the same as USA (I know that these are based on telephone country codes).
View 8 RepliesI have fourm with a drop down box which has 4 things in it. e.g property, unlisted, listed and i have another drop down called country with a list of countries. what im trying to do it when someone click on the unlisted from the first drop down and tries pressing ok i want a pop up to say have to fill in country.
View 1 Repliesi am developing an application in vb.net having crystal reportsi have stored all my reports in a folder called report in my applicationbut initally when i executed i got a error msg like the report doesnot exixts in debug folderso i copied all the reports from report folder to debug folder & its workingany changes that i mke in report folder needs to be copied into the debug folder alsois it possible that the reports be executed from reports folder only & not from debug folder as everytime i need to make changes in the debug folderhow can i chnage the path to reports folder
View 1 RepliesPlease anybody help about how to create two dynamic combo box. Like Country and province.. when I select country conutry Combo box then Province Combo box automatically show same country province.[code]
View 5 Replies
