Multiple Starting Points

[dodgyone]

I have a sub report which links to the main report via an ID field and this works fine.

The sub report brings up a list of documents and a http link to open IE and display that item. The problem is that I need to get the user name and a permission key from an unlinked table in order to view the document. This table does appear to link in any way to the other tables in the database. Having an unlinked table brings up the 'multiple starting points' error message and the results become unpredictable.

Is there any way to get this data via other means? Perhaps write a separate SQL statement in the Crystal or VB code for example?

 

[dodgyone]

The only thing I could come up with is fudging it a little. In SQL Enterprise Manager I created a view joining the two tables together in a standard select query:

SELECT dbo.mSessions.eUsername, dbo.mSessions.mSOAPSession, dbo.OTHER.EFOLDERID, dbo.OTHER.Forenames, dbo.OTHER.Surname, dbo.OTHER.Title, dbo.OTHER.CompleteITAXRef, dbo.OTHER.ITAXRef
FROM dbo.mSessions CROSS JOIN dbo.OTHER WHERE     (dbo.mSessions.eUsername = 'the user name')

I then add this view to my CR report. This adds the user name and key to each record which isn't great but it works. Are there any major problems with doing things this way?

 

[dodgyone]

I'm still having difficulty with this one. Any suggestions? Thanks...

 

[IdoMillet]

Please clarify the problem. Do you need to identify the user name of the person running the report? Windows User ID or Database User ID?

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[dodgyone]

I have a series of linked tables. In addition to this is a user table which has no correlation or link to the other data at all. Within here I need to get the user name and a security id. I have a function which displays the user name so this data can easily be gathered. But I find having an unlinked table brings up the 'multiple starting points' error message and the results become unpredictable.

Thanks for showing an interest by the way.

 

[IdoMillet]

Just add a record selection condition that restricts the unlinked table to the user name (provided by the function you mention).

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[dodgyone]

Sorry for sounding stupid but I'm not quite sure what you mean. It's early days for me with using CR. Could you elaborate a little? Thanks...