How to fill a field in crystal reports

[marcello62]

Hi there,

I have created a crystal report based on a dataset. In the page header, I want to display the name of a user, who can be known in code at runtime but who is not registered in the database. I'd like to know if there is a method to get this information in a textfield in the pageheader, without having to perform all kinds of difficult tricks to get the username in the dataset, where it really does not belong.

Any help will be greatly appreciated.

Thanks

 

[IdoMillet]

If you mean the Windows user id, there are UFLs (user function libraries) that add such a function. See list at:

http://www.kenhamady.com/bookmarks.html

Cheers,
- Ido

view, email, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[marcello62]

Thanks Ido,

But the retrieval of the users is not the problem. The problem is how to get them in a field on a report which is already defined - based on a dataset. So the report is a set of records from a database, and I want to pass the names as strings to a field in the report or page header.

 

[Madawc]

Do you mean that the name is in a dataset that cannot be related to the main dataset? If so, you could maybe fetch it using a subreport in the report header, passing it back as a Shared Variable.



Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[IdoMillet]

Just add a formula to the report.

Cheers,
- Ido

view, email, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[lbass]

If you want to manually enter the user name, you could create a string parameter {?UserName} and place it in the header. Then you would be prompted to enter the name with each report refresh.

-LB