Crystal Report2008 Excelsius Integrated

[Former Member]

Hi experts,

I face a problem trying to connect CR data to excelsius, and don't know how to solve.

Here is my case :

I have an Excelsius file with a Variables Flash connection configurated.

I have 2 variables : REALISE et TITLES

In CR2008, I create 2 formulas, and i wonder how I have to replace the "quo;quot" :

formula 1 : for REALISE

global stringvar ValuesString;

if (ValuesString = quot;quot;)

then ValuesString := Cstr({@Réalisé})

else ValuesString := ValuesString + quot;,quot; + Cstr({Table1.Market Share}); ValuesString

Someone can help me ?

Tks

Olivia

[Former Member · Accepted solution]

In what way are you trying to connect CR and Xcelsius?

Are you linking from CR to Xcelsius and passing the values to FlashVars in Xcelsius? If so, what exactly is the value that you're trying to send? Is it:

quot; quot;

?

[Former Member · Accepted solution]

Hi David,

Thanks for your reply.

Yes, I use the Flashvars to connect Excelsius to CR2008.

I create to Variables :

- Réalisé

- Titles

(As I found an help over the web...)

My CR Report is a P&L with lines like this :

1-Recettes

2-Charges

3-Ebitda

etc....

And a cR variables @Réalisé allows to retrieve the value.

In CR, I found (through that paper) that I needed to create 2 formulas, :

- One for the value

- One for the titles

I named those formulas with the same name as in Excelsius : "Réalisé" & "Titles".

This paper said that the formulas have to look like this :

- For the value :

global stringvar ValuesString;

if (ValuesString = quot;quot;)

then ValuesString := Cstr({Table1.Market Share})

+else ValuesString := ValuesString + quot;,quot; + Cstr({Table1.Market Share}); ValuesString+

>>> In my case, I understand that "Table1.Market Share" could be replaced by "@réalisé"

- For the Titles :

global stringvar TitlesString;

if (TitlesString = quot;quot;)

then TitlesString := Cstr({Table1.Company Name})

+else TitlesString := TitlesString + quot;,quot; + Cstr({Table1.Company Name}); TitlesString+

>>> In my case, I understand that "Table1.Company Name" could be replaced by "Table.Libellé"

I am not a coding developper. So I did not really understand those formulas and try to transpose them in my case.

In the case of the formulas value, do I need to replace "quot" by the list of my values ? That sounds strange to me, because, I want to be dynamic those figures.

At the end, when I change the point of view of my CR report,I want that the Excelsius I have Integrated also move and update the figures with the new ones.

Is it clearer ?

Thanks for your help,

Olivia

[Former Member · Accepted solution]

Aaah. Don Williams I think this is a Crystal question.

Olivia wherever you read this, something was wrong with the display of the text. I believe the code should be:

if (ValuesString = '')
then ValuesString := Cstr({Table1.Market Share})
+else ValuesString := ValuesString + ',' + Cstr({Table1.Market Share});
ValuesString+

That is, where you see quot; the person that wrote the article would have used a single quote.

The logic of your code then is saying: If there's nothing in this variable already, then just put the current record in there. Else, (if there is already something in this variable) then put a comma after it, then add the current record to the end.

[Former Member · Accepted solution]

Thank you for your helpful answer.

[former_member11696]

Moved to Excelsius forum