Search results for query: *

Has anyone used Business View (BV) for row level security? What is the performance like with 100K+ rows of data? In CR 7.5, implementing row level security through the info view dictionary(?) used to have major performance problems and sometimes the application would even die while users...

Madawc, No, the text boxes do not have visible borders. However, if you try to hightlight a chunk of information, you can't because of boxes around text. Visibly, it is not a problem, only copying or selecting is impediment. So this issue is closed and our users will just have to tolerate...

Thanks Naith! I got a similar reply from CD but a word of caution too: "using the crxf_wordw.dll gives you the rtf formatted text when exporting to word. However, if you were to disable the crxf_wordw.dll and crxf_wordw_res_en.dll by renaming them to crxf_wordw.old and...

Through ePortfolio 8.5, I either export (after saving as crystal reports format) or save as word /rtf format. Both ways, however, both the word and rtf documents have little boxes surrounding ALL text. Each database or text box 'field' has a frame(?) around it. Anyone know how to make it all...

Henky, DCM is right in asking you to open and run the report in designer, once you get data through designer, it should come through on the desktop. You will also know if the table has been changed since report creation and fix it in the designer. If your database has no p/w but the Info...

See if Knowledge Base Article ID: c2002283, titled 'Scheduled Report fails with error "PEStartPrintJob : Cannot Open SQL server"' is of any help.

Is there a way to identify in the report designer the "Logon User Name" from the LOGON tab of Info Desktop? e.g. On the desktop, I can use the login id "UK01" or "UK06" while scheduling the report. In the designer, can I use a field that would identify the login...

The database field is in Date format, correct? I assume it works perfectly when all dates are hard coded? For troubleshooting purpose, where you know the data exists, use only one part of the formula to test your results just in case the error is being generated elsewhere and leave...

How about testing it more vigerously by hard coding the date and running it from Desktop? When you go to schedule it, is the statement showing up in the selection formula tab? as you entered it through the designer? are you refreshing it on the desktop everytime you make a change through...

Using Oracle, I use date parameters often in place of hard coded dates. It has always worked if I input date in the following format for date parameter: Date(2000,05,31). Also, you said you replaced the date with &quot;EmDateBeg&quot; <= ?, you mean &quot;EmDateBeg&quot; <= ?DateParmName...

Sorry, I am talking about Seagate Info 7 Desktop, not Seagate Crsytal Reports 7. I didn't know Crsytal Reports product was referred to as desktop.

You also might want to look at the FAQ section link to calculate business days between dates, that may be helpful.

I am not sure if storing them on their hard drive involves going through the desktop. In v7, on the desktop, you can store in p/w in report object by going into properties | servers tab | double click on the database logon row and you should be able to store both.

I don't think there is a difference function for date, you will probably have to do this manually. Though I don't have the specifics for you, the general approach would be to: convert each to just date format extract the year, month and day for each date and store in different variable subtract...

If you just want it for display purpose, you can tailor the following formula. My format is 01/01/2000 12:00:00AM, stored as string. first I seprate out the time: stringVar GetDate ; GetDate := right(GetDate, InStr (GetDate, ':') -3); then I get rid of the AM/PM: GetDate := left(GetDate...

I don't fully understand your requirements but wouldn't sorting first by 'another record' and then by start or end times help any?

I'm aware of one: the v6 Running Totals function dll's are not included in v7 so if you use them, either install v7 on top of v6 or ask Seagate to send you those dll's.

Thanks Malcolm!&nbsp;&nbsp;

You can achieve this by adding logic to a formula.<br><br>e.g.<br>have a parmeter that prompts for a name.<br>?Name<br><br>Create a formula that determines which column salesman is in.<br>@Name:<br>if {salesman_1} = ?Name then ....;<br>if {salesman_2} = ?Name then ....;<br><br>Or if you need to...

Scheduling it as Recurring on the desktop will do the same thing.&nbsp;&nbsp;You might need to set up a calendar if it doesn't already exist.&nbsp;&nbsp;This can be controlled through the Info Administrator.