Search results for query: *

its ODBC Connection on my report designer. But how will CE knows that?

Thanks Turkbear for replying. Yes, my datasource for the report is on a different server and on a different port number. Its on 2433 instead of the normal 1433 port number. Yes, i did set the database login info. My database is in Sqlserver2k, ODBC connection. My CE is in version 10.

Hello, CE10 Crystal Report XI I have a report in CE that is on different server and port number(2433). How can i specify it on CE when i upload my report? On the designer the report is running perfectly but i can't run it on CE and gives me database logon error. Does anybody have an idea...

Need your help desperately!! SQLserver 2000 I would like to use the bcp command utility at the end of the stored procedure when it run successfully, but i found out that i cannot use this utility to execute this thru the master..xp_cmdshell due to a security since i am not part of the...

so, does it mean that the proxy account is not limited only to scheduling jobs? Can you please confirm that and do you have a link on the msdn that i can show to our DBA? Thanks again!

Thanks Jamfool! Yes, our DBA says we can use a proxy but we can run the job thru scheduling only. Is there a way to run this stored proc as a proxy by running my xp_cmdshell above?

I have a stored proc that has a line: exec master..xp_cmdshell 'bcp "SELECT * FROM ##temp_ac540"' but since i am not an sa and there's a company policy for sa account, is there another way that i can run this from not being an sa. Please help!! Thanks in advance.

Hello, We have to create a new report (Crystal XI) but the source of information is a view in Oracle that can be access thru the linked server in SQLServer2005. If i am in query analyzer in SQLServer2005 i can see the view. But how do i do that in Crystal Report? How can i connect to it? Any...

Hello, I am a newbie on Great Plains. My boss have asked me to create a report on security. There is an existing report in advance security by choosing a userclass and toolbar only, that is very close to what my boss wanted. Is there a way for me to find out how those reports are...

Hello, We have Crystal Enterprise v10 and currently running with SQL Server 2K. Now that we have the new database they wants us to move there. The problem that i am having is when i am trying to point to the new CMS datasource its giving me an error "failed to retrieve cluster name from the...

tsuji, the login window is not a form based therefore i am not sure if this will work. Please try clicking the url http://www.tristategt.org/member/online/graph.cfm so you will see what i meant. Is there any other way than sendkeys? Please advise. Thanks, AMA

Hi tsuji, Can you please expound on how to get controls of the webpage and set the username/passwd values? I am a newbie on vbscript. Hi mrmovie, thanks for your suggestion but i've tried that before and does not work. The pop-up screen for authentication is still coming up. Do you have any...

Hello, I am posting again my question because i am really desperate to find a solution to this problem. My vbscript is working but not when i schedule it to run on task scheduler and the session is not active. Please HELP!!!! Here's a snapshot of the script: set WshShell =...

I have a vbscript that logon to authenticated website. I am using sendkey and it is working. The problem is i need to schedule this task and the sendkey started to fail if my session is not active anymore. Please help!!!

I have to scrape data from a website that requires user-id and password. Please see this thread http://www.tek-tips.com/viewthread.cfm?qid=1145471 That's what i am trying to do. Please help how can i go around the passing of user-id and password. Any help is greatly appreciated.

hello, I have a vbscript that needs to run on a scheduled task. The problem is i am using sendkeys and it seems Not working on a scheduled task. How do i get around this? Please help!

Thanks markdmac! That's very helpful! You rock!

Hello, I'm a newbie on VBSCRIPT. I need to go to a website in which we have an account. My problem is i can't get pass the login page using my script. I don't know how to pass the username and password thru my vbscript. Here is the website that i need to go to...

The sp2 still did not solve my problem. I am only getting this error if i choose the SSL settings for LDAP. Any thoughts?

Crystal Enterprise 10 on Windows SQL Server Hello, I run the sp2 for Crystal Enterprise 10, but somehow it breaks my Crystal Report Viewer. Now i cannot view a report using ActiveX viewer. The window is giving me an error msg that says "The Crystal Report Viewer is unable to create it's...