I m using Crystal 8.5 with VB6.
i had make sql change in main report
but
How to make to send a SQL request for the subreport ?
IreshMoved to a more proper forum|||Open the subreport and change the query that you want
Showing posts with label subreport. Show all posts
Showing posts with label subreport. Show all posts
Wednesday, March 21, 2012
Monday, March 19, 2012
dynamically showing subreport
Does anyone know of a way to dynamically show / hide a subreport based on the
record count. I need to be able to hide the subreport if the dataset used for
the subreport doesn't contain any records.
Also, I'd like to dynamically change the order of subreports depending on
data chosen for the main report. For example, depending on a value the user
choses for the main report, I want to set the order that the subreports
appear. Does anyone know if / how to dynamically arrange the subreports
within one report?
Any help is greatly appreciated,
PaulPaul Delcogliano wrote:
> Does anyone know of a way to dynamically show / hide a subreport
> based on the record count. I need to be able to hide the subreport if
> the dataset used for the subreport doesn't contain any records.
Maybe you could write a piece of custom code wich counts the records of the
table by the rowcount-property and the bind the visibility of the subreport
to an expression wich will filled by the custom code.
regards
frank
record count. I need to be able to hide the subreport if the dataset used for
the subreport doesn't contain any records.
Also, I'd like to dynamically change the order of subreports depending on
data chosen for the main report. For example, depending on a value the user
choses for the main report, I want to set the order that the subreports
appear. Does anyone know if / how to dynamically arrange the subreports
within one report?
Any help is greatly appreciated,
PaulPaul Delcogliano wrote:
> Does anyone know of a way to dynamically show / hide a subreport
> based on the record count. I need to be able to hide the subreport if
> the dataset used for the subreport doesn't contain any records.
Maybe you could write a piece of custom code wich counts the records of the
table by the rowcount-property and the bind the visibility of the subreport
to an expression wich will filled by the custom code.
regards
frank
Friday, February 24, 2012
Dynamic Text Field
We have purchase orders that we are pulling from a MSSQL backend, and the report works fine.
However, in the subreport, the users would like to be prompted to enter up to 8 lines of text to be inserted into the report when they execute the report.
I am not sure if this is possible, or how to go about it. I tried using a parameter field, but there is simply not enough space for them to enter in info, and they have to enter multiple lines. I would like to make this as user friendly as possible.
We are using Crystal Reports 7, and may be upgrading to Crystal 11 by the end of the year.
Thank you in advance.Yes u can use parameter field, unfortunately, it does not display multiline but it can accomodate ur requirement, i used it at max length 65000 characters.
im using CRXI|||Actually, I figured out a neat way to do it.
You can create a Word or .rtf file in Wordpad or MSWord, and link it via OLE. That way, they can actually make the text look exactly the way they want it to on the report. It ends up looking really nice, and you can do all the shading and bordering in CR and it works fine.
I've used it in both the .rpt format and compiled it to .exe and they both work as long as the text they want to use was edited and saved before they open the .exe. I just trained the users to do this, and all is working great.
So after banging my head awhile, I finally saw through it and figured out this way.
Thank you for your help, I had tried that, but my users were upset by not being able to view their text. This was the next best way.
However, in the subreport, the users would like to be prompted to enter up to 8 lines of text to be inserted into the report when they execute the report.
I am not sure if this is possible, or how to go about it. I tried using a parameter field, but there is simply not enough space for them to enter in info, and they have to enter multiple lines. I would like to make this as user friendly as possible.
We are using Crystal Reports 7, and may be upgrading to Crystal 11 by the end of the year.
Thank you in advance.Yes u can use parameter field, unfortunately, it does not display multiline but it can accomodate ur requirement, i used it at max length 65000 characters.
im using CRXI|||Actually, I figured out a neat way to do it.
You can create a Word or .rtf file in Wordpad or MSWord, and link it via OLE. That way, they can actually make the text look exactly the way they want it to on the report. It ends up looking really nice, and you can do all the shading and bordering in CR and it works fine.
I've used it in both the .rpt format and compiled it to .exe and they both work as long as the text they want to use was edited and saved before they open the .exe. I just trained the users to do this, and all is working great.
So after banging my head awhile, I finally saw through it and figured out this way.
Thank you for your help, I had tried that, but my users were upset by not being able to view their text. This was the next best way.
Dynamic Subreports... is it possible?
Is it possible to set up a subreport so that I can determine which report it displays based on parameters? From what I've seen, the report that a subreport displays must be hardcoded... Anyone got any workarounds?
No .... not really. Unfortunately Microsoft did not implement the RDL parameter replacement mechanism very well.
In my opinion, Reporting Services 2005 would have been much stronger if they would have simply taken the input parameter information and replaced all occurrences of the "parameter" within the RDL prior to rendering. How hard can that be?
Here's a link for a terrible work around - a nasty one that uses layering.
http://www.developmentnow.com/g/115_2006_1_0_0_680033/Dynamic-Subreports.htm
Dynamic Subreports... is it possible?
Is it possible to set up a subreport so that I can determine which report it displays based on parameters? From what I've seen, the report that a subreport displays must be hardcoded... Anyone got any workarounds?
No .... not really. Unfortunately Microsoft did not implement the RDL parameter replacement mechanism very well.
In my opinion, Reporting Services 2005 would have been much stronger if they would have simply taken the input parameter information and replaced all occurrences of the "parameter" within the RDL prior to rendering. How hard can that be?
Here's a link for a terrible work around - a nasty one that uses layering.
http://www.developmentnow.com/g/115_2006_1_0_0_680033/Dynamic-Subreports.htm
Sunday, February 19, 2012
Dynamic subreport based on user group
How would you set visibility in a report based on which user group the user
is in?You can easily see the User, but not the groups the user is in ,unless you do
some sort of call outside RS.
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"Doris" wrote:
> How would you set visibility in a report based on which user group the user
> is in?
is in?You can easily see the User, but not the groups the user is in ,unless you do
some sort of call outside RS.
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"Doris" wrote:
> How would you set visibility in a report based on which user group the user
> is in?
Subscribe to:
Posts (Atom)