Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. swenri1

    How to schedule a report automatically without changing the parameters every month the server ?

    Thank you for the reply. The parameters that I use are Select Measure = All Show Patient Data = No Start Time = 01-01-2013 End Time = 02-01-2013 Facility ID = -99 (All locations No filtration) No , I'm not using any sub reports ..... Thank you and I need your help urgently.
  2. swenri1

    How to schedule a report automatically without changing the parameters every month the server ?

    Hi All: I have a crystal report which has 4 different dynamic parameters which the user has to choose from How to I automate this report on the crystal server so that the report is generated automatically without the user requiring to change the parameters every month ? Thank you for all the...
  3. swenri1

    Help with CASE and CAST in a query

    solved the problem thank you
  4. swenri1

    Help with CASE and CAST in a query

    Hi , I’ve a report where I would like to use the CASE statement with different columns in one. Is it possible to concatenate both the columns with the same data type integer. Like for example in the report that I need to create I tried to use CASE statement as CASE...
  5. swenri1

    Hi I'm getting an error when trying to run the stored proc , this is very urgent

    Thank you for the reply but, it didn't work.. Can any one help me please ?
  6. swenri1

    Hi I'm getting an error when trying to run the stored proc , this is very urgent

    Hi, I'm trying to run a stored proc with Temp tables and when I run the stored proc I'm getting an error as shown below. Can any body help me please? I have permissions for the database and Temp Database also. All help is highly appreciated. Msg 102, Level 15, State 1, Line 4 Incorrect syntax...

Part and Inventory Search

Back
Top