Search results for query: *

I am using crystal reports xi and sql server 2000. I have a report with two dynamic prompts and a stored procedure with two prompts. How can i pass the promp values chosen from crystal reports to the stored procedure? any help will be appreciated..

hariomhari... first of all please be specific about ur question.. which version of crystal reports/business objects u r using....and what do u want to do exactly... considering the fact that this is a forum for crystal reports im assuming u r using crystal reports as ur report development...

I think u can do it.. I would follow below steps if i were you: 1) create date parameter asking user to enter a range of dates 2) create formula for my date column and check the range values from paramter e.g: table.datecolumn between minimum({?dateparameter}) and maximum({?dateparameter})...

i think u can do it... u can use excel as ur source for the report by making new connection to that data source navigation: database expert>creat new connection>ms access/excel(dao)

Hi Harki06... I am also looking for a way to use combination of parameters,crystal reports and stored procedures. In my case i need to pass some paramters to the stored procudure..I read ur post and understood that U already did that.. could u pls let me know how to pass parameters from crystal...

I am getting an error "[Microsoft][ODBC SQL Server Driver]Syntax error or access violation" when I am executing the following stored procedure... SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO ALTER PROCEDURE UPDATE_AGENCY_TM @AGENCY_NAME NVARCHAR(50), @SALES_REP VARCHAR(15)...

I havent' seen such feature in crystal reports alone itself. But I believe you can do it programmatically by using RSA SDK.

Nope....I haven't tried..i think it's time to upgrade..

Could you be please more specific.. if you could give an example of the fields that u r trying to do..it helps me to answer your questions..

You are welcome... which version u r using by the way..

Andrew, Thanks for the reply. Except 4 or 5 users, all others should have rights to view the reports throuh infoview. In this case still do I need to purchase additional licenses. thanks, Nelson

Yep, Just copy the whole query into one command. And when you go to field explorer, you should be able to see all the columns by clicking command.

Janet, Below code might help you out.. i might have missed couple of open/close braces... cheers select sum(case when HEAT.CallLog.CS_Application = 'Encore' OR HEAT.CallLog.CS_Application = 'Encore Timeline Tracker' or HEAT.CallLog.CS_Application = 'Encore Encounter...

I am using Crystal Reports Server XI. I have a list of users around 40 who need to have access to view the reports via infoview. the error im getting after adding 5 users is "There was an error while writing data back to the server: You do not have enough Named User Licenses to make this...