hi friends,
i'm new to crystal report. i'd like to know which method is better to make report in crystal report. i developing programes using vb. could anyone help me pls
thankx for ur helpWhat version of Crystal are you using and what version of VB? Also, what kind of data are you going to use? From a database?
If you do a search on this forum for 'CDO', I have posted many examples. I use CR 8.5 using RDC and VB 6. CDO is Crystal Reports version of a recordset. It leaves all the data gathering up to VB so that Crystal never has to touch the database. VB loads all the data into an array, then stuffs the array into a CDO rowset (similar to an ADO recordset or an RDO resultset), then VB passes the CDO rowset to Crystal to display the data.|||Hi im totally new to crystal reports as well.. im using crystal reports 9 and vb .net. I want to pass parameters to a crystal report using vb.. what i exactly want is that the info the user has entered to a field will be passed to a certain portion in the crystal report.. after entering the required fields, i want to see the whole report in the next page.. how should i do this? help!|||If you do a search on this forum for 'CDO', I have posted many examples. I use CR 8.5 using RDC and VB 6. CDO is Crystal Reports version of a recordset. It leaves all the data gathering up to VB so that Crystal never has to touch the database. VB loads all the data into an array, then stuffs the array into a CDO rowset (similar to an ADO recordset or an RDO resultset), then VB passes the CDO rowset to Crystal to display the data.
thankx for the kind help. it's really a great help.
Showing posts with label method. Show all posts
Showing posts with label method. Show all posts
Wednesday, March 28, 2012
Monday, March 26, 2012
New Subscriptions never show
If I select "New Subscription" and I select a delivery method and time and
select OK, the screen flashes, but no subscriptions are listed. I have the
user as a Browser and Publisher, but I don't get an error. Is there
something else I have to check or setup?
BartNot sure why you are seeing this. Can you look in the subscription table
and see if subscription rows are being added?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Bart" <test@.test.com> wrote in message
news:#Kd6Am$VEHA.3024@.TK2MSFTNGP09.phx.gbl...
> If I select "New Subscription" and I select a delivery method and time and
> select OK, the screen flashes, but no subscriptions are listed. I have the
> user as a Browser and Publisher, but I don't get an error. Is there
> something else I have to check or setup?
> Bart
>|||I got that fixed, but now I can't deliver the subscription.
The Server is 2000 Advanced Server connecting remotely to SQL 2000 on a
Windows 2003 Server.
It looks like an AuthZ problem, but I'm not sure how to resolve it.
Here is the log Info:
ReportingServicesService!library!b7c!06/22/2004-12:35:49:: i INFO: Call to
RenderFirst( '/Users Folders/OSCARWEB blynn/My Reports/DVNote Sample' )
ReportingServicesService!library!b7c!06/22/2004-12:35:49:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files, AuthzInitializeContextFromSid: Win32 error: 87;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files
ReportingServicesService!library!b7c!06/22/2004-12:35:49:: i INFO:
Initializing EnableExecutionLogging to 'True' as specified in Server system
properties.
ReportingServicesService!emailextension!b7c!06/22/2004-12:35:49:: Error
sending email.
Microsoft.ReportingServices.Diagnostics.Utilities.RSException: The Report
Server has encountered a configuration error; more details in the log
files -->
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files
at
Microsoft.ReportingServices.Authorization.Native.GetAuthzContextForUser(IntPtr
userSid)
at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String
userName)
at
Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(String
userName, IntPtr userToken)
at
Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(String
userName, IntPtr userToken, Byte[] secDesc, ReportOperation
requiredOperation)
at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType
catItemType, Byte[] secDesc, ReportOperation rptOper)
at
Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext
reportContext, String historyID, Boolean forRendering, Guid& reportID,
Int32& executionOption, String& savedParametersXml, ReportSnapshot&
compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime&
historyDate)
at
Microsoft.ReportingServices.Library.RSService._GetReportParameters(String
report, String historyID, Boolean forRendering, NameValueCollection values,
DatasourceCredentialsCollection credentials)
at
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters)
at
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters, String[]&
secondaryStreamNames)
at
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
-- End of inner exception stack trace --
"Bart" <test@.test.com> wrote in message
news:%23Kd6Am$VEHA.3024@.TK2MSFTNGP09.phx.gbl...
> If I select "New Subscription" and I select a delivery method and time and
> select OK, the screen flashes, but no subscriptions are listed. I have the
> user as a Browser and Publisher, but I don't get an error. Is there
> something else I have to check or setup?
> Bart
>|||Bart, no help for you but this Win32 error 87 is exactly what I'm fighting
since weeks. Could you please doublecheck on the properties page of your
reports with details on: Is there some entry like this:
changed by
<name_of_the_user> [unknown]
For me the "unknown" is the key.
Please refer to news:execmMdVEHA.1472@.TK2MSFTNGP09.phx.gbl I have a thread
with Brian concerning this issue.
r|||It seems that after installing SP1, the problem was resolved. I will
continue testing.
Bart
"Roland" <nomail@.spamprotect.com> wrote in message
news:uPS$4MJWEHA.3236@.tk2msftngp13.phx.gbl...
> Bart, no help for you but this Win32 error 87 is exactly what I'm fighting
> since weeks. Could you please doublecheck on the properties page of your
> reports with details on: Is there some entry like this:
> changed by
> <name_of_the_user> [unknown]
> For me the "unknown" is the key.
> Please refer to news:execmMdVEHA.1472@.TK2MSFTNGP09.phx.gbl I have a thread
> with Brian concerning this issue.
> r
>|||Oh that sounds good. I will install SP1 on my servers tomorrow and let you
know.
r.|||Bart wrote:
> If I select "New Subscription" and I select a delivery method and
> time and select OK, the screen flashes, but no subscriptions are
> listed. I have the user as a Browser and Publisher, but I don't get
> an error. Is there something else I have to check or setup?
> Bart
Arrgggh... After all those dark days w/o SP1 and a running eMail
subscription I'm now facing a strange problem:
* User with role "Browser" is logging in
* User subscribes to a report
* User is able to enter his eMail (RS is configured as described by Daniel
Reib in thread "Stupid question - how to setup the eMail...")
* The subscription process finishes w/o error message
* The subscription action is performed in time and correctly
-- BUT --
the subscription itself is NOT listed, neither under "My Subscriptions" nor
under the subscription pane of the given report for the user with role
"Browser"
-- BUT -- (Again)
if I login as admin I can view and edit the subscription.
I have currently no access to the logs and so no further info, why the
subscription does not appear for the subscriber itself. Nevermind, probably
one of you has an idea?
roland
select OK, the screen flashes, but no subscriptions are listed. I have the
user as a Browser and Publisher, but I don't get an error. Is there
something else I have to check or setup?
BartNot sure why you are seeing this. Can you look in the subscription table
and see if subscription rows are being added?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Bart" <test@.test.com> wrote in message
news:#Kd6Am$VEHA.3024@.TK2MSFTNGP09.phx.gbl...
> If I select "New Subscription" and I select a delivery method and time and
> select OK, the screen flashes, but no subscriptions are listed. I have the
> user as a Browser and Publisher, but I don't get an error. Is there
> something else I have to check or setup?
> Bart
>|||I got that fixed, but now I can't deliver the subscription.
The Server is 2000 Advanced Server connecting remotely to SQL 2000 on a
Windows 2003 Server.
It looks like an AuthZ problem, but I'm not sure how to resolve it.
Here is the log Info:
ReportingServicesService!library!b7c!06/22/2004-12:35:49:: i INFO: Call to
RenderFirst( '/Users Folders/OSCARWEB blynn/My Reports/DVNote Sample' )
ReportingServicesService!library!b7c!06/22/2004-12:35:49:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files, AuthzInitializeContextFromSid: Win32 error: 87;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files
ReportingServicesService!library!b7c!06/22/2004-12:35:49:: i INFO:
Initializing EnableExecutionLogging to 'True' as specified in Server system
properties.
ReportingServicesService!emailextension!b7c!06/22/2004-12:35:49:: Error
sending email.
Microsoft.ReportingServices.Diagnostics.Utilities.RSException: The Report
Server has encountered a configuration error; more details in the log
files -->
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files
at
Microsoft.ReportingServices.Authorization.Native.GetAuthzContextForUser(IntPtr
userSid)
at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String
userName)
at
Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(String
userName, IntPtr userToken)
at
Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(String
userName, IntPtr userToken, Byte[] secDesc, ReportOperation
requiredOperation)
at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType
catItemType, Byte[] secDesc, ReportOperation rptOper)
at
Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext
reportContext, String historyID, Boolean forRendering, Guid& reportID,
Int32& executionOption, String& savedParametersXml, ReportSnapshot&
compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime&
historyDate)
at
Microsoft.ReportingServices.Library.RSService._GetReportParameters(String
report, String historyID, Boolean forRendering, NameValueCollection values,
DatasourceCredentialsCollection credentials)
at
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters)
at
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters, String[]&
secondaryStreamNames)
at
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
-- End of inner exception stack trace --
"Bart" <test@.test.com> wrote in message
news:%23Kd6Am$VEHA.3024@.TK2MSFTNGP09.phx.gbl...
> If I select "New Subscription" and I select a delivery method and time and
> select OK, the screen flashes, but no subscriptions are listed. I have the
> user as a Browser and Publisher, but I don't get an error. Is there
> something else I have to check or setup?
> Bart
>|||Bart, no help for you but this Win32 error 87 is exactly what I'm fighting
since weeks. Could you please doublecheck on the properties page of your
reports with details on: Is there some entry like this:
changed by
<name_of_the_user> [unknown]
For me the "unknown" is the key.
Please refer to news:execmMdVEHA.1472@.TK2MSFTNGP09.phx.gbl I have a thread
with Brian concerning this issue.
r|||It seems that after installing SP1, the problem was resolved. I will
continue testing.
Bart
"Roland" <nomail@.spamprotect.com> wrote in message
news:uPS$4MJWEHA.3236@.tk2msftngp13.phx.gbl...
> Bart, no help for you but this Win32 error 87 is exactly what I'm fighting
> since weeks. Could you please doublecheck on the properties page of your
> reports with details on: Is there some entry like this:
> changed by
> <name_of_the_user> [unknown]
> For me the "unknown" is the key.
> Please refer to news:execmMdVEHA.1472@.TK2MSFTNGP09.phx.gbl I have a thread
> with Brian concerning this issue.
> r
>|||Oh that sounds good. I will install SP1 on my servers tomorrow and let you
know.
r.|||Bart wrote:
> If I select "New Subscription" and I select a delivery method and
> time and select OK, the screen flashes, but no subscriptions are
> listed. I have the user as a Browser and Publisher, but I don't get
> an error. Is there something else I have to check or setup?
> Bart
Arrgggh... After all those dark days w/o SP1 and a running eMail
subscription I'm now facing a strange problem:
* User with role "Browser" is logging in
* User subscribes to a report
* User is able to enter his eMail (RS is configured as described by Daniel
Reib in thread "Stupid question - how to setup the eMail...")
* The subscription process finishes w/o error message
* The subscription action is performed in time and correctly
-- BUT --
the subscription itself is NOT listed, neither under "My Subscriptions" nor
under the subscription pane of the given report for the user with role
"Browser"
-- BUT -- (Again)
if I login as admin I can view and edit the subscription.
I have currently no access to the logs and so no further info, why the
subscription does not appear for the subscriber itself. Nevermind, probably
one of you has an idea?
roland
New Subscription - Report Server Email Delivery Method
When I try to create a new subscription no 'Report Server Email Delivery
Method' shows up.
'Report Server Email' does exist in RSReportServer.config and is configured
with a value for <smtpserver> and a value for <from>.
What is required for 'Report Server Email' to show up?When I set this up I had trouble using a name for the server
(servername.blah.com), I had to put in the IP address for it to work for me.
Don't know why.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Jim" <Jim@.discussions.microsoft.com> wrote in message
news:59D811E2-233E-45C4-BEFD-F313C9713E34@.microsoft.com...
> When I try to create a new subscription no 'Report Server Email Delivery
> Method' shows up.
> 'Report Server Email' does exist in RSReportServer.config and is
configured
> with a value for <smtpserver> and a value for <from>.
> What is required for 'Report Server Email' to show up?
>|||Was using an IP address.
"Bruce L-C [MVP]" wrote:
> When I set this up I had trouble using a name for the server
> (servername.blah.com), I had to put in the IP address for it to work for me.
> Don't know why.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Jim" <Jim@.discussions.microsoft.com> wrote in message
> news:59D811E2-233E-45C4-BEFD-F313C9713E34@.microsoft.com...
> > When I try to create a new subscription no 'Report Server Email Delivery
> > Method' shows up.
> >
> > 'Report Server Email' does exist in RSReportServer.config and is
> configured
> > with a value for <smtpserver> and a value for <from>.
> >
> > What is required for 'Report Server Email' to show up?
> >
> >
>
>
Method' shows up.
'Report Server Email' does exist in RSReportServer.config and is configured
with a value for <smtpserver> and a value for <from>.
What is required for 'Report Server Email' to show up?When I set this up I had trouble using a name for the server
(servername.blah.com), I had to put in the IP address for it to work for me.
Don't know why.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Jim" <Jim@.discussions.microsoft.com> wrote in message
news:59D811E2-233E-45C4-BEFD-F313C9713E34@.microsoft.com...
> When I try to create a new subscription no 'Report Server Email Delivery
> Method' shows up.
> 'Report Server Email' does exist in RSReportServer.config and is
configured
> with a value for <smtpserver> and a value for <from>.
> What is required for 'Report Server Email' to show up?
>|||Was using an IP address.
"Bruce L-C [MVP]" wrote:
> When I set this up I had trouble using a name for the server
> (servername.blah.com), I had to put in the IP address for it to work for me.
> Don't know why.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Jim" <Jim@.discussions.microsoft.com> wrote in message
> news:59D811E2-233E-45C4-BEFD-F313C9713E34@.microsoft.com...
> > When I try to create a new subscription no 'Report Server Email Delivery
> > Method' shows up.
> >
> > 'Report Server Email' does exist in RSReportServer.config and is
> configured
> > with a value for <smtpserver> and a value for <from>.
> >
> > What is required for 'Report Server Email' to show up?
> >
> >
>
>
Monday, March 19, 2012
New Reporting Control
Does the new report control for vs 2005 utilize SOAP or the URL method
to access the report server?
I need to utilize a pure SOAP based solution to get reports from the
report server. Just curious if the new solution is used that way or if
rolling my own is the only option.
ThanksThe new controls use soap (web services). They are a much more complete
solution that the old way.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Vivaldi" <ZachMattson@.gmail.com> wrote in message
news:1131634098.219113.321000@.g49g2000cwa.googlegroups.com...
> Does the new report control for vs 2005 utilize SOAP or the URL method
> to access the report server?
> I need to utilize a pure SOAP based solution to get reports from the
> report server. Just curious if the new solution is used that way or if
> rolling my own is the only option.
> Thanks
>
to access the report server?
I need to utilize a pure SOAP based solution to get reports from the
report server. Just curious if the new solution is used that way or if
rolling my own is the only option.
ThanksThe new controls use soap (web services). They are a much more complete
solution that the old way.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Vivaldi" <ZachMattson@.gmail.com> wrote in message
news:1131634098.219113.321000@.g49g2000cwa.googlegroups.com...
> Does the new report control for vs 2005 utilize SOAP or the URL method
> to access the report server?
> I need to utilize a pure SOAP based solution to get reports from the
> report server. Just curious if the new solution is used that way or if
> rolling my own is the only option.
> Thanks
>
Subscribe to:
Posts (Atom)