rbuser
Comments
-
My Code is.
dmReports.tVoucher.close;
dmReports.tVoucher.Open;
dmReports.tVoucher.Filtered := False;
if dmReports = nil then
Application.CreateForm(TdmReports, dmReports);
dmRepor… -
Thanks for all your help.
While digging thru the newsgroups I discovered that I can use subselect
statements with an InList AutoSearch Field. I was able to use a user
supplied AutoSearch value in my subselect, adding to my data… -
OK, thanks, that's what I thought.
Is there a way to iterate thru a dataset before generating the report? I
need to be able to do this entirely within an end user database setup.
Thanks,
Bob Nicksic
-
Thanks for your reply Nard. I'm an end-user however rather than a developer
(Hence the group I posted in). I can understand the concept of the second
query using the search criteria entered by the user for the first query, but
it's no… -
I added a function to remove the criteria one at a time based on the table
and field names.
Thanks. That worked great.
-
Is there a way I can tell which ones where added by the designer versus RAP
code?
-
Hi Nico,
That worked great. There is only one small quirk left. If the user previews
the report then changes their report options, criteria keeps getting added
to the query which brings back overfiltered results.
Is t… -
Man oh man, I really figured some people would chime in here and tell us all
the great things they've done with RB End User, but alas no replies.
I thought maybe a chance to toot your own horn on what you've done, but
maybe ever… -
Correction.
WIlliam Yu is the developer of Grid Pack, not WIlliam Wu.
Accept my apologies.
Alan Sawyer
-
Nard,
not resolved my problem with your soluction ... you have a idea of the I
need do?
Uildenei
-
Thanks!
-
I already answered my question. File -> Print to File Setup
-
Thanks Nard, will look into this for a future enhancement but I've found that
setting the DisplayWidth property in the pipeline field definition to 50
instead of 8000 seems to have solved the issue in the short-term.
Regards,<… -
Further investigation would indicate the problem is caused by auto-sizing the width of the control when the field is
dropped on the designer (although I still don't understand why I can't duplicate the error on our systems).
Is ther… -
Thanks. It worked great.
SMP
-
Thanks, that's what I thought.
I was able to create a view (adding to the data dictionary, of course) and
cast the GUID column as a varchar(38), and it seems to be working so far.
Just wanted to share that with the newsgroup in … -
The first 3 master records work just fine, but the subreports in the 4th
master record contain multiple groups.
How much of an impact is it going to have if the Reconciliation Number is a
uniquidentifier (GUID) in SQL Server? T… -
That did the trick!
How would the report definition get saved that way if there is no interface
to change it from the end user reporting solution?
Thank You AGAIN Nard!!!
-
Should I set the Visibilty property after the creation of the reports?
If I set visible=false I'm not anymore able to add fields to my
reports that I have to create at design time.
Why reports explorer is capable to see pipeline… -
what i want is i'll have a form to let user to see all the format that
they've added for the same report.
How to write the event for the
- amend report button
- delete report button
- new report button
- import re… -
Thank You!!!
Branden Johnson - Integrity Software Design
-
Nard,
For SQL Server the syntax is what you would expect
select Left(name,2) , count(*)
from customer
group by Left(name,2)
order by Left(name,2)
There are restrictions, here is a small excerpt from the M… -
Thanks Nard I will look into those items. FYI both MS SQL Server and
Sybase ASA allow grouping on calculated fields.
Cheers,
-
Thanks Nard, I think that answers my questions but I may not have been
too clear so just to make sure.... This is EUR using Dade.
1. I know the SQL function (I listed it) but I am unable to create a
grouped (summary) dataview o… -
As far as I know many "having" can be subsitute with subqueries....
This is the theory .... maybe some help!
;-)
-
No, actually I jumped the gun on the previous post, I am still not able to
do this!!!
I have a field being summed from another table and I need to get a result
set containing all records in which a field in the main result set t… -
I just created a calculated field to get the difference between the two
fields and added the calculated filed to the search tab as calculated Field
I would still like to know if there is any way to add a having statement
through… -
Thanks. that works!
Reju Mathew
-
Not really sure. I see how parameters can be used. I think my biggest
question was how you guys saw pick lists being used.
Thanks.
SMP
-
Nico Cizik (Digital Metaphors) wrote:
Trouble is that if I "take control myself", I have to use Group Index
30, which controls the Report Explorer help, but when they click to go
on to the designer, the option for "View" is gone, be…