Showing posts with label crystal. Show all posts
Showing posts with label crystal. Show all posts

Wednesday, March 7, 2012

How can it exactly look like a grid?

Hi

Im new to Crystal report and I want to make a report which look like a grid or spreadsheet. The report should be similar to the tables in MS word. I can show correct data from a view but when I try to add border to it to look like a grid, it look very silly. It is far from a grid look. So can anyone help me, How can I make a grid like report with crystal report V.9?

Thanks in AdvanceI had same problem and still I can not find any solution for it but at that time What I did was just by putting some graphic line in my detail field it was giving me view like perfact table

and at time I did try by using border on every field and no space between consequtive field and both was working for me but I choose 1st option for my solution just try to be more "desingner" instead of developer ,, Ha ha .. that's what I did...

Hey if you find any good solution for this let me know

Thanks and best of luck ..|||Yes better be a designer.
u can put ur fields in a box and give border to ur fields
it looks like HTML table with padding
can look funny too :-))|||well you can select the report style as table
and later do some formatting..

How can i use the formula in crystal report 8.5

Hello,
is there somebody who can help me to create a formula in crystal report 8.5.
this formula must convert a date ex : "01/01/1970 0:00" in unix format

I know the code in vb

rounddown( ((value +7200)/86400) + "01/01/1970"),0)

somebody can help me to do this with formula in crystale report

thansk for your cooperationhere after you will find the solution to convert a unix(UTC) time in to a normal date
DateAdd('s',{call_req.open_date},CDATETIME(1970,01,01,0,0,0))