Monday, August 27, 2012

Export Crystal Report to PDF using VB.Net for Download in your DotNetNuke site

The code below will force download of PDF version of you crystal report in DotNetNuke. This code is base on this article.
' Create a temporary filename
Dim strPDF As String = MapPath("Reports/TO" & Session.SessionID & ".pdf")

' Create report
Dim rpt As New TravelOrderList

' Set report params
'rpt.SetParameterValue("ReportTitle", "Report Title")
'rpt.SetParameterValue("ReportSubTitle", "Sub Title")

' Set report datasource
rpt.SetDataSource(ds)
Dim CrExportOptions As ExportOptions Dim CrDiskFileDestinationOptions As New DiskFileDestinationOptions() Dim CrFormatTypeOptions As New PdfRtfWordFormatOptions() CrDiskFileDestinationOptions.DiskFileName = strPDF CrExportOptions = rpt.ExportOptions With CrExportOptions .ExportDestinationType = ExportDestinationType.DiskFile .ExportFormatType = ExportFormatType.PortableDocFormat .DestinationOptions = CrDiskFileDestinationOptions .FormatOptions = CrFormatTypeOptions End With rpt.Export() ' Force download(in DNN) FileSystemUtils.DownloadFile(strPDF) ' Delete temp file IO.File.Delete(strPDF)

HTH



Tuesday, August 14, 2012

Bind all DotNetNuke portal alias to a dropdownlist

ddlPortalAlias.Items.Clear()
Dim objAlias As PortalAliasCollection = PortalAliasController.GetPortalAliasLookup()
For Each obj As System.Collections.DictionaryEntry In objAlias
   ddlPortalAlias.Items.Add(CType(obj.Value, PortalAliasInfo).HTTPAlias)
Next
ddlPortalAlias.SelectedValue = PortalSettings.DefaultPortalAlias

HTH



Monday, August 13, 2012

Update DesktopModule Category

The code below will add a new category to dotnetnuke module category list.
 ' Update module category
Dim desktopModule As DesktopModuleInfo = DesktopModuleController.GetDesktopModuleByModuleName("DNNSEO", Null.NullInteger)

DesktopModuleController.AddModuleCategory("Vivoware")

desktopModule.Category = "Vivoware"

DesktopModuleController.SaveDesktopModule(desktopModule, False, False)
For some reason I had to edit the desktop module, set the category and save for it to be visible in the list of modules when the category I created is selected. Screenshoot.
HTH



Tuesday, August 7, 2012

Failure Error: Unable to generate a temporary class...

I have encounter this error while installing DotNetNuke 6.2 in a new machine. and got the solution from a 1 year old blog entry. The Solution: Give IIS_IUSRS Full Access to Windows\Temp folder

Wednesday, August 1, 2012

How to prevent page scroll when showing jQuery Dialog

Sometimes showing a jQuery Dialog in a scrolling page sucks so to hide scroll bars(prevent scrolling) use the following code.
$( ".selector" ).dialog({
   open: function(event, ui) { jQuery("#Body").css("overflow", "hidden"); },
   close: function () { jQuery("#Body").css("overflow", "auto"); }
});
HTH