Default Avatar

hsm

hsm

About

Username
hsm
Joined
Visits
36
Last Active
Roles
Members

Comments

  • gpi wrote: » sample in attach Thank you for such a fast reply. I couldn't get your report to disply (dataset 'cross' not found), but I saw how you did it and using the same method in my report it now does what I want. BTW When can I find…
  • gordk wrote: » whish you would have stated that earlier. @Gordk Related to this and following on from your valuable replies Gordk, I also need to identify a particular column - but of a TfrxDBCrossView. I have highlighted a particular…
  • gpi wrote: » Use two datasets: first for unique group header's values (Master), second for group data (Detail). Use cross-tab with detail dataset Thank you but I always seem to get a key violation when I open the detail dataset. linked via …
  • gpi wrote: » Try to use user function and close TfrxReport.PreviewForm in TfrxReport.OnEndDoc event OK, Thank you.
  • gpi wrote: » Modified script for 52.fr3 from FRDemo procedure Button1OnClick(Sender: TfrxComponent); begin   BDEQuery1.Close;   BDEQuery1.ParamByName('p1').Value := StrToInt(Edit1.Text);   BDEQuery1.Open;                  …
  • technisoft wrote: » technisoft wrote: » My 195 page report takes a while to generate and show all the pages. Until it does the user can only see the first few pages and may not realise there are more to come ( i.e when they go to the 'last' pa…
  • topor1988 wrote: » Hello, I'm using FastReport ver. Embarcadero, but I have big problem to import data from SQLite. I tried to create array with SQLite data but cant import it also. I'm trying to use UserDataSet but nothing. Can I have any examp…
    in Data from SQLite Comment by hsm May 2012
  • gpi wrote: » Enter default value in Expression box of variables editor Thank you! I've spent two years wondering if that was possible! That saves a lot of time.
  • bigbird8 wrote: » Maybe, your html help is broken? Or if you opened the chm not locally, it maybe a security problem. A windows update changed the security so only local .chm will be displayed correctly. The right side then is empty or has an err…
  • @gpi or @Gordk OK I've narrowed down the problem and it looks like it may be a bug in FR. I've put a memo in a master data band. On the right hand side of it there is a sub repport. I've set the stretch mode of the memo to smMaxHieght and set …
  • gpi wrote: » See modified report template from FRDemo in attach @gpi I've worked out how to translate your ADO queries into the ones I need for SQLite. I have then loaded in your template (complete with all the stretched/stretch mode va…
  • gpi wrote: » What version of FR do you use? 4.9? Try to use 4.12 -is problem still exists? Yes, I have 4.9 (professional I think, can't really remember) Do I have to buy 4.12 separately? I cannot see how to upgrade on teh web site.
  • gpi wrote: » Attach your report template (fr3) and saved preview pages (fp3) here
  • gordk wrote: » place the vertical memo in the group header. in the obp event of the retreive the engine's cury and store in a variable in the oap event of the memo set the engine cury to the variables value @ Gordk Ok I've managed to mak…
  • gpi wrote: » Use subreport. See my previous Test.fr3 Thank you, I can see how your sub report works. However my data comes from a clientdataset (as the original database is SQLite) . This is linked to my report via a TfrxDBDataset so I don't…
  • gpi wrote: » Place cross on band Ah, of course, thank you, that did it
  • gpi wrote: » gpi wrote: » I still have no idea how to create a vertical field like this (even with subreport) Do you want rotate text or print each letter on separate line? I'd like the text rotated. I guess I can do that with the to…
    in vertical text Comment by hsm May 2012
  • gordk wrote: » place the vertical memo in the group header. in the obp event of the retreive the engine's cury and store in a variable in the oap event of the memo set the engine cury to the variables value Sorry Gordk there seems to be s…
  • pele wrote: » I still have no idea how to create a vertical field like this (even with subreport) Did you ever get this to work?
    in vertical text Comment by hsm May 2012
  • gpi wrote: » Set TfrxReportPage.EndlessHeight and EndlessWidth properties to True I tried that but then all I get is a white 'Page' displayed that is A4 width and only as high as the page header plus the page footer (about 3cm). The page…
  • zifnabbe wrote: » it might be usefull for others, others can give feedback (or just tell that there is a much more simplistic way). Thank you. It was very useful for me. I have three nested groups and need to show an average score (from th…
  • OK, I feel really stupid now! The modal behaviour was indeeed because the preview was opening as modal. The way I stopped this behaviour was highly technical and obviously only understood by a small, elite group of programmers... To do it I wen…
  • Thank you, that did it. Now that I can see the principle, ie find the object, cast it as a chart and then use the same chart properties that can be seen in the editor, it opens up loads of possibilities for fine tuning other bits of the chart thr…
  • As usual, as soon as I post a question I work out the answer! However as I see there are several posts asking the same thing here, none of which have any replies I'm posting the relevant bits here in case it helps someone else You need to open th…
  • Just in case anyone else has the same issue I have now narrowed the problem down to the chain between the Tquery component, the TdataProvider attached to it and the TClientDataset attatched to that. The query shows the correct records, the TClientDa…
  • gordk wrote: » don't keep adding export components. Sorry for the delay but I have been away and only just seen this reply. I don't understand though, what mustn't I keep adding? I have about 12 reports, each on its own form. One form…
  • technisoft wrote: » technisoft wrote: » How can I embed the font in the report so that it always shows the correct font regardless of what the user has? As far as I can make out encrypting (by specifying a password) will embed the font. U…
  • hsm wrote: » I have a simple banded report with dataset frxDBDataSet1Bulletin      NoteID      Note      Author      ForGroup NoteID is the PK. All fields are strings and all shown in the MasterData band I want to pick up the…
  • gpi wrote: » You may set TfrxReport.PreviewOptions.Buttons Ah, Thank you. I did have a good look through the properties of a TfrxReport but didn't spot those! Regards H.
  • gordk wrote: » since you were cutting and pasting code you probable forgot to hook the event to the tfrxreport component. Thank you for getting back so quickly Gordk. Yes that was the problem. The Programmers manual didn't explicitly say t…