crystal report how to display date in boxes of Bank Check Book

I want to print check from SAP Business one. I do all setting except the bank check Date have issue. in bank check the date is in boxes and having spacing.

can any one help me to how can i do it?

crystal report how to display date in boxes of Bank Check Book

-------------Problems Reply------------

as Siva reccomended (or similar) ---

8 separate formulas

left(totext(Currentdate,'dd'),1) //d1

right(totext(Currentdate,'dd'),1) //d2

left(totext(Currentdate,'MM'),1) //m1

right(totext(Currentdate,'MM'),1) //m2

left(totext(Currentdate,'yyyy'),1) //y1

mid(totext(Currentdate,'yyyy'),2,1) //y2

mid(totext(Currentdate,'yyyy'),3,1) //y3

mid(totext(Currentdate,'yyyy'),4,1) //y4

Place in report and format each to have top, bottom, left and right borders.

take as mnay formulas as many characters in date and in each formula take one date character and display all formulas side by side.

you can extract single chracters ny conveting date to strings.

after placing all formulas side by side, Apply borders for those formulas.

Category:crystal reports Views:2 Time:2018-08-09

Related post

  • Crystal report: How to show empty rows that are predefined? 2009-11-19

    The situation is the following: In a database I have a table that stores the number of occurrencies an error occurred. Say ErrorId Timestamp N Err1 t1 2 Err2 t2 7 I query this data, and must use the cross-table of crystal report to show the data. Thr

  • How to display a message box in C# as system modal? 2009-06-24

    How to display a message box in C# as system modal, something like vbModal in Visual Basic 6? --------------Solutions------------- Advanced MessageBoxing with the C# MessageBoxIndirect Wrapper Are you talking about message boxes, or standard forms? I

  • How to display data from related tables in a WPF datagrid 2010-08-19

    I'm just finding my way with WPF/Datagrid/Linq and I'm trying to find out how to display data from a related table in my datagrid. For example I have 3 tables: Customers: id, name Products: id, name Orders: id, customerId, productId and I've set up t

  • How to display data from sqlite in textview 2010-09-21

    i have a problem... How to display data from sqlite in textview.. please help me out.. Thank u.. --------------Solutions------------- i am giving u a simple database table,in which u should define roll no, name , marks and through roll no u can fetch

  • In Rails, how to display date like NOV 22, '09? 2010-12-04

    In Rails, how to display date like NOV 22, '09? And time like: 5:10 PM --------------Solutions------------- "%b %d, '%y" "%I:%M%p" Check out the section 3.2, "Adding Date and Time Formats", in th Internationaliza

  • How to display data on the page without putting code to display data in class definition 2011-02-06

    I have function with simple sql query to list tickets on the page: class DBQuery { function displayTicketsList(){ $this->dbConnection(); $query = "SELECT * FROM tickets"; $this->result = mysql_query($query); $this->dbClose(); } . . . } How t

  • how to display a message box using openGL in visual C++ 2011-04-10

    How to display a message box on the window which is created when we execute a visual c++ program using openGL. Specifically i want to display a message and one "OK" button.So when the user clicks on OK button it should resume to the same state as it

  • How to display data from an array with foreach() in php? 2011-11-10

    How to display data from an array with foreach() in php? I would like to do it so it displays in href with one on a new line. --------------Solutions------------- for this You can use <?php $x=array("one","two","three"); foreach ($x as $value) { /

  • how to display data in descending order without using ORDER BY CLAUSE in Oracle 2012-03-06

    I am new in oracle and I have one question i.e.: how to display data in descending order without using ORDER BY CLAUSE in Oracle. whether it is in sql or pl/sql. reply me please --------------Solutions------------- It is not possible to reliably retr

  • How to display data using ArrayCollection (SQLite db) to a control that without dataProvider? 2012-03-11

    I know how to display data in a List control using dataProvider but what about control that don't have dataProvider e.g. TextInput, Label contorl? I know how to display data in a List control using dataProvider but what about control that don't have

  • How to Display data from SQlite & core-data into multi table views in xcode 4.3? 2012-04-16

    Possible Duplicate: iPhone SDK: Populate Table View From Core Data is there any good tutorial shows how to display data from SQlite into multi table view using xcode 4.2 or 4.3 with core data and story board?? Many thanks for your help. -------------

  • How to display data from two databases in RDL report? 2009-08-09

    I'm creating a report that will take some data from one database (Company and list of Customer for every Company) and some data connected to it from other database (list of Item for every Customer). It seems that displayed data can only use one DataS

  • Crystal Reports 2008: C#: Edit Date format on the fly 2009-06-09

    I'm modifying a report at runtime in c# .Net using Crystal Reports 2008. I'm having trouble modifying a date fields format. I have accessed the DateFieldFormat object, and modified the properties, but only the SystemDefaultType property seems to have

  • C# + Crystal Reports + Select Expert for only ONE Box? 2009-07-20

    following Problem. I am generating my Reports with Crystal Reports from a Database, CR gets a DataSet as DataSource. I have a Table like this one in my DataSet: ... | Rank | Comment | ... ----+------+---------+----- ... | User | blabla | ... ... | VI

  • Crystal Reports: How do I allow "set to null" when prompting for values to pass to subreports? 2009-11-20

    I have created a report which links into subreports. I created parameter fields to feed into the parameters of the subreports using subreport links. If I do not add a subreport link and therefore the subreport is prompting for the value directly it w

  • Crystal Reports: How do I repeat a constant number of rows / headers on each new page in a cross-tab? 2010-03-09

    I have some data that I've staged in my database as such: RowHeader ColumnHeader Value Row1 Col1 (1,1) Row1 Col2 (1,2) Row1 Col3 (1,3) Row1 Col4 (1,4) Row1 Col5 (1,5) Row2 Col1 (2,1) Row2 Col2 (2,2) ... ... ... RowN ColM (N,M) And, as you might guess

  • Crystal Reports - How do I reset the page count for each group? 2010-07-07

    How do I reset the page count per group in my report? Each group contains about 5-7 pages worth of data. --------------Solutions------------- One way of resetting the page number on change of group is to check the "Reset Page Number After" option in

  • SAP BusinessObjects Crystal Reports - Where does the data source come from? 2011-10-25

    I'm flummoxed with (what I believe is) a seemingly-simple theoretical question about SAP BusinessObjects / Crystal Reports store their data sources, to help me change them to integrate with our new upgrade of Maximo. One Sentence Summary: I can't fin

  • hi.. i am using crystal reports How to get the sum() of a column 2014-10-24

    hi.. i am using crystal reports i have 3 tables in the report 1 st (Division,username), 2nd( division, loc_amt,loc date), 3rd (division,Estimate_amt,E_Date) now i want to DISPLAY THE VALUES OF THE COLUMNS division,SUM(loc_amt),SUM(Estimate_amt) WITH

  • Crystal Report Export to Excel (data Only) is missing Page header 2009-12-23

    I have crystal report with 2 page headers (PHa and PHb) when i export this report to excel by selecting Excel (Data Only ) option the PHa is missing the exported excel.I tried to suppress the PHb to display PHa when it is exported to excel but by doi

  • Crystal reports not pulling same data as sql server 2010-01-25

    I have the following code: select order_number,received_date from order_head where order_head.order_number not in (select order_number from csa_log group by order_number) and ordernature in ('02','03') and received_date > '01.01.2010' and buyer_co

  • Crystal Report: Showing Single Column Data into Rows of Multiple Columns 2010-04-15

    Crystal Reports in Visual Studio 2008 with C# Normally Data from single column comes like Column1 val1 val2 val3 val4 val5 val6 val7 val8 BUT,I want to show data from my Single column in following format: Column1 val1 val2 val3 val4 val5 val6 val7 va

  • How to display data in TextView 2010-06-14

    I have a view in which there is a text box where user enters data, when clicks on submit, I want to store the input and display in another box. final EditText edittext = (EditText) findViewById(; mText = (TextView) findViewById(

  • Crystal Report 9 is displaying only the 1st record if records vary only by millisecond 2010-07-25

    I am using SQL Sever 2005, VC 6 ++ and Crsystal Report API to print a report in a child window. If the records vary Only by Milliseconds, Crystal Report is showing only the 1st record. Otherwise, it is perfectly fine. I am picking the timestamp from

Copyright (C), All Rights Reserved.

processed in 0.111 (s). 11 q(s)