New to CR - Support Request

[Former Member]

Hello:

I am new to Crystal Reports, and have gotten a good start to creating some reports, but have some basic questions that would be very helpful. Is it possible to have somebody look at a couple reports I have started so  I can ask basic questions?

Thanks.

Andrew

[Former Member]

Hello Ted: Thanks for your response. My questions are essentially: 1) I have set up what seem to be appropriate filters on reports, but there is consistently a few pieces of data missing that should be there, not sure what I am missing; 2) Need to learn how to add three fields together to sum to a total field; 3) There are some custom fields in our database that I am having trouble putting into columns instead of rows (i.e. for one interaction with a client, there may be 10 data fields we collect data on, but they display on the report as 10 rows instead of 1 row with 10 columns). Not sure this makes much sense without being able to see what I am talking about, but hoping for any help to get me started. Thanks much. Andrew

[Former Member]

Andrew,

1.  What are you using for a data source?   A stored procedure / Command    or directly from the tables?   Why do think  they " should be there?".  if  you can't find the data fields in the explorer then they will need to be added ( retrieved from the data source )

2. You should be able to use a formula to add the three different fields together, assuming they are all the same data type,  are all on the same "row" in the same section and don't need to be converted.   Can you show us a screen shot of the issue ? 

3.   It depends on the structure of your data.   Look into how the table with the custom fields is linked to the client Id number.   The relationship between the tables is what determines the number of rows and columns that appear in the report.   I'd need to know more about how the data is stored to give you a more exact answer.  

[Former Member]

Andrew,

I'd be glad to help you out.

you can post your problems here on the forum and then anybody can answer  or If you prefer you can contact me directly.

( Go back to the Overview page -   I'm on the list at the bottom left  and look at my profile for my direct email address   -- or just right click on my name above )

I'm in the US  -  eastern time   ( this is a world wide forum )

Ted

[abhilash_kumar]

Hi Andrew,

Please post your questions here and I'm sure someone will assist.

P.S: Please note that these are community forums and not SAP Support. So, there could be delays in getting a solution.

-Abhilash