Search results for query: *

I think you can schedule a job on the destination sql server and execute the 1st part of the syntax below. The 2nd part is what actually gets sent to sql server. You will also need to make sure you kill all users in the db that is being restored prior to the restore. I --syntax to restore...

Thanks for the reply ookete... Here is a solution I found that seems to work. I added a textbox in the footer and added this expression: =Sum(iif(Fields!Status.value = "Value a", Cdbl(Fields!Payment.Value), 0.0))

I need to sum the values (in detail section) where another column's value is = "value a" and ingore/don't sum where <> "value a". This sum is going in the group footer. Payment Status 10.00 value a 12.00 value b 8.00 value c 10.00 value a total: 20.00

DreXor, Thanks for the quick response, when looking at the links provided it looks like I am doing everything correctly. Here is my stored proc. In query profiler I can see that the proc is being executed with the correct parameter. I am so confused????? CREATE PROCEDURE dbo.usp_GetTest...

I have a stored procedure that I know is executing (sql query profiler) correctly and returning results however I am having problems filling session varables with the results of the recordset. Why am I doing wrong with the recordset? set objConn = server.CreateObject("ADODB.Command") set...

What is the difference between the following other than one is using a stored proc? The first one works and the second one does not. set connect = server.CreateObject("ADODB.Connection") Connect.Open strConnect sSql = "SELECT * from Test where loginname = '" & session("userid") & "'"...

Still trying to get this right, I have revised it a bit but it still does not work. I have used query profiler to verify that the stored procedure is not executing. Set objConn = Server.CreateObject("ADODB.Connection") set objCmd = Server.CreateObject("ADODB.Command") objConn.Open...

vbkris, Thanks for the reply. Any idea what is wrong with the syntax I had posted?

All, It's been a long time since I have worked with asp and I can't figure out what I am doing wrong. I am trying to execute a stored procedure and store the results in a session variable. On my .asp page I have a include file<!--#include file = "../common/Connect.inc" --> The Connect.inc...

I have a report that I need to modify the SQL. I have two tables, Table A has a datestamp and Table B list every day of the year with a time value of midnight. I need to link the two but since all of table B's time values are midnight I can't find a match in the Table A. I have tried to...

Is is possible using CR 8.5 to create a formula to change the color of individual bars in a bar chart? For example I need to change all the bars < 90% to red. If CR 8.5 can't do it does 9? Thanks

I got everything working. Thank you for all of your advice.

I have 10 individual reports that I need to combine into one weekly report package. I need to be able to export these to pdf as if they were one report. I have never really used sub reports before but I thought this may be my solution? If this is possible how would I set up a main report that...

I have thought about doing what you have suggested but the reports I created have a lot of grouping, supressing and formula's that are much easier/faster to create in Crystal vs ASP.

My company has a policy that does not allow web servers to map to printers. I have several reports that I have created which are very wide(they contain 30 plus fields). I thought if I mapped to a plotter printer from my desktop computer it would give me additonal width, which it did. I now...

I am using the the hour function as follows: hour({tablename.open_date}). I am using this in a chart to display calls that were opened by hour & every hour is diplaying 8.00, 9.00 etc...and I can't get rid of the trailing zero's. If I convert the formula to text and trim the zero's it does not...

Thank you both for your help.

Naith- If I implement DISTINCTCOUNT({CALL.CALL_ID},{TECH.FULL_NAME})and put it in the Group2 section I still just get the opened call count for each Tech for each item in Group 1. If tech1 had 5 calls opened for less than 15 days(Group1) and 10 calls opened for 15-29 days(Group1) I need the...

Naith I am just doing a distinct count of the call_id's for each group. My first group is grouping the calls by the amount of time they have been opened and the second group is grouping each Technician that opened the call in the first group. I need to find a way to total the calls for each...

I cannot find a way to calculate Grand Total Calls below. I have the Technician Calls total's for Group #1 below. I need a way to sum ALL of the Technician Calls total's for each technician, overriding GH#1 or count every call_id(unique field) for each technician, overriding GH#1. The details...