DavidWIII
DavidWIII
About
- Username
- DavidWIII
- Joined
- Visits
- 0
- Last Active
- Roles
- Members
Comments
-
DavidWIII wrote: » I can get it to work using a DBLookupComboBox if I put it on a second dialogpage. The query used as the data source for the combobox uses the text and date range from the first dialogpage as params. The click event of the OK but…
-
I can get it to work using a DBLookupComboBox if I put it on a second dialogpage. The query used as the data source for the combobox uses the text and date range from the first dialogpage as params. The click event of the OK button on the first dial…
-
Thanks, but I don't yet know how to reference the selection in the CheckListBox. I don't even know how to set a variable or text to the selection. I'm still looking through the manual, demo, and forums. Even if I do find it, I'll have to extract th…
-
I can get a checklistbox to load the data. Now I have to figure out how to pass that value to another query that creates the report. With the ComboBox, I was using KeyField under properties as a parameter in the main query. The properties of the …
-
Thanks, gordk I do have the OK button disabled. I'm still not sure how to load the combobox from whatever event I use. I was hoping for a command similar to what's used in .net - DBLookupComboBox.FillData(); There might not be a command similar …
-
DavidWIII wrote: » I have a Dialog page with a Memo and two DateEdit boxes. A query is run based on a client # from the memo and a date range from the two DateEdits. The query works and the report runs OK. Now, I want to update the page to popul…
-
gordk wrote: » what happens when you set allow split property of the band, might be simpler I don't see any difference after setting the split property of the band. I had tried that earlier. The band height is 128.60. The page height is …
-
DavidWIII wrote: » I found it. Report Properties > PrintOptions > PrintMode > pmSplit Changing PrintMode is actually unnecessary. Just increase the page size while in design so the MasterData band fits. When finished, return the …
-
I found it. Report Properties > PrintOptions > PrintMode > pmSplit
-
I got it working by putting the ComboBox on a second DialogPage. For some reason, I have to click the OK button twice on the second DialogPage for the report to run. I don't know why it was crashing earlier. It was probably some code I removed. D…
-
Will it work if you put double quotes around the column names like gordk's example? [+]
-
I have tried putting the ComboBox on another DialogPage -DialogPage2. I then show that page on the click event of the OK button on DialogPage1 The box does populate correctly, but the report crashes when the OK button on DialogPage2 is clicked.
-
I know how to populate ComboBoxes when the DialogPage is first loaded. Is there a way to refresh the page after it is loaded and populate the ComboBox at that time? Maybe I could call an OnShow event when the second date is entered? I don't know.…
-
I had tried the onafterdata event of the memo but had a flaw in my logic. I now have the code setting the color back to its original when it changes again. I also had to deal with the first row. It's easier to get the code right once you've decided…
-
I got it. My last problem was just spacing.
-
New and improved - but still not quite right. It has an extra row multiplying by 11 when it should stop at 10.
-
In case anyone looks at it, I set the MasterData1 row count to 10 and get some results. But it's still wrong. All of the rows are zeros. I also set the MasterData2 row count to 10 without seeing a noticeable change. Variable X is initialized to 0…
-
Thanks, gordk. That works perfectly for my report in the OnChange event by keeping the OK button disabled. Now I'm trying to verify if the number exists in a date range. A start date and end date are entered in DateEdit controls. Querying the datab…
-
Does a demo for FastReport 3.0 exist? It would be helpful if I can get it. A link to a download or as an attachment in an email or message would be fine. Thanks
-
ValidInt() Never mind. I just noticed the ValidInt() function. That works. I got off on the wrong track trying pascal functions we don't have. if  ValidInt(myMemoInput) then... ...
-
I got it to work by setting the page to double pass and using the following in the memo OnBeforePrint event. wrote: procedure Memo8OnBeforePrint(Sender: TfrxComponent); begin if Engine.FinalPass then If myQuery.RecordCount = 0 Then begin M…
-
I'm looking through the manual and attempting to use 2 pass and an array. I've also tried getting the record count from the query. I still haven't worked out how to get Fast Reports to read the record count. I've tried storing the rowcount in a v…
-
gordk wrote: » David if you have detail data this could be done in the mdband using detailbandsdataset.recordcount property and an [iif((detaildata1.dataset.recordcount = 0),true value,false value)] in the memo rowcount property only applies to…
-
Yes, nested groups are all I needed. It was simpler than I thought. Thanks
-
I never got the formatting right in my examples above. I attached images of the report. The report currently looks like this:
-
My report currently does a page break on the name and displays total time in the GroupFooter. GroupHeader  Bruce Wayne MasterData                                                        Dat…
-
Thank you, gpi. I just installed it. That should help.
-
I have two comboboxes. One is to select a doctor. The other is to select a clinic. If the user selects a doctor and makes no selection in the other combobox, the report lists all clinics for that doctor. If the user selects the clinic and leaves the…
-
Thanks for the suggestions. I'm reading about engine.newpage right now. If I place it in the header, can I make it conditional depending on the value of the combobox? Do I need to store the values of Encounter.Doctor and Encounter.Clinic in variabl…
-
gordk I know to put single quotes around the value when assigning to a string variable: myVariable = 'ZZZ' I think that is what you are telling me. Please let me know if I'm missing something. I currently have the keyfields property of each c…