Search results for query: *

When I return a query is there a function in RS like in Crystal to separate the data into defined time intervals in the report?? Is this something that must be handled in the SQL query? Any help would be much appreshiated!!!!

I have the user entering in a phone number as a parameter. When the click the report it filters by this parameter. By default when i print what parameter that entered on the report it looks like this ##########. How can i format it to display like ###-###-####?

Currently I have a QA database and want to update 8 records in one of the tables. I have it updated in my dev environment and created a stored procedure to see new 8 new records. I was looking for a SQL function that could generate this output of this stored procedure as an sql script so I...

I have two complex databases each with over 100 tables. We have a DTS process that runs every night to update some tables with key performances so our clients can create their own reports with ease. Each of these tables is populated by a stored procedure that calculates and puts these key...

I have two complex databases each with over 100 tables. We have a DTS process that runs every night to update some tables with key performances so our clients can create their own reports with ease. Each of these tables is populated by a stored procedure that calculates and puts these key...

Hope someone can help me with this. I have two complex databases each with over 100 tables. We have a DTS process that runs every night to update some tables with key performances so our clients can create their own reports with ease. Each of these tables is populated by a stored procedure...

Hi! I am running a DTS job, and the last action is to run a report on all the new data. I need to pass it two parameters from the DTS job. I wanted to pass them through the vb scrpit but dont know how i can set the report up to take those values and use them to populate a data set. Anyone...

Is this layout possible in RS using a matrix? The user enters in report parameters for the start and finish date (which could be any amount of time). Then how can it get the format of the report to print in the following way. The weeks would need to be Sunday to Saturday and be labeled week 1...

The documentation gives no option for this but maybe someone has a creative idea. When I export the report it goes into excel version 10, which can only be read in excel 2002 and 2003. Some people that try and read these exports still have excel 97 or 2000. Is there a way to automate this...

Someone please put me out of my misery!!! Ok i have a report where i have a group for projects and then inside that group is the interaction types for each project. Each row then has a value called actionid which is the type of action and duration the length. All i want to do is get the...

I want to make a running total on my report to total the amount of sales for each agent by project. I have it grouped by project (group 1) and then by agent (group 2). I am printing each record in the details section and then want to have a sub total at the end of each agents sales in the...

How can i display the current date my report is being run?

I am attemping to build a report that show the average talk time for each project. The data looks like this projectid actionid type duration 1 33 47 34 1 22 47 43 1 33 47 55 I want to take all of the...

I have a report that totals the number of interactions for each way of communication to our company (email, fax, phone, etc) and then totals it at the bottom. Now i am trying to make another column next to it to show what percent of all interactions each way represents. The formula should...

My company wants to move all their reporting in house, is there a way to move all the crystal reports we currently have into sql reporting services since they both use vb .net 2003 as their report designer?

I am running crystal in vb .net 2003 on a sql sever. I have this report, but as more and more entries are being added to the database the report is going slower and slower, and sometime now i don’t know if it stopped or not. I heard if you implement SQL queries into your report for a lot of...