Well found out i just need to recreate all the reports guess the Update Datasource location doesnt work so well
demitrix
@demitrix
Best posts made by demitrix
Latest posts made by demitrix
-
RE: Crystal Reports: Logon Failed
-
RE: Crystal Reports: Logon Failed
Heres some background. I wrote an application in C# for my work place. Due to the fact that i didnt have access to the SQL server at the time i used one at my house. We moved the database in house now, but now users are getting a "Logon Failed" error when tryin to view reports.
Initially they are prompted for the SQL password but when entered its returned as incorrect. This is where things get screwy, it works on my machine at work, it works on a friends machine at work, but not on another person machine. So it seems to not be permissions since some work and some dont.
On to the methods of auth ive tried.
Tried setting login info on the report viewer itself.
Tried .SetDatabaseLogon() on the report itself.
Tried looping through all tables and setting connection info.
So whats left that i can try? -
Crystal Reports: Logon Failed
Heres some background. I wrote an application in C# for my work place. Due to the fact that i didnt have access to the SQL server at the time i used one at my house. We moved the database in house now, but now users are getting a "Logon Failed" error when tryin to view reports.
Initially they are prompted for the SQL password but when entered its returned as incorrect. This is where things get screwy, it works on my machine at work, it works on a friends machine at work, but not on another person machine. So it seems to not be permissions since some work and some dont.
On to the methods of auth ive tried.
Tried setting login info on the report viewer itself.
Tried .SetDatabaseLogon() on the report itself.
Tried looping through all tables and setting connection info.
So whats left that i can try?[ moderator's note: pre tags removed. have a nice day. ]
-
RE: Text Import - C#
Right sorry didnt know i had to use HTML tags in my post.
Im working on a program that was originally written in Access/VB that imports a text document to a database. Each text document has several thousand lines like so..
"AN0","37","M","6/1/2008","F","A","S","N","Y","","",".058",".1188","41.66",60002,"False",1022
I need to get a count of how many lines have the certain letters in the first string, so in this case i need 1 to A, N, and Zero. The rest are just matching the string to something then incrementing its value. Right now im using two arrays like so...
char[ footnotecode = { 'A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z', '+', '0', '1', '2' }; int[ footnotevalue = new int[footnotecode.Length]; foreach (char c in contents[0]) { if (footnotecode.Contains(c)) { footnotevalue[Array.IndexOf(footnotecode, c)]++; } }
For the rest of the items its just the If statement with no need for the foreach. While this is a huge improvement over the case statement monster that I replaced I still feels theres a better way to do it. If i havent made it clear enough let me know and ill provide any details. -
Text Import - C#
Im working on a program that was originally written in Access/VB that imports a text document to a database. Each text document has several thousand lines like so..
"AN0","37","M","6/1/2008","F","A","S","N","Y","","",".058",".1188","41.66",60002,"False",1022I need to get a count of how many lines have the certain letters in the first string, so in this case i need 1 to A, N, and Zero. The rest are just matching the string to something then incrementing its value. Right now im using two arrays like so...
char[] footnotecode = { 'A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z', '+', '0', '1', '2' };
int[] footnotevalue = new int[footnotecode.Length];foreach (char c in contents[0])
{
if (footnotecode.Contains(c))
{
footnotevalue[Array.IndexOf(footnotecode, c)]++;
}
}For the rest of the items its just the If statement with no need for the foreach. While this is a huge improvement over the case statement monster that I replaced I still feels theres a better way to do it. If i havent made it clear enough let me know and ill provide any details.