Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
Performance Management
Lawson Business Intelligence/Reporting/Crystal
Automatically database connection
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
chaoticist
Past 24 Hours:
2
Prev. 24 Hours:
0
Overall:
5185
People Online:
Visitors:
244
Members:
0
Total:
244
Online Now:
New Topics
Lawson Landmark
LPL INSTR Functions
4/5/2024 8:32 PM
I'm writing a simple report using the Create R
Infor SCM
Translating 856 to get the ~ REF^CN^ field
4/3/2024 8:24 PM
We are trying to get the tracking number which is
IPA/ProcessFlow
Sample XML file create Flow
4/3/2024 3:43 PM
Hello everyone, I am new to creating XML files
Lawson S3 HR/Payroll/Benefits
bn105 error message
3/26/2024 6:40 PM
I need to change some of the set ups in our Life I
IPA/ProcessFlow
IPA executing Job
3/13/2024 7:08 PM
New to the IPA world and was wondering, can an IPA
Lawson S3 HR/Payroll/Benefits
Life Age Reduction on benefits plans
3/12/2024 7:15 PM
For our optional life we have an age based coverag
Lawson S3 HR/Payroll/Benefits
BN53.1 Add-In
3/7/2024 3:31 PM
We are migrating to Solstice. They require a
Lawson Business Intelligence/Reporting/Crystal
Domain Name Change
3/5/2024 7:45 PM
Our domain name needs to change and was hoping I c
S3 Customization/Development
Cobol calling Shell Script
2/29/2024 1:27 PM
Has anyone created or modified a Lawson Cobol prog
Infor ION
ION vs IPA
2/29/2024 1:24 AM
We had a person new to Lawson and Infor go to Info
Top Forum Posters
Name
Points
Greg Moeller
4184
David Williams
3349
JonA
3288
Kat V
2984
Woozy
1973
Jimmy Chiu
1883
Kwane McNeal
1437
Ragu Raghavan
1348
Roger French
1311
mark.cook
1244
Forums
Unanswered
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Prev
Next
Forums
Lawson Business Intelligence/Reporting/Crystal
Automatically database connection
Sort:
Oldest First
Most Recent First
You are not authorized to post a reply.
Author
Messages
wintergreen
Veteran Member
Posts: 93
7/20/2010 7:21 PM
When refresh data on the report for the first time, LBI will prompt the screen to ask user to enter ID and password to connect database. How to make it without asking user ID and password to connect to database? I have enter the ID and password under the data settings screen in the report administration and also tried to create a datasource but nothing work? I used SQL OLEDB connection. Any idea? Thanks
mark.cook
Veteran Member
Posts: 444
7/20/2010 7:28 PM
The stupid question that I know you've probably looked at but when you entered your user ID and password, did you select use the ID and password entered above?
Next what happens when youyou click view with data refresh, does it prompt you for a password?
Otherwise, I would start looking at the data connection to see if something is wrong there.
Just the first few places I would look
wintergreen
Veteran Member
Posts: 93
7/20/2010 7:39 PM
yes. I do... I entered a ticket to Lawson, but Lawson support hasn't figured out yet.
Chris Martin
Veteran Member
Posts: 277
7/20/2010 7:46 PM
Any relevant errors in the WebSphere or RAS logs?
Ruma Malhotra
Veteran Member
Posts: 412
7/20/2010 7:51 PM
In your override datasource have you tried the option "Use report data source"
and in when viewing report option use " Use the user-id and pASSWORD ENTERED ABOVE". Enter the user-id and password twice and save.
Also check to see whether the oledb connection on your datasource is successful or not.
wintergreen
Veteran Member
Posts: 93
7/20/2010 8:01 PM
Yes. I used both options, either Use Report Data Source or the datasource I created in the server administration. I only checked systemout and systemerr logs but they are fine. What else I need to check the logs? OLE DB connection should work because when I entered the ID and password on the prompt screen, it went though.
Matthew Nye
Veteran Member
Posts: 514
7/21/2010 4:37 PM
Are you certain the report you published didnt have "Save Data with Report" checked? Also, are you using windows authentication or SQL Server authentication?
Depending on what version of the Crystal RAS engine you have installed the RAS log files should be somewhere under the Business Objects folder under Program Files. Most likely in a folder called Enterprise or Crystal Report Server.
wintergreen
Veteran Member
Posts: 93
7/21/2010 8:39 PM
Where is the save data with report? I am using SQL authentication to connect the database.
Whenever the first time I refrest data from the report, it will prompt the screen - database Logon , Data Type - OLD DB(ADO), use ID , password. Once I enter the ID and password(the same one as I entered in the data source), it went through and won't ask me again for refreshing data but if I exit the report and re-open it and refresh it, it will pop up the database logon screen.
Matthew Nye
Veteran Member
Posts: 514
7/21/2010 8:45 PM
> Open the Crystal Report in Crystal Report Designer
> Click File
>About 5 items down will be a menu item that says "Save Data with Report"
if there is a Check Box next to this option you will see the type of duplicate login prompt that you are receiving. Just make sure to uncheck it, save the report and republish to LBI.
wintergreen
Veteran Member
Posts: 93
7/21/2010 9:23 PM
Matthew, thank you so much for your help! Yes, after I unchecked it, it works... I have been working this problem for 2 days and the Lawson support have not figured it out yet.. You really save me! Thanks a lot!
John Henley
Senior Member
Posts: 3348
7/21/2010 10:02 PM
Another LawsonGuru.com success story!=
ric9d
Veteran Member
Posts: 76
4/11/2011 1:43 PM
Im having the same problem, however this is with a canned report from Lawson. Any ideas? I have checked everything that has been mentioned in this thread.
Thanks! any help would be appreciated
Matthew Nye
Veteran Member
Posts: 514
4/11/2011 2:06 PM
As in a back office report? There are about 2 dozen different places LBO Reports can fail but Id start with permissions off the FTP users. Also check the IA150.log file.
You are not authorized to post a reply.