Showing posts with label crystal. Show all posts
Showing posts with label crystal. Show all posts

Thursday, March 29, 2012

Directly print to Printer

Hi,
I have a VB Application with Crystal Report 8. If I click the print button in VB, I dont want to show the Crystal Report. I want to print the contents of the report directly to the Printer without showing the report. Is there a way to do this?
Thanks in advance
MadhivananFrom memory, so.........please forgive any errors from failed memory......:-))

assumes using CR active x control:

Dim objPrintApp As CRAXDRT.Application
Dim objReport As CRAXDRT.Report

Set objPrintApp = New CRAXDRT.Application
Set objReport = objPrintApp.OpenReport(strReportSourcePath & strSourceFile)
objPrintApp.LogOnServerEx "pdsodbc.dll", "database", "database", "user", "pwd"

' set PromptUser to False, NumberOfCopies to value >=1
' all parameters in brackets are optional.
objReport.Printout [PromptUser], [NumberOfCopies], [Collated], [StartPageNumber], [StopPageNumber]

dave|||Thanks springsoft. I think this is for CR9 but what is the code for CR8?.

Madhivanan

Tuesday, March 27, 2012

diploying reports on browser with custom assembly

Hi friends,

We are using SQL Server Reportin Services 2005 (SSRS) for development of our reports instead of Crystal Reports. As per our clients requirement we want to make all reports dynamic eg. whatever background color user select should appear for that report etc etc.

So for this we have written one function and created DLL for that. Now we are refering that DLL in all our reports as Assembly Name in Reports \ Report Properties \ Referance. We have stored that DLL at two different locations also

C:\Program Files \Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin

C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies

so when we run our reports from Preview tab DLL is just wroking fine.

Then added the permission code in rspolicy.config file as follows,

<CodeGroup class="UnionCodeGroup"
version="1"
PermissionSetName="FullTrust"
Name="MyNewCodeGroup"
Description="A special code group for my custom assembly.">
<IMembershipCondition class="UrlMembershipCondition"
version="1"
Url="C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\bin\MyAssembly.dll"/>
</CodeGroup>

But when we deploy all our report on Brwoser and when we try to execute them from browser DLL is now working i.e no function value is working. only normal report without styleing is coming.

So can anyone help me out coz this is very argent

any help will be greatly appreciated

Custom assemblies always run with Full Trust in designer preview, so it's not suprising the code works there.

It's likely that you placed your codegroup in the wrong place inside the rssrvpolicy file...here's a blog post on same:

http://blogs.msdn.com/bimusings/archive/2005/06/16/429795.aspx

The info around "placement" in the policy file is still valid even though this post is about SSRS 2000

|||

hi Russell,

thx for help,

but whatever suggetions u hv told I have implement them.

ie changing the posting of full trust in *policy.config files ,

placing the DLL in Report Desinger folder etc etc but still no luck

I still cant see the effect of my DLL on browser.

are there any changes require to be done in Reporting Services Configurations ?

one thing I want to tell you is that while installing the Reporting Services I have given the Path in D folder and not C folder so , my 80 tools folder now is in C folder and 90 tools folder in D folder so because of this anything is going wrong ?

plz help me out if u can

sandeep

|||

Hey Sandeep --

What I was saying in my earlier post is that it doesn't matter if you put the "new" code group into the *.policy.config file if you place it in the wrong area of the file (or is this what you mean when you used the world "posting").

You have to put the code group in just the right spot for it to be used...If you put it in the wrong place, no errors will alert you that you've done something wrong, but your assembly won't get FullTrust, and therefore fail to execute.

|||

hi russell,

as u said in ur first post I have pasted my code in the place where u hv mensioned as followes

// Your Stuff goes here….
</CodeGroup>
</CodeGroup>
</PolicyLevel>

but still its not working

is there anything that we need to do with Report Server Confirguration ?

plz guide me

sandeep

|||

I've put my code-groub just below

<CodeGroup class="UnionCodeGroup" version="1"
PermissionSetName="FullTrust">
<IMembershipCondition
class="UrlMembershipCondition"
version="1"
Url="$CodeGen$/*"
/>
</CodeGroup>′

I think I've seen this "position-advice" somewhere in the docs but I can't find it any more ;(
[edit] found it: http://msdn2.microsoft.com/de-de/library/ms152828(SQL.90).aspx

Are you sure the path is correct?! In you very first post you wrote

..
So for this we have written one function and created DLL for that. Now we are refering that DLL in all our reports as Assembly Name in Reports \ Report Properties \ Referance. We have stored that DLL at two different locations also

C:\Program Files \Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin

C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies

so when we run our reports from Preview tab DLL is just wroking fine.

Then added the permission code in rspolicy.config file as follows,

<CodeGroup class="UnionCodeGroup"
version="1"
PermissionSetName="FullTrust"
Name="MyNewCodeGroup"
Description="A special code group for my custom assembly.">
<IMembershipCondition class="UrlMembershipCondition"
version="1"
Url="C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\bin\MyAssembly.dll"/>
</CodeGroup>
....

I can't see the MSSQL.3 anywhere in your URL

Have you looked at the log-files?|||

I have added the code group as follows,

<CodeGroup class="UnionCodeGroup"

version="1"

PermissionSetName="FullTrust"

Name="MyNewCodeGroup"

Description="A special code group for my custom assembly.">

<IMembershipCondition class="UrlMembershipCondition"

version="1"

Url="D:\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin\ReportStyle.dll"/>

</CodeGroup>

and location is also same as u hv mentioned

but still I cant see the reports on browser

so where exactly I am going wrong ?

plz help me

sandeep

|||Have you looked at the Logfiles? You should find them here:
D:\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles
In my case I included system.data.oracleclient in my dll wich didn't work as long as I didn't call the assert method of OraclePermissions..
So the logfiles should give a hint of whats going wrong..

|||

hi binny,

i hv deployed ones again. and saw reports on browser still it is shwing without DLL effect so i checked all log files. but they all are old log files and no related information is there

sandeep

Wednesday, March 7, 2012

Different Size Columns in Different Table Rows?

I'm trying to recreate something that I could do in Crystal Reports and have
hit a wall with Report Designer.
I want to create two (or more) header rows and two (or more) detail rows
with each column width different from the column width from the row above
(or below). I found how to add more header and detail rows but the column
widths remain the same for each row and cannot be adjusted separately. What
I'd like to to is to "merge" table columns for one report row into just one
column with the other row remaining as two columns.
For example, I want a report where the first row of detail contains multiple
columns that contains information about a database column, but then the next
detail row should only contain ONE column.
Type of Note Date of Note Author of Note
Note Text
---
Addendum 10/17/07 Shakespeare
This is the text of the note of an addendum written by Shakespeare
Is there a way to do this with RS, or is there some workaround?
Thanks for any help.Never mind (again) ;) I found the Merge Cells right-click command.
"Don Miller" <nospam@.nospam.com> wrote in message
news:%23HQrXMNEIHA.4752@.TK2MSFTNGP04.phx.gbl...
> I'm trying to recreate something that I could do in Crystal Reports and
> have hit a wall with Report Designer.
> I want to create two (or more) header rows and two (or more) detail rows
> with each column width different from the column width from the row above
> (or below). I found how to add more header and detail rows but the column
> widths remain the same for each row and cannot be adjusted separately.
> What I'd like to to is to "merge" table columns for one report row into
> just one column with the other row remaining as two columns.
> For example, I want a report where the first row of detail contains
> multiple columns that contains information about a database column, but
> then the next detail row should only contain ONE column.
> Type of Note Date of Note Author of Note
> Note Text
> ---
> Addendum 10/17/07 Shakespeare
> This is the text of the note of an addendum written by Shakespeare
> Is there a way to do this with RS, or is there some workaround?
> Thanks for any help.
>

Friday, February 24, 2012

Different Fields

I am using Crystal 10 and Access

I am going to try my best to explain what it is I would like to do.

I would like to find away to have data from different fields to display on a crystal report vertically/across from each other.

For Example:

Field1 Field2
PRD 300
LST 200
MET 205
MIS 650
TTP 745

What I would like is for the information to display on the crystal report like this:

PRD 745 200

As you can see from the fields above, the numbers 745 & 200 are not associated with PRD. I cannot seem to find a way to associate one field information from another field information.

Please let me know if I need to try to clear this up.are field1 and field2 of the same table? If so I'm not sure if that's possible. Even if it was I definately wouldn't recomend it. If not then you have another problem - grabbing 2 different records of the same field at the same time. Why is it that you want it to work like that? A little more information about it would certainly help :)

Friday, February 17, 2012

Differences in SQL server reporting and Crystal reports

What are the differences in SQL server reporting and Crystal Reports?

What are the pros and cons of using one or the other?

I know nothing about SQL server reporting, does anyone have any resources for it.

macca

Hi Macca

Our company specializes in CRM software and database management so we naturally do alot of reporting/business intelligence.

As with all types software purchases decisions are best made based on outcome requirements, ease of accomplishing short and long term objectives and price of course. In addition, its important to select a product based on in-house skill set as lots of software purchases go vastly underutilized because of complexity in reaching objectives.

There is another product though to SQL Reporting and CDecisions which we also utilize. Its a WEB based product called LogiXML which has a highly intuitive development interface and utilizes a really innovative approach over traditional report writing. The price is great, the features solid and the support tremendous. I would definately suggest you take a look at this as an alternative if you dont have alot of experience in the report writing area.

Kerri Groves
President
LookOut Software Inc.

|||You may want to checkout this article to find differences between Crystal and Reporting Services.

http://www.crystalreportsbook.com/SSRSandCR_ExecSummary.asp

Tuesday, February 14, 2012

Differences between Microsoft Report Services and Crystal Reports

hi,
can any one can send the differences between Microsoft
Reporting Services and Crystal Reports.
regards,
chakriserach in google:
http://groups.google.ca/groups?hl=en&lr=&ie=UTF-8&threadm=eX6NH0ZAEHA.3248%40TK2MSFTNGP11.phx.gbl&rnum=2&prev=/groups%3Fhl%3Den%26lr%3D%26ie%3DUTF-8%26q%3Dcomparison%2Bcrystal%2Breport%26meta%3Dgroup%253Dmicrosoft.public.sqlserver.reportingsvcs
"chakravarthy" <anonymous@.discussions.microsoft.com> a écrit dans le message
de news:79e201c476ed$26293ce0$a601280a@.phx.gbl...
> hi,
> can any one can send the differences between Microsoft
> Reporting Services and Crystal Reports.
>
>
> regards,
> chakri
>