Search results for query: *

Not sure what you are trying to accomplish. It is true you cannot put a sub report in a text box. You can put a sub-report in it's own section. Then use section options to control the behavior a little bit.

I had the driver at one point. But apparently deleted it. Surfing IBM's site is hopeless.

First off it appears you are trying to assign a value to a field and that is not possible. You can create a variable (lots resources on how to do that) and assign that value to the variable, which in turn can be displayed in the report. So I believe this is what you want. In this case...

Check for the padding for the box. I normally set it to zero for all four sides.

I have also used the len(textfield) = 0 to check for NULL (got that from someone else). Sometimes a text string from the DB is not evaluated as NULL

I think there is a way to utilize FileAuthor in a query. But I do not recall how it is done (I believe I read about it years ago). Did you look at the query it generates when you do the drag and drop method? So further research seems to show that FileAuthor cannot be used in a query (Not sure...

In any section after the section the sub-report is in and the section the sub-report is in cannot be suppressed.

Okay. Another round about way is to copy the text into Notepad or Notepad++. That should remove any link back to the original text. Then copy into a text box into Crystal. We have had the issue in the past where we copy from a PDF document and Crystal creates a OLE object.

I have never seen that behavior. Do you have a way to print to another printer to see if the same issue happens on that printer too?

I am thinking that the buffer memory of the printer is small. But that is a real guess.

Everything appears to be correct, have you verified that the unitprice is indeed getting the correct value in sub-report (i.e., display the value in GF 1B)? Second, make sure that unitprice is not any other formula where the value could be modified.

Andrzejek : You would need a second cast so that you can to the concatenation; Cast( CAST(dbo.Product.Thickness As Int) as varchar) + 'x' + cast(CAST(dbo.Product.Width As Int) as varchar)

One way would be to use Charindex (some might know it as instring). Something like this (not tested) left(CAST(dbo.Product.Thickness AS varchar), Charindex('.',CAST(dbo.Product.Thickness AS varchar))-1)+ ' x ' + left(CAST(dbo.Product.Width AS varchar), Charindex('.',CAST(dbo.Product.Width AS...

Unfortunately I have translations from other languages to English to be less than perfect on some installation manuals.

There could be so many reasons for the application to crash (including a corrupt install). Very difficult to determine the root cause. It appears that you are using the 2011 version of Crystal. From what I recall, that was a pretty stable version of Crystal Reports.

So a couple of things to consider. Any value you want to pass from a sub-report to the main report. The sub-report has to be in a section prior to where you want the value. Second the sub-report cannot be suppressed (if you want to 'hide' the sub-report, there is a way to do that). The value...

What we have to do is create a ODBC connection using the Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.slsb), we are currently using verson 16.00.14701.20038.

I have heard of third party tools that might be useful, but we have never used them.

You cannot really do that and I do not see the purpose since the queries look the same. If you the queries where different you could use a join.

Your requirement does not make sense. If description = 'ARM SHANK' then shakeweight if description = 'ARM SHANK' then armweight Of course you can always use a case statement on the description to return what you need.