Search results for query: *

Thanks for confirming my original thought ... You saved me a good number of hours worth of work :)

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 ###-###-####?

Ok I will look into this, but is there any built in SQL function to generate a script from data output by a stored procedure? The problem is I don’t want to sync the two databases because one has old data. I need to just update these specific records.

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...

Thanks Crystal, i had the same problem for a few months, then by clicking save password it work!!!!! I gave up trying to figure it out about 3 months ago!!!

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...

no that should work, just make the parameters in your stored procedure the same as the parameters in your report and it will not include the other data in the calculations.

unfortunatly RS doesn't do anything with dates, one way you could do it is to create a date parameter for the month, then in the data tab click on the elipse and go to the filter tab. Enter your expression "Monthfield = Parameter" Then it will filter out all months that dont match the one...

i figured it out thanks

That idea is very sound; I just can’t get it to work in the Query Analyzer. My procedure looks like below: SET DATEFIRST 7 DECLARE @week1 int SELECT TOP 1 @week1 = datepart(wk,DATEADD(ss, actiondate, '01-01-1970 00:00:00')) FROM historyactions ORDER BY actiondate select...

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...

Hmmm i think that means is should work since all excel binary files are the same with minor tweaks to them. Reporting services doesn't even need to use any of these bells and whistles tho so i hope so, but i guess the only way would be to try. Do know when RS2005 is supposed to be released?

thanks the PDF suggestion worked. if anyone else knows about different verisons of excel please let me know

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...

wow it printed that twice huh thats strange...

Well the only thing i didn’t understand was "Before you overwrite a datasource (and yes, Virginia, Santa Clause does allow you to change that little "switch" when deploying, but you have to jump through hoops to find it), doublecheck with everyone to find out who created it and why it is set...