カテゴリー
- 22/04/23 もしや、、、シンサラって
- 22/04/10 CAMEO Candyのギターソロ
- 22/04/10 カレンダーをクリックして日付を入れて、その入った文字をドラッグして好きな場所に動かす
- 22/03/22 Windows11のモヤモヤ解消、、、、「右クリック」のメニュー
- 22/03/22 Selectboxで選んだ項目によって特定の要素の背景色を変える
- 22/02/09 ブラウザの位置情報をhtmlに表示する方法
- 22/01/26 クリッカブルマップ
- 22/01/22 CompornentOne
- 22/01/13 VisualStudioでCurl
- 21/11/22 RSS Antennaの389エラー
もしや、、、シンサラって
過去帳とか年忌案内とか、寺院さん向けの機能が満載ですが、仮にその部分は使わずに、 それ以外の機能だけに的を絞っても (1)CTI機能 (2)検索機能 (3)Memo入力機能 (4)名簿~筆まめ出力機能 (5)出納帳 (6 […]

CAMEO Candyのギターソロ
80年代によく聞いたCAMEOのCandyっていう歌。 この歌のサックスが吹けたらええなあ、、、と思って20代の時にアルトサックスを買ったんですが、結局挫折。 ギターのことはまったく考えてもいなかった。メロディは知ってい […]

Windows11のモヤモヤ解消、、、、「右クリック」のメニュー
Windows11でのストレスといえば「右クリック」です。 私は永年の間、イラレでもワードでもエクセルでも「まずファイルをコピーして、それを名前を変えて、それから編集する」という方法でやっています。 「名前を付けて保存」 […]
Selectboxで選んだ項目によって特定の要素の背景色を変える
>ABC Change the select この世の宝 おいしい 自分でアゴをかく このドキュメントは重要です。取り扱いに注意してください。
CrystalReportsで日付(月日)を縦書きにするために、苦肉の策
年月でグループ化したデータを縦書きにするために、、、、出力されるデータがyyyy/mmなので強制的に日本語和暦漢字に置換する方が早い
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 |
Local StringVar target
:=
totext(GroupName
({フィールド},
"monthly")); target
:=
Replace(target,"2019","令和元年"); target
:=
Replace(target,"2020","令和二年"); target
:=
Replace(target,"2021","令和三年"); target
:=
Replace(target,"2022","令和四年"); target
:=
Replace(target,"2023","令和五年"); target
:=
Replace(target,"2024","令和六年"); target
:=
Replace(target,"2025","令和七年"); target
:=
Replace(target,"2026","令和八年"); target
:=
Replace(target,"2027","令和九年"); target
:=
Replace(target,"2028","令和十年"); target
:=
Replace(target,"/12"," 十二月"); target
:=
Replace(target,"/11"," 十一月"); target
:=
Replace(target,"/10"," 十月"); target
:=
Replace(target,"/09"," 九月"); target
:=
Replace(target,"/08"," 八月"); target
:=
Replace(target,"/07"," 七月"); target
:=
Replace(target,"/06"," 六月"); target
:=
Replace(target,"/05"," 五月"); target
:=
Replace(target,"/04"," 四月"); target
:=
Replace(target,"/03"," 三月"); target
:=
Replace(target,"/02"," 二月"); target
:=
Replace(target,"/01"," 一月"); |
CrystalReportsの不可解なRecordNumber—cstr
私のパソコン(いわゆる日本語Windows10)では cstr(RecordNumber)=9.00 となる ところが、違うパソコンでは cstr(RecordNumber)=9.000 となる(0が1コ多い(泣) 「そ […]
CrystalReports9でのカナ→カナが、、、、
関数がない!トホホ、仕方がないので、、、、チカラワザ
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 |
Local StringVar target
:=
{Old2.BuddhistNameKana}; target
:=
Replace(target,
"ァ","ぁ"); target
:=
Replace(target,
"ィ","ぃ"); target
:=
Replace(target,
"ゥ","ぅ"); target
:=
Replace(target,
"ェ","ぇ"); target
:=
Replace(target,
"ォ","ぉ"); target
:=
Replace(target,
"ガ","が"); target
:=
Replace(target,
"ギ","ぎ"); target
:=
Replace(target,
"グ","ぐ"); target
:=
Replace(target,
"ゲ","げ"); target
:=
Replace(target,
"ゴ","ご"); target
:=
Replace(target,
"ザ","ざ"); target
:=
Replace(target,
"ジ","じ"); target
:=
Replace(target,
"ズ","ず"); target
:=
Replace(target,
"ゼ","ぜ"); target
:=
Replace(target,
"ゾ","ぞ"); target
:=
Replace(target,
"ダ","だ"); target
:=
Replace(target,
"ヂ","ぢ"); target
:=
Replace(target,
"ヅ","づ"); target
:=
Replace(target,
"デ","で"); target
:=
Replace(target,
"ド","ど"); target
:=
Replace(target,
"バ","ば"); target
:=
Replace(target,
"ビ","び"); target
:=
Replace(target,
"ブ","ぶ"); target
:=
Replace(target,
"ベ","べ"); target
:=
Replace(target,
"ボ","ぼ"); target
:=
Replace(target,
"パ","ぱ"); target
:=
Replace(target,
"ピ","ぴ"); target
:=
Replace(target,
"プ","ぷ"); target
:=
Replace(target,
"ペ","ぺ"); target
:=
Replace(target,
"ポ","ぽ"); target
:=
Replace(target,
"ア","あ"); target
:=
Replace(target,
"イ","い"); target
:=
Replace(target,
"ウ","う"); target
:=
Replace(target,
"エ","え"); target
:=
Replace(target,
"オ","お"); target
:=
Replace(target,
"カ","か"); target
:=
Replace(target,
"キ","き"); target
:=
Replace(target,
"ク","く"); target
:=
Replace(target,
"ケ","け"); target
:=
Replace(target,
"コ","こ"); target
:=
Replace(target,
"サ","さ"); target
:=
Replace(target,
"シ","し"); target
:=
Replace(target,
"ス","す"); target
:=
Replace(target,
"セ","せ"); target
:=
Replace(target,
"ソ","そ"); target
:=
Replace(target,
"タ","た"); target
:=
Replace(target,
"タ","ち"); target
:=
Replace(target,
"ッ","っ"); target
:=
Replace(target,
"ツ","つ"); target
:=
Replace(target,
"テ","て"); target
:=
Replace(target,
"ト","と"); target
:=
Replace(target,
"ナ","な"); target
:=
Replace(target,
"ニ","に"); target
:=
Replace(target,
"ヌ","ぬ"); target
:=
Replace(target,
"ネ","ね"); target
:=
Replace(target,
"ノ","の"); target
:=
Replace(target,
"ハ","は"); target
:=
Replace(target,
"ヒ","ひ"); target
:=
Replace(target,
"フ","ふ"); target
:=
Replace(target,
"ヘ","へ"); target
:=
Replace(target,
"ホ","ほ"); target
:=
Replace(target,
"マ","ま"); target
:=
Replace(target,
"ミ","み"); target
:=
Replace(target,
"ム","む"); target
:=
Replace(target,
"メ","め"); target
:=
Replace(target,
"モ","も"); target
:=
Replace(target,
"ャ","ゃ"); target
:=
Replace(target,
"ヤ","や"); target
:=
Replace(target,
"ュ","ゅ"); target
:=
Replace(target,
"ユ","ゆ"); target
:=
Replace(target,
"ョ","ょ"); target
:=
Replace(target,
"ヨ","よ"); target
:=
Replace(target,
"ラ","ら"); target
:=
Replace(target,
"リ","り"); target
:=
Replace(target,
"ル","る"); target
:=
Replace(target,
"レ","れ"); target
:=
Replace(target,
"ロ","ろ"); target
:=
Replace(target,
"ヮ","ゎ"); target
:=
Replace(target,
"ワ","わ"); target
:=
Replace(target,
"ヲ","を"); target
:=
Replace(target,
"ン","ん"); target
:=
Replace(target,
"ァ","ぁ"); target
:=
Replace(target,
"ィ","ぃ"); target
:=
Replace(target,
"ゥ","ぅ"); target
:=
Replace(target,
"ェ","ぇ"); target
:=
Replace(target,
"ォ","ぉ"); target
:=
Replace(target,
"ガ","が"); target
:=
Replace(target,
"ギ","ぎ"); target
:=
Replace(target,
"グ","ぐ"); target
:=
Replace(target,
"ゲ","げ"); target
:=
Replace(target,
"ゴ","ご"); target
:=
Replace(target,
"ザ","ざ"); target
:=
Replace(target,
"ジ","じ"); target
:=
Replace(target,
"ズ","ず"); target
:=
Replace(target,
"ゼ","ぜ"); target
:=
Replace(target,
"ゾ","ぞ"); target
:=
Replace(target,
"ダ","だ"); target
:=
Replace(target,
"ヂ","ぢ"); target
:=
Replace(target,
"ヅ","づ"); target
:=
Replace(target,
"デ","で"); target
:=
Replace(target,
"ド","ど"); target
:=
Replace(target,
"バ","ば"); target
:=
Replace(target,
"ビ","び"); target
:=
Replace(target,
"ブ","ぶ"); target
:=
Replace(target,
"ベ","べ"); target
:=
Replace(target,
"ボ","ぼ"); target
:=
Replace(target,
"パ","ぱ"); target
:=
Replace(target,
"ピ","ぴ"); target
:=
Replace(target,
"プ","ぷ"); target
:=
Replace(target,
"ペ","ぺ"); target
:=
Replace(target,
"ポ","ぽ"); target
:=
Replace(target,
"ア","あ"); target
:=
Replace(target,
"イ","い"); target
:=
Replace(target,
"ウ","う"); target
:=
Replace(target,
"エ","え"); target
:=
Replace(target,
"オ","お"); target
:=
Replace(target,
"カ","か"); target
:=
Replace(target,
"キ","き"); target
:=
Replace(target,
"ク","く"); target
:=
Replace(target,
"ケ","け"); target
:=
Replace(target,
"コ","こ"); target
:=
Replace(target,
"サ","さ"); target
:=
Replace(target,
"シ","し"); target
:=
Replace(target,
"ス","す"); target
:=
Replace(target,
"セ","せ"); target
:=
Replace(target,
"ソ","そ"); target
:=
Replace(target,
"タ","た"); target
:=
Replace(target,
"チ","ち"); target
:=
Replace(target,
"ッ","っ"); target
:=
Replace(target,
"ツ","つ"); target
:=
Replace(target,
"テ","て"); target
:=
Replace(target,
"ト","と"); target
:=
Replace(target,
"ナ","な"); target
:=
Replace(target,
"ニ","に"); target
:=
Replace(target,
"ヌ","ぬ"); target
:=
Replace(target,
"ネ","ね"); target
:=
Replace(target,
"ノ","の"); target
:=
Replace(target,
"ハ","は"); target
:=
Replace(target,
"ヒ","ひ"); target
:=
Replace(target,
"フ","ふ"); target
:=
Replace(target,
"ヘ","へ"); target
:=
Replace(target,
"ホ","ほ"); target
:=
Replace(target,
"マ","ま"); target
:=
Replace(target,
"ミ","み"); target
:=
Replace(target,
"ム","む"); target
:=
Replace(target,
"メ","め"); target
:=
Replace(target,
"モ","も"); target
:=
Replace(target,
"ャ","ゃ"); target
:=
Replace(target,
"ヤ","や"); target
:=
Replace(target,
"ュ","ゅ"); target
:=
Replace(target,
"ユ","ゆ"); target
:=
Replace(target,
"ョ","ょ"); target
:=
Replace(target,
"ヨ","よ"); target
:=
Replace(target,
"ラ","ら"); target
:=
Replace(target,
"リ","り"); target
:=
Replace(target,
"ル","る"); target
:=
Replace(target,
"レ","れ"); target
:=
Replace(target,
"ロ","ろ"); target
:=
Replace(target,
"ヮ","ゎ"); target
:=
Replace(target,
"ワ","わ"); target
:=
Replace(target,
"ヲ","を"); target
:=
Replace(target,
"ン","ん"); |
Crystalreports 指定行数で改ページ
ページヘッダに「式フィールド」を追加して次の式を記入 WhilePrintingRecords; numberVar line := 0; 次に詳細(行数を指定するセクション)に式フィールドを追加して次の式を記入 Whi […]
CrystalReports9での和暦漢数字年号を横書きの時には算用数字にする(その逆もついでに)
いつもながらのチカラワザ、、、15年くらいたっても進化しないのはあたりまえ。 15年前のCrystalReportsで作っているからであります。
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 |
Local StringVar target
:=
{Old.JapanYear}; target
:=
Replace(target,"七十","70"); target
:=
Replace(target,"六十九","69"); target
:=
Replace(target,"六十八","68"); target
:=
Replace(target,"六十七","67"); target
:=
Replace(target,"六十六","66"); target
:=
Replace(target,"六十五","65"); target
:=
Replace(target,"六十四","64"); target
:=
Replace(target,"六十三","63"); target
:=
Replace(target,"六十二","62"); target
:=
Replace(target,"六十一","61"); target
:=
Replace(target,"六十","60"); target
:=
Replace(target,"五十九","59"); target
:=
Replace(target,"五十八","58"); target
:=
Replace(target,"五十七","57"); target
:=
Replace(target,"五十六","56"); target
:=
Replace(target,"五十五","55"); target
:=
Replace(target,"五十四","54"); target
:=
Replace(target,"五十三","53"); target
:=
Replace(target,"五十二","52"); target
:=
Replace(target,"五十一","51"); target
:=
Replace(target,"五十","50"); target
:=
Replace(target,"四十九","49"); target
:=
Replace(target,"四十八","48"); target
:=
Replace(target,"四十七","47"); target
:=
Replace(target,"四十六","46"); target
:=
Replace(target,"四十五","45"); target
:=
Replace(target,"四十四","44"); target
:=
Replace(target,"四十三","43"); target
:=
Replace(target,"四十二","42"); target
:=
Replace(target,"四十一","41"); target
:=
Replace(target,"四十","40"); target
:=
Replace(target,"三十九","39"); target
:=
Replace(target,"三十八","38"); target
:=
Replace(target,"三十七","37"); target
:=
Replace(target,"三十六","36"); target
:=
Replace(target,"三十五","35"); target
:=
Replace(target,"三十四","34"); target
:=
Replace(target,"三十三","33"); target
:=
Replace(target,"三十二","32"); target
:=
Replace(target,"三十一","31"); target
:=
Replace(target,"三十","30"); target
:=
Replace(target,"二十九","29"); target
:=
Replace(target,"二十八","28"); target
:=
Replace(target,"二十七","27"); target
:=
Replace(target,"二十六","26"); target
:=
Replace(target,"二十五","25"); target
:=
Replace(target,"二十四","24"); target
:=
Replace(target,"二十三","23"); target
:=
Replace(target,"二十二","22"); target
:=
Replace(target,"二十一","21"); target
:=
Replace(target,"二十","20"); target
:=
Replace(target,"十九","19"); target
:=
Replace(target,"十八","18"); target
:=
Replace(target,"十七","17"); target
:=
Replace(target,"十六","16"); target
:=
Replace(target,"十五","15"); target
:=
Replace(target,"十四","14"); target
:=
Replace(target,"十三","13"); target
:=
Replace(target,"十二","12"); target
:=
Replace(target,"十一","11"); target
:=
Replace(target,"十","10"); target
:=
Replace(target,"九","9"); target
:=
Replace(target,"八","8"); target
:=
Replace(target,"七","7"); target
:=
Replace(target,"六","6"); target
:=
Replace(target,"五","5"); target
:=
Replace(target,"四","4"); target
:=
Replace(target,"三","3"); target
:=
Replace(target,"二","2"); target:=
Replace(target,"一","1"); |
[cra […]