Showing posts with label requires. Show all posts
Showing posts with label requires. Show all posts
Friday, March 9, 2012
recover a stored procedure
If I can't connect to my database and my test server requires a reinstall of SQL Server 2005, how can I get my one stored proc out of there and back it up if I can't even connect to my database? Is there a file that is created that may have this? I know it's probably stored in master or something but not sure if it can be recovered.Before reinstalling the SQL Server, make a copy of the database files (.MDF and .LDF) in which you created your stored proc. When the new instance is installed, attach the DB and retrieve your stored proc from there.
Saturday, February 25, 2012
RecordNumber field Q...
Greetz. . My problem is: I'm kinda unfamiliar with both Crystal Reports and VBasic as well .. and yet, my job position requires me to do the following:
I have a report which draws it's data from an SQL Database .. Depending on the data in the database ( table ), the report may have as little as 1 or as many as 30 or more records generated on it. Now, what I need you guys 2 help me with is .. When the special field RecordNumber reaches a certain value ( 20 for example ), I should somehow ( that's where you jump in ) tell the report to pass the remaining data onto the next page.
Now, I've tried 2 do something like If fldrecno.value > 20 then report.newpage ( where fldrecno is a name of the recordnumber field ) but I keep getting the same message Runtime Error 424, Object Required. As I said, I'm a newbie in both CReports and VBasic (6.0) area .. and any help would be more than appritiated.
If the problem cannot be solved using the recordnumber field, maybe a formula might help. Again .. I don't know much about formulas either.In the Crystal report's Design window,right click the left panel of "Details" ,in
Format section --> New page after -->Formula Editor(X+2 button) , write this code and try
RecordNumber>=(PageNumber*20)
I think you can pass a variable instead of 20...:)|||In the Crystal report's Design window,right click the left panel of "Details" ,in
Format section --> New page after -->Formula Editor(X+2 button) , write this code and try
RecordNumber>=(PageNumber*20)
I think you can pass a variable instead of 20...:)
Otherwise write this code
RecordNumber mod 20=0|||Thnx a bunch! It works .. and it works fine ..
I have a report which draws it's data from an SQL Database .. Depending on the data in the database ( table ), the report may have as little as 1 or as many as 30 or more records generated on it. Now, what I need you guys 2 help me with is .. When the special field RecordNumber reaches a certain value ( 20 for example ), I should somehow ( that's where you jump in ) tell the report to pass the remaining data onto the next page.
Now, I've tried 2 do something like If fldrecno.value > 20 then report.newpage ( where fldrecno is a name of the recordnumber field ) but I keep getting the same message Runtime Error 424, Object Required. As I said, I'm a newbie in both CReports and VBasic (6.0) area .. and any help would be more than appritiated.
If the problem cannot be solved using the recordnumber field, maybe a formula might help. Again .. I don't know much about formulas either.In the Crystal report's Design window,right click the left panel of "Details" ,in
Format section --> New page after -->Formula Editor(X+2 button) , write this code and try
RecordNumber>=(PageNumber*20)
I think you can pass a variable instead of 20...:)|||In the Crystal report's Design window,right click the left panel of "Details" ,in
Format section --> New page after -->Formula Editor(X+2 button) , write this code and try
RecordNumber>=(PageNumber*20)
I think you can pass a variable instead of 20...:)
Otherwise write this code
RecordNumber mod 20=0|||Thnx a bunch! It works .. and it works fine ..
Subscribe to:
Posts (Atom)